4 messages in com.mysql.lists.win32RE: Creation of Table Fails
FromSent OnAttachments
Geocrawler.com23 Sep 1999 03:51 
Bob Kline23 Sep 1999 04:16 
Brian Andrews23 Sep 1999 04:27 
Candas Internet Services23 Sep 1999 04:40 
Subject:RE: Creation of Table Fails
From:Brian Andrews (bri@informate.co.nz)
Date:09/23/1999 04:27:41 AM
List:com.mysql.lists.win32

When I tried to insert a column named Limit in the Table named Users with the command line tool mysql the following error occurs:

ERROR 1064: parse error near 'Limit INT(11)) at line 1

To insert the Table I use the following Command

CREATE TABLE Users (Limit INT(11));

Which to me seems to be correct.

Limit is a reserved word. Use something else.

- brian.