Create table fails

Hello -

Trying to create a simple table in MySql (using the command prompt).

CREATE TABLE products (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
products TEXT,
desc TEXT,
sku TEXT,
productDate DATE NOT NULL
);

But I get an error at line 3 (erro 1064). What's wrong? And is there a GUI interface I can use to add tables (with fields) and drop tables?

TIA-

RB
routerboy309Asked:
Who is Participating?
 
lokeshvCommented:
"desc" is keyword in mysql ..you cant use it as column name


change it to somehting else...


hope this helps...

LK
0
 
axis_imgCommented:
[And is there a GUI interface I can use to add
tables (with fields) and drop tables?]

Yes. The most widely used GUI for mysql is PHPMyAdmin. You can find it here:

http://www.phpwizard.net/projects/phpMyAdmin/

It is fairly user-friendly. The documentation for phpmyadmin can be found here:

http://phpmyadmin.sourceforge.net/documentation/

Hope that helps...
Barry
0
 
dkjariwalaCommented:
Check out mysql manager. Its a standalone application.

It really shines when you want to relate different mysql tables.

JD
0
 
routerboy309Author Commented:
That did it!

Thanks-

RB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.