Hi all,
Is there any reason why I can't do something like any of the following?
SET @blah := SHOW VARIABLES LIKE 'server_id';
SHOW @blah := VARIABLES LIKE 'server_id';
It doesn't seem to work no matter which combinations of syntax I try.
Is setting user variables only supported via the SET and SELECT statements?
I think it's a shame that setting variables from SHOW results is missing. I
think that this functionality should be added to MySQL as it could be handy
in some places.
(For those who are wondering, I'm attempting to come up with a neat solution
to avoid using auto-increment columns with co-replication between two MySQL
servers. My idea was to have the server itself come up with a unique ID
consisting of something like the current timestamp plus a random number plus
the server's ID, rolled up into a concise hash value. My PHP script would
perform a query like above when it first connects and then uses the saved
user-variable in all subsequent queries where a unique ID is required.)
Regards,
Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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