SQL

[danny_dunks]

this is the sql for my streets

 

CREATE TABLE `streets` (

`id` int(11) NOT NULL auto_increment,

`min_level` int(11) NOT NULL,

`text` longtext NOT NULL,

`query` int(11) NOT NULL,

PRIMARY KEY (`id`)

) TYPE=MYISAM ;

INSERT INTO `settings` (`conf_id`, `conf_name`, `conf_value`) VALUES ('NULL', 'steps_daily', '100')

ALTER TABLE `users` ADD `steps` INT( 11 ) NOT NULL ;

 

and wen i run it i get this error

 

SQL query:

INSERT INTO `settings` ( `conf_id` , `conf_name` , `conf_value` )

VALUES (

'NULL', 'steps_daily', '100'

)

ALTER TABLE `users` ADD `steps` INT( 11 ) NOT NULL ;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `users` ADD `steps` INT( 11 ) NOT NULL' at line 3

 

can any1 help ?

 

thanks

[AlabamaHit]

Re: SQL

alter table users add steps int(11) not null default 100;

[Magictallguy]

Re: SQL

You need to end your INSERT query with the delimiter ";"

INSERT INTO `settings` VALUES (NULL, 'steps_daily', 100);