-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Benjamin, et al --
Thanks for all of the help and info. Lots to learn and read :-) ...and then Benjamin Pflugmann said... % ... % % And you have variables. If the above wouldn't work you could write: % % SELECT @card_hash := hash FROM ccard WHERE ccards.id = LAST_INSERT_ID(); % INSERT INTO clientcards VALUES ( '' , 1, 1, 1, @card_hash ); Aha! This is exactly what I sought. So that's how it's done :-) Again, in the specific case in mind I'll be entering the single number and can easily stuff the md5 sum [which I'll calculate just as easily as mysqld would] into both tables, but ... % % % Of course, that's only possible if you can live with being % MySQL-specific. Hmmm... so it's a mysql thing and not a SQL thing. Well, I'd like to avoid that, even though I like mysql... % % HTH, % % Benjamin. % % % -- % [EMAIL PROTECTED] Thanks & HAND & HH :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+D1lMGb7uCXufRwARAtDZAJ97FHKovuMjDmRUuEkKX4whVYXhHQCfWowu oIN0lJ56xASB3HZgvGgN3T4= =YF2l -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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