Hi Tim, On Fri, 2002-05-10 at 11:53, Tim Johnson wrote: > I'm not usually this lucky, but it seems that the trick is > to let mysql do more of the work, and I'm happy to go > along with that: > What I needed is > CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR; > (with EurCount being nonexistant)
Indeed, will work. But the below can also be done with INSERT ... SELECT ... if the table already exists. http://www.mysql.com/doc/I/N/INSERT_SELECT.html The "SELECT INTO ..." syntax is an Oracle construct (not part of SQL-92 or SQL-99), and MySQL does not currently support that variation. > I would appreciate to be pointed to further docs on > this topic all the same. The online manual can be found at http://www.mysql.com/doc/ Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep 2002, https://order.mysql.com/?marl __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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
