Is INSERT...SELECT atomic? [REPOST]

Does anyone know this? In the 4.0.17 and later build, the target table of an INSERT...SELECT can be the same as the SELECT table (insert into table1...select ...from table1). Does the process essentially happen in a natural lock? In other words, could the table change between the data retrieved

Is INSERT...SELECT atomic?

In the 4.0.17 and later build, the target table of an INSERT...SELECT can be the same as the SELECT table (insert into table1...select ...from table1). Does the process essentially happen in a natural lock? In other words, could the table change between the data retrieved in the select and the

Re: Getting Found Count When Using Limit

unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153

Re: No support for multiple statements via JDBC?

you do a transaction or table lock without multi statement support? -Allon Allon Bendavid Imacination Software [EMAIL PROTECTED]http

Re: Adding Columns to table

, LAst_Name VARCHAR(30) NOT NULL, address VAR CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail VARCHAR(20 ), Age INT); Allon Bendavid Imacination Software [EMAIL

No support for multiple statements via JDBC?

, and you can have a semicolon in the statement, but you cannot combine the statements. Are we missing something? How would you do a transaction or table lock without multi statement support? -Allon Allon Bendavid

Re: No support for multiple statements via JDBC?

Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153 Visit Imacination and start selling on the Web today

INSERT ... SELECT not supported?

Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153