bash 与 mysql
发表于 ： 2008-03-18 23:11
add_boks.sh
怎么实现 /bin/sh 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);