MySQL Forums
Forum List  »  Newbie

Problem with create table query
Posted by: Zulfi Khan
Date: November 20, 2014 01:09AM

Hi,
I am not able to run create table query. I have windows7 & mysql server 5.1

mysql> create table if not exists users(id unsigned int not null auto_increment,
name varchar (128), password varchar(128), primary key(id));
ERROR 1064 (42000): 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 'unsig
ned int not null auto_increment,name varchar (128), password varchar(128), ' at
line 1
mysql>

Some body please guide.
I have installed the software today.

Zulfi.

Options: ReplyQuote


Subject
Written By
Posted
Problem with create table query
November 20, 2014 01:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.