bash 与 mysql

[flyinflash]

add_boks.sh

代码： 全选

mysql -usglib -psglib;

use sglib;

INSERT INTO bok (bok_name, user_id) VALUE ('Ajax in Action', 1);
INSERT INTO bok (bok_name, user_id) VALUE ('Linux Manual', 2);
INSERT INTO bok (bok_name, user_id) VALUE ('CSS Mastery', 1);
INSERT INTO bok (bok_name, user_id) VALUE ('JavaScript ', 1);
INSERT INTO bok (bok_name, user_id) VALUE ('Beginning Linux Programming', 2);
INSERT INTO bok (bok_name, user_id) VALUE ('Unix Programming', 2);
INSERT INTO bok (bok_name, user_id) VALUE ('HTML Preference', 1);
INSERT INTO bok (bok_name, user_id) VALUE ('PHP Preference', 2);
INSERT INTO bok (bok_name, user_id) VALUE ('Gentoo Preference', 1);
INSERT INTO bok (bok_name, user_id) VALUE ('Freedom Ally', 1);

怎么实现 /bin/sh add_boks.sh 加入书籍？

[bones7456]

把SQL保存成脚本,运行.

[yaoms]

mysql < xxx.sql