下面的一堆数据:
Afghanistan
Africa
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua & Barbuda
Antilles, Netherlands
Arabia, Saudi
Argentina
Armenia
Aruba
Asia
Australia
Austria
Azerbaijan
Bahamas, The
Bahrain
Bangladesh
Barbados我想插入到数据库的一个表的一个字段里面,一个一行,这个有什么好办法没?我用下面的sql失败, 不知道有什么好的方法??select Afghanistan
union all
select Africa
union all
select Albania
union all
select Algeria
union all
select American Samoa
union all
select Andorra
union all
select Angola
union all
select Anguilla
union all
select Antarctica
union all
select Antigua & Barbuda
union all
select Antilles, Netherlands
union all
select Arabia, Saudi
union all
select Argentina
union all
select Armenia
union all
select Aruba
union all
select Asia
union all
select Australia
union all
select Austria
union all
select Azerbaijan
union all
select Bahamas, The
union all
select Bahrain
union all
select Bangladesh
union all
select Barbados
Afghanistan
Africa
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua & Barbuda
Antilles, Netherlands
Arabia, Saudi
Argentina
Armenia
Aruba
Asia
Australia
Austria
Azerbaijan
Bahamas, The
Bahrain
Bangladesh
Barbados我想插入到数据库的一个表的一个字段里面,一个一行,这个有什么好办法没?我用下面的sql失败, 不知道有什么好的方法??select Afghanistan
union all
select Africa
union all
select Albania
union all
select Algeria
union all
select American Samoa
union all
select Andorra
union all
select Angola
union all
select Anguilla
union all
select Antarctica
union all
select Antigua & Barbuda
union all
select Antilles, Netherlands
union all
select Arabia, Saudi
union all
select Argentina
union all
select Armenia
union all
select Aruba
union all
select Asia
union all
select Australia
union all
select Austria
union all
select Azerbaijan
union all
select Bahamas, The
union all
select Bahrain
union all
select Bangladesh
union all
select Barbados
union all
select 'Africa'
....你自己二楼不已经给出答案了吗?
mysql> load data infile '/a/a' into table a(a);
ERROR 1085 (HY000): The file '/a/a' must be in the database directory or be readable by all
mysql> load data infile '/a/a' into table aa.a fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
ERROR 1085 (HY000): The file '/a/a' must be in the database directory or be readable by all
mysql> load data infile a.txt into table a(a);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a.txt into table a(a)' at line 1
mysql> load data infile a.txt into table a;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a.txt into table a' at line 1
mysql> load data infile 'a.txt' into table a;
Query OK, 4 rows affected (0.02 sec)
Records: 4 Deleted: 0 Skipped: 0 Warnings: 0