Insert into multiple tables using auto_increment reference

Hi, Is it possible to insert values into two tables simultaneously and have the value of one of the columns in the second table be the auto_increment value from inserting into the first? E.g. if table1 has an auto_increment column c1, the logic I'm looking for would be something like: INSERT

Re: Insert into multiple tables using auto_increment reference

On 6/11/07, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Hamish Allan wrote: Hi, Is it possible to insert values into two tables simultaneously and have the value of one of the columns in the second table be the auto_increment value from inserting into the first? No, because you can only

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

Gleb: Aha. OK, we tried using OPTIMIZE instead of ANALYZE, and that does indeed update the Cardinality of the index, the way you would expect. Thanks very much for figuring this out! I really appreciate the help. Thanks again! Allan Gleb Paharenko [EMAIL PROTECTED] wrote in message news

SELECT/JOIN performance on temporary tables depends on timing of index creation

or after the addition of data makes a difference on SELECT performance? Allan Miller -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT/JOIN performance on temporary tables depends on timing of index creation

and it did not make things any faster. Do you have any idea why creating the index AFTER putting the data in the table affects the performance so dramatically? Allan Gleb Paharenko [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello. Why is it that adding an index before or after

radius account management using sql

Hello, We have radius server and using mysql. I would like to determine who are the users who have not login to our dialup server for over six months and then disable the account In the example below, I'm just using 10 days mysql SELECT distinct

How to report MySQL bug

How do I report bugs in MySQL CC? I have seen a consistent bug in 85 and 86. Would like to report but not sure how?? Passion and Presence Allan Hardy - Before posting, please check: http://www.mysql.com/manual.php

Problem with MySQL-GUI

program in /etc/profile.d/mysqlgui.sh and I even exported the value of PATH. At present, my version of MySQL-GUI is in /usr/local/mysqlgui. Any help would be appreciated. Sincerely, Allan J Horwitz P.S. -- I don't remember it being this difficult with Windows98. In Windows, you just unzipped

RE: Licensing terms for an Intranet site

as a repository for our business data. We voted with our dollars and purchased a license for MySQL, even though we didn't need to. In a get-what-you-pay-for market, if MySQL works for you, you might consider such a purchase. Better chance of them being around tomorrow. Allan Clark Caldera Professional

test SQL statement? ie Parse but do not execute SQL statement?

the statement to the mysqld. I'm asking for some way to tell the mysqld to parse the statement, but not run it -- some kind of NOOP SELECT * FROM ... or NOOP DELETE FROM users WHERE... Is there such a capability now? Allan