#!/bin/bash
# bash中对mysql进行操作
USER="user"
PASS="user"
HOST="127.0.0.1"
mysql -u ${USER} -p${PASS} -h${HOST}<<EOF 2> /dev/null
CREATE DATABASE students;
EOF
[ $? -eq 0 ] && echo Created DB || echo DB already exist
mysql -u ${USER} -p${PASS} -h${HOST} students <<EOF 2> /dev/null
CREATE TABLE students(
id int,
name varchar(100),
score int
);
EOF
[ $? -eq 0 ] && echo Created table students || echo Table students already exist
mysql -u ${USER} -p${PASS} -h${HOST} students <<EOF 2> /dev/null
INSERT INTO students(id,name,score)values(0,'allen',100);
);
EOF
mysql -u ${USER} -p${PASS} -h${HOST} students <<EOF 2> /dev/null
SELECT * FROM students WHERE id=0;
EOF
mysql -u ${USER} -p${PASS} -h${HOST} students <<EOF 2> /dev/null
DROP TABLE students;
EOF
mysql -u ${USER} -p${PASS} -h${HOST} <<EOF 2> /dev/null
DROP DATABASE students;
EOF
文件的md5校验#/bin/bashgenMd5Sum(){ local pid_array=() for file in ./* do md5sum ${file} &amp; pid_array+=("$!") # 将上一个进程id保存之pid_array done wait ${pid_array[@]} #...