脚本如下:
- #!/bin/bash
- User="root"
- Passwd="password"
- $(which mysql) -u${User} -p${Passwd} -e "
- create database mytest;
- use mytest;
- create table student (
- id int not null auto_increment,
- name varchar (50),
- primary key (id)
- );
- insert into student
- values
- (1,"xiaoming");
- "