Create table like

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

Re: Create table like

On Tue, 31 Oct 2006 16:38:46 GMT, "The Eclectic Electric"
wrote:

>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);
>
>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

What version of the MySQL server are you running?

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool