Red Squirrel Posted March 30, 2006 Share Posted March 30, 2006 I'm trying to restore a dump from phpmyadmin and this table is giving me issues. why wont this work?[code]mysql> CREATE TABLE catalog ( -> prod_id bigint(20) NOT NULL default '0', -> name varchar(255) NOT NULL default '', -> price bigint(20) NOT NULL default '0', -> short_desc text NOT NULL, -> desc text NOT NULL, -> picture varchar(128) NOT NULL default '', -> inventory bigint(20) NOT NULL default '0', -> shipping bigint(20) NOT NULL default '0', -> PRIMARY KEY (prod_id), -> KEY prod_id (prod_id) -> ) TYPE=MyISAM;ERROR 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 'desc text NOT NULL, picture varchar(128) NOT NULL default '',mysql> [/code] Quote Link to comment Share on other sites More sharing options...
Guest footballkid4 Posted March 30, 2006 Share Posted March 30, 2006 "desc" is a MySQL keyword, change references of desc to `desc` in your MySQL dump Quote Link to comment Share on other sites More sharing options...
Red Squirrel Posted March 30, 2006 Author Share Posted March 30, 2006 Really? But why does it work at the college, is it because we're using php/mysql on windows? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.