先准备一个演示用的SQL脚本 demo.sql
[sql]
SET NAMES UTF8;
CREATE TABLE cc (
`account_id` mediumint(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`account_id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO cc VALUE(1);
INSERT INTO cc (2);
INSERT INTO cc VALUE(3);
将SQL文件导入到数据库test
[plain]
# cat demo.sql | mysql -u root test
ERROR 1064 (42000) at line 9: 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 '2)' at line 1
报告错误。从提示信息里看到,出错的语句是第9行。检查一下
[plain]
# tail -n +9 demo.sql | head -1
INSERT INTO cc (2);
9 前面的+号表示从文件头部开始计算的第9行。发现一个句法错误。用sed 替换某一行
[plain]
# sed -i '9s/.*/INSERT INTO cc VALUE(2);/' demo.sql
替换完成。接着刚才出错的地方继续导入
[plain]
# tail -n+9 demo.sql | mysql -u root test
看看数据库,数据都在,导入成功
[sql]
mysql> select * from cc;
+------------+
| account_id |
+------------+
| 1 |
| 2 |
| 3 |
+------------+
3 rows in set (0.00 sec)来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23490154/viewspace-1063773/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23490154/viewspace-1063773/