List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 13 1999 8:35am
Subject:INSERT DELAYED
View as plain text  
>>>>> "Boaz" == Boaz Yahav <berber@stripped> writes:

Boaz> Hi
Boaz> This is a query made by mysqldump using the --delayed option.


Boaz> INSERT  DELAYED INTO BjC VALUES
Boaz> (5,'BJ','test','test','','','','1995','test@stripped','','','',
Boaz> '','choose','','','','HELLO!!!!!','12345','test','No','test','1999-04-14');

Boaz> When i try to get the data back in the database with 

Boaz> mysql -u test -p test < test.mysql i'm getting a syntax error :

Boaz> ERROR 1064: parse error near 'INTO BjC VALUES
Boaz> (5,'BJ','test','test','','','','1995','test@stripped','',''' at line 1

Hi!

This means that your MySQL server doesn't support INSERT DELAYED.
Fix:

Don't use the --delayed option.

Regards,
Monty

PS: Sorry for the long delay before replying, but I just come back from
    a 2 weeks vacation trip.
Thread
INSERT DELAYEDBoaz Yahav29 Oct
  • Re: INSERT DELAYEDBob Kline29 Oct
  • INSERT DELAYEDMichael Widenius13 Nov
RE: INSERT DELAYEDBoaz Yahav29 Oct
  • RE: INSERT DELAYEDBob Kline29 Oct