my sql导入数据问题
http://hi.baidu.com/harite/blog/item/6a5fb9de55e6f258ccbf1adf.html
我照这个地址来做导入的,可是很多数据导入不进去,不知道为什么,有其他的办法没有,还有就是
into hw_salehouse.apply (person, house, time, house_address, district_committee, house_total_price, status)values('刘跃', '长泰西郊别墅', 2011-10-26, '泗砖南路1500弄92号', '松江区', '1500万', '已审批')
报: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 'into hw_salehouse.apply (person, house, house_address, district_committee, house' at line 1
http://hi.baidu.com/harite/blog/item/6a5fb9de55e6f258ccbf1adf.html
我照这个地址来做导入的,可是很多数据导入不进去,不知道为什么,有其他的办法没有,还有就是
into hw_salehouse.apply (person, house, time, house_address, district_committee, house_total_price, status)values('刘跃', '长泰西郊别墅', 2011-10-26, '泗砖南路1500弄92号', '松江区', '1500万', '已审批')
报: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 'into hw_salehouse.apply (person, house, house_address, district_committee, house' at line 1
into hw_salehouse.apply
(person, house, time, house_address, district_committee, house_total_price, status)values
('刘跃', '长泰西郊别墅', '2011-10-26', '泗砖南路1500弄92号', '松江区', '1500万', '已审批')
--sorry 眼镜花了
http://hi.baidu.com/harite/blog/item/6a5fb9de55e6f258ccbf1adf.html
我照这个地址来做导入的,可是很多数据导入不进去,不知道为什么,有其他的办法没有,
2 bb
3 cc
4 dd
5 ee
6 gg
7 kk在TXT中这样的格式才是对的
然后再insert into