From: Kevin P. O'Brien
Date: March 11 1999 2:25pm
Subject: Re: AUTO_INCREMENT Limits to 256 records
List-Archive: http://lists.mysql.com/mysql/62
Message-Id: <199903112225.OAA07699@ark.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Thanks Fred,

	That did it. I wasn't sure what to put into the auto_increment field.

	NULL works. Now I just have to fix little syntax errors in the rest of my data.

Many thanks to all of you who contributed on this.

Thanks again Fred.

.....back to work!!  :(

On Thu, 11 Mar 1999 16:15:49 -0600, Fred Lindberg wrote:

>On Thu, 11 Mar 1999 14:00:21, Kevin P. O'Brien wrote:
>
>>INSERT INTO Tickets  VALUES   (TicketNumber, 'LoginID','Contact','Contact PH','11-03-1998','08:00','12-03-1998
>>','11:00','PC','Problem','y','Resolution','Comments','Joe','10:00')\g
>
>Maybe I don't understand this, but I usually enter NULL into
>autoincrement fields. What is the VALUE TicketNumber?
>
>
>-Sincerely, Fred
>
>(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)
>
>

Regards,


Kevin P. O'Brien, MCP, CPST <kevino@stripped>
Systems Administration
Irenyx Data Group, Inc.
(Office) 1.250.334.9641 ext.239
(Fax)     1.250.334.2365
(Pager) 1.888.805.3820
(Toll Free) 1.800.275.4260 ext.239


PGP Public Key Fingerprint: 56C4 2F8C 5731 08C1  684D 05DC 05E5 697F