On Tue, Apr 02, 2002 at 08:53:27AM -0600, Rick Emery wrote: > What happened when you tried this experiment?
I just did the following: In one client connection, issued 'lock tables outgoing write'. Then in another client connection, tried to do an 'insert delayed' without specifying the timestamp. This query finished right away but was not inserted. About a minute later, I issued 'unlock tables' in the first client. The row from the 2nd client was inserted, and it it had the timestamp value of the original delayed insert (not the current time after the unlock). So this answers my question, the value from the delayed temporary table is used. Thanks, Viraj. > -----Original Message----- > From: Viraj Alankar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 8:50 AM > To: [EMAIL PROTECTED] > Subject: insert delayed and timestamps > > > Hello, > > When using 'insert delayed' syntax and there is a timestamp field in the > table > but not specified in the insert query, which timestamp is actually used when > the record ends up in the destination table? In other words, will the > timestamp value be the actual timestamp that the record was inserted into to > the destination table (i.e. unknown at insert time) or the temporary > 'delayed' > table? It seems logical it would use the delayed table timestamp value, but > I > would like to confirm. > > sql > > Viraj. > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
