shell处理mysql表_Shell 脚本操作数据库实战

安装mariadb 数据库 (默认没有密码，直接mysql即可进入数据库管理控制台)

yum install mariadb mariadb-server mariadb-libs -y

systemctl start mariadb

netstat -tnlp |grep :3306

新建数据库

create database school default character set utf8;

CREATE TABLE student(

s_id varchar(20),

s_name varchar(20) not null default '',

s_birth varchar(20) not null default '',

s_sex varchar(10) not null default '',

primary key(s_id)

);

--课程表

create table course(

c_id varchar(20),

c_name varchar(20) not null default '',

t_id varchar(20) not null,

primary key(c_id)

);

--教师表

create table teacher(

t_id varchar(20),

t_name varchar(20) not null default '',

primary key(t_id)

);

--成绩表

create table score(

s_id varchar(20),

c_id varchar(20),

s_score int(3),

primary key(s_id,c_id)

);

--插入学生测试数据

insert into student values('1001','zhaolei','1990-1001-1001','male');

insert into student values('1002','lihang','1990-12-21','male');

insert into student values('1003','yanwen','1990-1005-20','male');

insert into student values('1004','hongfei','1990-1008-1006','male');

insert into student values('1005','ligang','1991-12-1001','male');

insert into student values('1006','zhousheng','1992-1003-1001','male');

insert into student values('1007','wangjun','1989-1007-1001','male');

insert into student values