PDA

View Full Version : Inserting rows into the user table


Yours Truly
07-08-2007, 10:13 AM
INSERT INTO `user` ADD `row_i_wanna_add` INT( 11 ) NOT NULL ;
INSERT INTO `user` ADD `row_i_wanna_add` INT( 11 ) NOT NULL ;


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';



INSERT INTO `user` ADD `row_i_wanna_add` INT( 11 ) NOT NULL ;
INSERT INTO `use' at line 1

What am i doing wrong? =]

Dismounted
07-08-2007, 10:17 AM
ALTER TABLE `user`
ADD
(
`row_i_wanna_add` INT( 11 ) NOT NULL,
`row_i_wanna_add` INT( 11 ) NOT NULL
)

Yours Truly
07-08-2007, 10:19 AM
Ooh thankies =D