文本内容
1,"zhangsan","f"
2,"lisi","m"
3,"zhaoliu","f"
建表
create table mytable(
id int(20),
name varchar(20),
gender char(1)
);
把文本内容写到表中
load data infile 'f:b.txt' replace into table mytable
fields terminated by ',' enclosed by '"'
lines terminated by '\n'(`id`,`name`,`gender`);
mysql> load data infile 'f:b.txt' replace into table mytable
-> fields terminated by ',' enclosed by '"'
-> lines terminated by '\n'(`id`,`name`,`gender`);
ERROR 1406 (22001): Data too long for column 'gender' at row 1
怎么把文件里的内容写到表中啊!!!!!
1,"zhangsan","f"
2,"lisi","m"
3,"zhaoliu","f"
建表
create table mytable(
id int(20),
name varchar(20),
gender char(1)
);
把文本内容写到表中
load data infile 'f:b.txt' replace into table mytable
fields terminated by ',' enclosed by '"'
lines terminated by '\n'(`id`,`name`,`gender`);
mysql> load data infile 'f:b.txt' replace into table mytable
-> fields terminated by ',' enclosed by '"'
-> lines terminated by '\n'(`id`,`name`,`gender`);
ERROR 1406 (22001): Data too long for column 'gender' at row 1
怎么把文件里的内容写到表中啊!!!!!
解决方案 »
- 请教:如何优化这条sql?
- 列出各个部门中工资高于本部门的平均工资的员工数和部门号中碰到的问题(请高手指教)
- mysql 插入gzcompress后的数据总是 ‘x’,为什么
- 如何从基础开始学习MYSQL
- “mysql安装配置问题”及“数据库导入eclipse”问题
- postgresql 数据查询优化问题?
- 请教MySQL怎样实现双向同步?
- win2k +j2sdk1.4.2_01+MySQL Server 4.1+Tomcat 4.1 配置出错?
- 怎样保护MSSQL的数据库不会被别人盗用
- 关于起动mysql4.1的问题
- C# oledb方式连接mysql 查询报错
- 【求推荐】MYSQL源码分析类书籍
Data too long for column 'gender' at row 1
提示说导入的gender字段数据太长了