my sql error 1064

January 25, 2010 at 01:20:25
Specs: Windows XP
hi i am using window os n mysql 5.1 and using gui tool 5.0 when i m creating trying to create simple table code is
CREATE TABLE `quickservice`.`user_info` (
`uer_id` VARCHAR,
`user_pwd` VARCHAR(45) NOT NULL,
PRIMARY KEY (`uer_id`)
i got error
error while excuting query
my sql error 1064

See More: my sql error 1064

Report •

January 26, 2010 at 08:50:08
I don't use the GUI tool, so I can only guess; I think your SQL syntax is incorrect. I think it would be something like this:

# untested
CREATE TABLE `quickservice`.`user_info` (
`user_pwd` VARCHAR(45) NOT NULL

I do not recommend using a varchar as a prijmary key.

I am assuming the quotes have something to do with the GUI. I don't need them using the MySQL CLI.

Report •
Related Solutions

Ask Question