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?
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 IN
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]>
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 th
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]
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
username,framedipaddress,acctstarttime,acc
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 (the
using a
shell 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
Window
on UnixWare 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.
A
g 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
I Am running mysql to connect my linux mail database to MS Access database.
This all is not working anymore the mysql.sock is broken can this be
11 matches
Mail list logo
