Miquel, Using version 3.23.53. Don't know what version the db I'm trying to access was created on, but the tables are MYISAM. Example below. I also get the same error using LOAD DATA and through .NET using MySQLDriverCS.
-------------- mysql> describe main_categories; +----------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-------------+------+-----+---------+-------+ | category_id | int(3) | | PRI | 0 | | | category_description | varchar(40) | | | | | | category_label | varchar(50) | YES | | NULL | | +----------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.03 sec) mysql> insert into main_categories values (1, 'Test Catagory', 'Test Label'); ERROR 2013: Lost connection to MySQL server during query mysql> --------------- Thanks Mark -----Original Message----- From: miguel solórzano [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 09:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Insert error At 16:50 26/11/2002 +0000, [EMAIL PROTECTED] wrote: Hi, >I'm running MySQL as a service on win2k and trying to insert data into a >database. Each time I try to do this I receive the following error: > >"ERROR 2013: Lost connection to MySQL server during query" > >The following error was shown when I opted to debug: > >"Unhandled exception at 0x004803c9 in mysqld-nt.exe: 0xC0000005: Access >violation reading location 0x00ed3000." > >I then have to exit mysql and restart the service. > >I know my SQL's correct, and I can insert into other databases no problem. Certainly you found a bug even the SQL statement is or not correct, however we need more information from you for to begin the fix process, please send us the version are you using and a test case. For to report bugs you find more information at: http://www.mysql.com/doc/en/Bug_reports.html Thanks you for to report. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Săo Paulo - Brazil <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
