mysql的一些常用操作（一）

@H_404_0@1.启动MysqL服务

@H_404_0@net start MysqL

@H_404_0@2.进入MysqL环境中，由于自己没有设置密码，直接回车进入即可（要将bin加入到环境变量path中）

@H_404_0@MysqL -u root -p

@H_404_0@

@H_404_0@3.创建一个数据库

@H_404_0@create database db_test default character set utf8 collate utf8_general_ci;

@H_404_0@显示数据库：show databases;

@H_404_0@

@H_404_0@使用某个数据库：use db_test;

@H_404_0@显示该数据库的字符的编码：show variables like "%char%";

@H_404_0@

@H_404_0@ 查看某个表的结构：desc student;

@H_404_0@

@H_404_0@ 向student表中插入数据：4个字段，SId（学生ID）,Sname(学生姓名)，Sage(学生年龄)，Ssex(学生性别)

insert into Student values('01','赵雷','1990-01-01','男');
insert into Student values('02','钱电','1990-12-21','男');
insert into Student values('03','孙风','1990-12-20','男');
insert into Student values('04','李云','1990-12-06','男');
insert into Student values('05','周梅','1991-12-01','女');
insert into Student values('06','吴兰','1992-01-01','女');
insert into Student values('07','郑竹','1989-01-01','女');
insert into Student values('09','张三','2017-12-20','女');
insert into Student values('10','李四','2017-12-25','女');
insert into Student values('11','2012-06-06','女');
insert into Student values('12','赵六','2013-06-13','女');
insert into Student values('13','孙七','2014-06-01','女');

查询student表中的数据：select * from student;

@H_404_0@ 同理：建立Teacher表，2个字段，TId（教师id），Tname（教师姓名）

create table Teacher(TId varchar(10),Tname varchar(10),PRIMARY key (Tid));
insert into Teacher values('01','张三');
insert into Teacher values('02','李四');
insert into Teacher values('03','王五');

@H_404_0@

@H_404_0@ 建立课程表Course：

@H_404_0@3个字段，CId(课程id)，Cname（课程名称），TId（教师id）

create table Course(CId varchar(10),Cname nvarchar(10),TId varchar(10),PRIMARY KEY(CId));
insert into Course values('01','语文','02');
insert into Course values('02','数学','01');
insert into Course values('03','英语','03');

@H_404_0@ 建立成绩表score:4个字段，skey（由于没有不重复的字段，因此创建了主键字段），SId(学生id)，CId(课程ID)，score（学生成绩）

@H_404_0@create table score(skey int,SId varchar(10),CId varchar(10),scoreore decimal(18,1),PRIMARY key(skey));
insert into score values('1','01',80);
insert into score values('2','02',90);
insert into score values('3','03',99);
insert into score values('4',70);
insert into score values('5',60);
insert into score values('6',80);
insert into score values('7',80);
insert into score values('8',80);
insert into score values('9',80);
insert into score values('10','04',50);
insert into score values('11',30);
insert into score values('12',20);
insert into score values('13','05',76);
insert into score values('14',87);
insert into score values('15','06',31);
insert into score values('16',34);
insert into score values('17','07',89);
insert into score values('18',98);

@H_404_0@

mysql的一些常用操作（一）

猜你在找的MySQL相关文章