On Tuesday 14 May 2002 06:10 am, Egor Egorov wrote: > If not, can I write the Query results of the SELECT statement out to a > new table and delete the original table? > > Yes, you can use CREATE ... SELECT statement.
Thank you for the reply, Egor. Here is what I have tried since your reply but it doesn't like my syntax.... connect hostas; CREATE TABLE hostas_01 (UNIQUE(Cultivar)) SELECT LML.ML_ID LML.Cultivar LML.Reg_Status LML.Section LML.Class LML.ML_ITG_ID LML.Reference AHS.Registrant FROM LML INNER JOIN AHS USING (Cultivar); To look at the actual data, go here http://dev.hostahaven.com/cgi-bin/mysqlman/mysql.cgi use host = localhost User = hostas Password = hostas (I hope I have the security high enough that nobody will steal my hostas!) Select the hostas database. You'll see the LML table and the AHS table. What I want to do is move the value for "Registrant" in the AHS table to Registrant in the LML table (using Cultivar at the record key). If I can do that with a JOIN statement WITHIN the mySQLMan package, I don't know how, and unfortunately, I have not been able to get the phpMyAdmin to load.... So, that is where I am. I'm trying to avoid exporting to a spreadsheet or another language -- I want to do this all within MySQL, if possible... That's my problem. TIA for any help... -- Andrew Lietzow The ACL Group, Inc. --------------------------------------------------------------------- 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
