Andrew, Tuesday, May 14, 2002, 10:56:43 PM, you wrote: AL> 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.
AL> Thank you for the reply, Egor. Here is what I have tried since your reply AL> but it doesn't like my syntax.... AL> connect hostas; AL> CREATE TABLE hostas_01 (UNIQUE(Cultivar)) AL> SELECT AL> LML.ML_ID AL> LML.Cultivar AL> LML.Reg_Status AL> LML.Section AL> LML.Class AL> LML.ML_ITG_ID AL> LML.Reference AL> AHS.Registrant AL> FROM LML AL> INNER JOIN AHS AL> USING (Cultivar); I don't know exactly what you want :) I offered you some solutions of problems and you can use one of them. It depends on what you want. If you use CREATE .. SELECT with INNER JOIN, you can create table with rows that have the same value in Cultivar column. If you want to have table with all rows from LML and only update specific rows, you should use another way to do it. AL> So, that is where I am. I'm trying to avoid exporting to a spreadsheet or AL> another language -- I want to do this all within MySQL, if possible... AL> That's my problem. TIA for any help... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
