Hello:
Am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
on RH 7.2.
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
