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 ti

Re: Getting Found Count When Using Limit

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 > ---

Re: Adding Columns to table

Table 'customers' already exists >> mysql> create table customers (Customer_ID INT NOT NULL PRIMARY KEY >> AUTO_INCREME >> NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address >> VAR >> CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail >> VARCHAR(20 >&

Re: No support for multiple statements via JDBC?

these statements >> on their own, 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? >> >>

Re: No support for multiple statements via JDBC?

quot; <[EMAIL PROTECTED]> wrote: > At 16:45 -0800 3/19/02, Allon Bendavid wrote: >> Hi All- >> >> We are using the mm driver for MySQL and multiple statements in one >> connection do not seem to be supported: > > No. Multiple statements in one *string* are n

Re: INSERT ... SELECT not supported?

DuBois' book "MySQL" from New > Riders. > > --jeff > > - Original Message - > From: "Allon Bendavid" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, March 18, 2002 7:57 PM > Subject: INSERT ... SELECT not supported? >

No support for multiple statements via JDBC?

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

INSERT ... SELECT not supported?

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