ERROR mysqld.exe

[Arman FromKZ]

ver. 5.0.45-community-nt


CREATE TABLE `test` (
`D` int(11) unsigned NOT NULL default 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT `test` VALUES (DEFAULT);


CREATE TABLE `test2` (
`D` int(11) unsigned NOT NULL default 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
INSERT `test2` VALUES (DEFAULT);


INSERT INTO `test` (`D`)
SELECT
*
FROM `test2`
ON DUPLICATE KEY UPDATE `D`=DEFAULT;


---------------------------------------------------------------
Error

SQL query:

INSERT INTO `test` ( `D` )
SELECT *
FROM `test2` ON DUPLICATE
KEY UPDATE `D` = DEFAULT

MySQL said:
#2013 - Lost connection to MySQL server during query
---------------------------------------------------------------



Edited 1 time(s). Last edit at 07/15/2008 07:02PM by Arman FromKZ.