Posted by Andy Hassall on 10/31/06 18:40

On Tue, 31 Oct 2006 16:38:46 GMT, "The Eclectic Electric"
<nospam@spamispoo.spam> 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

• Next in forum: how to hide an error message
• Prev in forum: Create table like
• Thread view: Re: Create table like

[Reply to this message]