Hello Again:
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)
I would appreciate to be pointed to further docs on
this topic all the same.
regards
-tim-
> I would like to construct a mysql command that select a unique
> set of data from one table and creates a table with that
> data.
>
> I think I'm close here, but am still getting errors:
> The query string is as follows:
>
> mysql> LOAD DATA
> -> SELECT DISTINCT Country from EUR
> -> INTO TABLE EurCount;
> ERROR 1064: You have an error in your SQL syntax near 'SELECT DISTINCT
>Country from EUR
> INTO TABLE EurCount' at line 2
> 1)SELECT DISTINCT Country from EUR; # executes without error as a stand-lone
>command
> 2)EurCount has been created as follows:
> CREATE TABLE `EurCount` (Country CHAR (255));
> 3)The Country column in EurCount has the same data type and size
> CHAR (255) as the Country column in EUR
>
> 1)Is my approach workable?
> If so, I'd appreciate help correcting syntax
> 2)Being pointed to documentation would be greatly appreciated
> 3)I would also like to find list of mysql ERROR codes
>
> TIA
> Regards
> --
> Tim Johnson <[EMAIL PROTECTED]>
> http://www.alaska-internet-solutions.com
> http://www.johnsons-web.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
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.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
