List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:January 11 2000 3:00pm
Subject:Re: table naming problem?
View as plain text  
At 3:11 AM -0500 01-11-2000, Inedag@stripped wrote:
>C:\MYSQL\BIN\MYSQLD.EXE  Ver 3.21.29a-gamma-debug for Win95 on i586
>
>When trying to create a table named "Lines" in any database, it fails:
>
>mysql> create table Lines(foo int);
>ERROR 1064: parse error near 'Lines(foo int)' at line 1
>mysql>
>
>If I change the table name != "Lines":
>
>mysql> create table NotLines(foo int);
>Query OK, 0 rows affected (0.11 sec)
>
>mysql>
>
>What is going on here? I don't remember anything like this from the manual.
>TIA.

LINES is a reserved word.  See, for the example, the syntax for the LOAD
DATA statement, where it is used as such.

-- 
Paul DuBois, paul@stripped
Thread
table naming problem?Inedag11 Jan
  • Re: table naming problem?Paul DuBois11 Jan