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
>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
table naming problem?Inedag11 Jan
  • Re: table naming problem?Paul DuBois11 Jan