#!/bin/bashHOSTNAME="192.168.111.84" #数据库信息PORT="3306"
USERNAME="root"
PASSWORD=""DBNAME="test_db_test" #数据库名称TABLENAME="test_table_test" #数据库中表的名称#创建数据库create_db_sql="create database ${DBNAME} IF NOT EXISTS ${DBNAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${create_db_sql}"#创建表create_table_sql="create table ${TABLE} IF NOT EXISTS ${TABLENAME} ( name varchar(20), id int(11) default 0 )"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME}-e"${create_table_sql}"#插入数据insert_sql="insert into ${TABLENAME} values('billchen',2)"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME}-e"${insert_sql}"#查询select_sql="select * from ${TABLENAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME}-e "${select_sql}"#更新数据update_sql="update ${TABLENAME} set id=3"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"#删除数据delete_sql="delete from ${TABLENAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${delete_sql}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"--------------------------------------------<?php
$sql = '"CREATE TABLE `test`.`params` (`id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,`section` varchar(30) NOT NULL,`param` varchar(30) NOT NULL,`value` varchar(50) NOT NULL)"';
$cmdArr = array(
'd:\\xampp\\mysql\\bin\\mysql -uroot -pa12345 -e ' . $sql
);
$tmpArr = array();
foreach($cmdArr as $cmd){
exec($cmd,$tmpArr,$return);
var_export($tmpArr);
echo $return;
}