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
>If I change the table name != "Lines":
>mysql> create table NotLines(foo int);
>Query OK, 0 rows affected (0.11 sec)
>What is going on here? I don't remember anything like this from the manual.
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