请教怎样用text文本为表导入数据 是纯数据?还是带SQL的数据? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 纯数据:mysql> use your_dbname;mysql> load data local infile "绝对路径/文件名" into table "表名"带SQL语句的数据linux> mysql -uroot -ppassword < "绝对路径/文件名" 我在输入纯数据到text文本时,每个字段间用tab键隔开,一行就是一条信息。但是照你的方法导入后,表格的字段出现了不相匹配的情况。我输入的是:whistler gwen bird \n 1997-12-09 \nHitler poly dog \n 1998-04-23 \n而输出的是:+----------+-------+---------+------+------------+------------+| name | owner | species | sex | birth | death |+----------+-------+---------+------+------------+------------+| whistler | gwen | bird | | 1997-12-09 | 0000-00-00 || Hitler | poly | dog | | 1998-04-23 | 0000-00-00 |+----------+-------+---------+------+------------+------------+请问这是怎么回事啊?这个问题如何解决呢? 应该不会有问题啊?!CREATE TABLE test5(name varchar(16), owner varchar(16), species varchar(16), sex int, birth date, death date);文件text.txt:whistler gwen bird \n 1997-12-09 \nHitler poly dog \n 1998-04-23 \nSELECT * FROM test5输出:+----------+-------+---------+------+------------+------------+| name | owner | species | sex | birth | death |+----------+-------+---------+------+------------+------------+| whistler | gwen | bird | 0 | 1997-12-09 | 0000-00-00 || Hitler | poly | dog | 0 | 1998-04-23 | 0000-00-00 |+----------+-------+---------+------+------------+------------+ 纯数据文件中各字段间除了TAB隔开,不要使用空格! 怎么也添加不了用户,这为啥啊 小妹请教调用带参数的存储过程报错问题! MySQL中的LIKE字段用的通配符除了%_[]还有其他的么? Mysql Update有办法返回影响的记录集吗? PostgreSQL性能问题 支招:用mysql是否安全? mysql数据库问题 真的希望,哪位高手帮一忙!! 左连接之后排序出现问题,求各位帮忙看看 mysql 多对多映射关系的筛选SQL怎么写 急刹我也! 什么开发和mysql结合紧密,什么方式连接?
mysql> use your_dbname;
mysql> load data local infile "绝对路径/文件名" into table "表名"
带SQL语句的数据
linux> mysql -uroot -ppassword < "绝对路径/文件名"
whistler gwen bird \n 1997-12-09 \n
Hitler poly dog \n 1998-04-23 \n
而输出的是:
+----------+-------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+------------+
| whistler | gwen | bird |
| 1997-12-09 | 0000-00-00 |
| Hitler | poly | dog |
| 1998-04-23 | 0000-00-00 |
+----------+-------+---------+------+------------+------------+
请问这是怎么回事啊?这个问题如何解决呢?
whistler gwen bird \n 1997-12-09 \n
Hitler poly dog \n 1998-04-23 \nSELECT * FROM test5
输出:
+----------+-------+---------+------+------------+------------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+------------+
| whistler | gwen | bird | 0 | 1997-12-09 | 0000-00-00 |
| Hitler | poly | dog | 0 | 1998-04-23 | 0000-00-00 |
+----------+-------+---------+------+------------+------------+