routerboy309
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check out mysql manager. Its a standalone application.
It really shines when you want to relate different mysql tables.
JD
It really shines when you want to relate different mysql tables.
JD
ASKER
That did it!
Thanks-
RB
Thanks-
RB
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