• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

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
0
routerboy309
Asked:
routerboy309
1 Solution
 
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now