#! /bin/bash 

U=userid

P=password

insert="insert into table_name(columns1, columns2) values (values1, values2)"

/usr/bin/mysql -u$U -p$P >> eof
$insert

>> sh ***.sh

----------------------------------------------------------------------------------------

table count

select count(*) from table_name

table numbers

可用 default value

[Reference]

http://stackoverflow.com/questions/13814413/how-to-auto-login-mysql-in-shell-scripts

http://phorum.study-area.org/index.php?topic=15790.0

http://stackoverflow.com/questions/8753371/how-to-insert-data-to-mysql-having-auto-incremented-primery-key