#!/bin/bash
HOSTNAME="127.0.0.1"
USER="root"
PWD="123"
DATABASE="test"
TABLE_INFO="user"
#info表数据
/home/work/.jumbo/bin/mysql -h$HOSTNAME -u$USER -p$PWD $DATABASE << EOF 2>/dev/null
#select * from $TABLE_INFO;
INSERT INTO $TABLE_INFO(userid,username,sex) VALUES('q','s','w');
EOF
HOSTNAME="127.0.0.1"
USER="root"
PWD="123"
DATABASE="test"
TABLE_INFO="user"
#info表数据
/home/work/.jumbo/bin/mysql -h$HOSTNAME -u$USER -p$PWD $DATABASE << EOF 2>/dev/null
#select * from $TABLE_INFO;
INSERT INTO $TABLE_INFO(userid,username,sex) VALUES('q','s','w');
EOF