Posted by The Eclectic Electric on 10/31/06 16:38

Can anyone tell me what is invalid about this? The table items definitely
exists and looks like it matches the spec:
http://dev.mysql.com/doc/refman/4.1/en/create-table.html It's doing my head
in - I thought I'd finished.

Thanks in advance. I also tried CREATE TABLE newuser (LIKE items);

+e


CREATE TABLE newuser LIKE items;
Error adding user table to database: 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 'LIKE items' at line 1

• Next in forum: Re: Create table like
• Prev in forum: select rand() from top 10
• Thread view: Create table like

[Reply to this message]