mysql从文件导入SQL文，批量执行

文件存为：LanguageInsert.sql

 

alter table LANGUAGE character set utf8;
DELETE FROM LANGUAGE WHERE SEQ > '001';
INSERT INTO LANGUAGE VALUES('001','','','');
INSERT INTO LANGUAGE VALUES('002','','','');
INSERT INTO LANGUAGE VALUES('003','ADF','ASDF','ASDF');
INSERT INTO LANGUAGE VALUES('004','函阿士大夫','','');
INSERT INTO LANGUAGE VALUES('005','ｶﾀﾅﾅ','','');
INSERT INTO LANGUAGE VALUES('006','カタカナ','','');
SELECT * FROM LANGUAGE;

 

执行:

mysql> source /home/l/x/userId/sh_test/LanguageInsert.sql

 

备注： 此程序运行于 Solaris 10 11/06 s10x_u3wos_10 X86