MySql syntax error while trying to create a table

Question

I am trying to create a table in my database (hosted with godaddy)

when ever I try to create a table in the database it gives me an error

#1046 - No database selected

So I am trying to create a table like this

USE orderformuser

CREATE TABLE `users`(
`user_id` int NOT NULL AUTO_INCREMENT,
`username` char(25),
`password` char(40),
UNIQUE (User_Id)
)

However I am getting this error now.. and I just don't know what I am doing wrong

#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 'CREATE TABLE `users`(
`user_id` int NOT NULL AUTO_INCREMENT,
`username` char(2' at line 3

any help would be appreciated

John Woo · Accepted Answer · 2012-09-26 08:37:38Z

4

You forgot to add semicolon ; after use .... ; is used to terminate lines in mysql.

USE orderformuser;

CREATE TABLE `users`
(
   `user_id` int NOT NULL AUTO_INCREMENT,
   `username` char(25),
   `password` char(40),
   CONSTRAINT u_pk PRIMARY KEY (User_Id)
);

answered Sep 26, 2012 at 8:37

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

John Woo Over a year ago

@HurkNburkS i think CONSTRAINT u_pk PRIMARY KEY (User_Id) should best fit in your table. PRIMARY KEY are unique indexes.

Alessandro Minoccheri Over a year ago

According to @John Woo, CONSTRAINT u_pk PRIMARY KEY (User_Id) is the best way +1

HurkNburkS Over a year ago

right okay thanks very much! this worked perfectly.. I found out one of my issues was I was using my user account to enter the sql editor not the DB user.

Alessandro Minoccheri · Accepted Answer · 2012-09-26 08:39:16Z

2

First of all you have to create a blank database orderformuser. After you have to entry into this database and try to create the table with your code changed because you have forgot ";" like this:

USE orderformuser;
CREATE TABLE `users`
(
`user_id` int NOT NULL AUTO_INCREMENT,
`username` char(25),
`password` char(40),
UNIQUE (User_Id)
)

answered Sep 26, 2012 at 8:39

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Collectives™ on Stack Overflow

MySql syntax error while trying to create a table

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related