MySql语句

学习时所使用的语句（为个人方便使用，后期整理）

use stu;

select * from account;

insert into account(carid,name,balance) values(1234,'ls',10000);

insert into account(carid,name,balance) values(1235,'ww',10000);

create database TestMybatis;

use TestMybatis;

create table person(id int, name varchar(20), age int);

select * from person;

insert into person(id,name,age) values(1,'zs',23);

create table student(stuno int,stuname varchar(20),stuage int,graname varchar(20));

select * from student;

insert into student(stuno,stuname,stuage,graname) values(1,'zs',23,'g1');

drop table student;

insert into student(stuno,stuname,stuage,graname) values(2,'zls',24,'g2');

alter table student add stusex int;

select * from student;

insert into student(stusex) value(0);

update student set stusex = 0 where stuno=1;

update student set stusex=0;

delete from student where stusex=0;

show variables like 'SQL_SAFE_UPDATES';

SET SQL_SAFE_UPDATES = 0;

alter table student add unique(stuno);

select * from student;

alter table student add homeaddress varchar(20);

alter table student add schooladdress varchar(20);

update student set homeaddress = 'ly'  where stuno=1;

update student set schooladdress = 'xc'  where stuno=1;

update student set schooladdress = 'hf'  where stuno>1;

update student set homeaddress = 'fz'  where stuno>1;

insert into student(stuno,graname) values(5,'g1');

insert into student(stuno,graname) values(6,'g1');

insert into student(stuno,graname) values(6,'g1');

DROP PROCEDURE IF EXISTS queryCountByGradeWithProcedure;

DELIMITER $$
create procedure queryCountByGradeWithProcedure(in gName varchar(20),out scount int)
begin
select count(1) into scount from student where graname = gname;
end
$$
DELIMITER ;