weixin_39345735的博客

一、建库、建表create database alibaba;use alibaba;– 建表create table student(s_id varchar(10),s_name varchar(10),s_age date,s_sex varchar(10)) engine=InnoDB default charset utf8;insert into student(s_id,s...

create database proce;use proce;create table test(a int);select * from test;-- t1、创建查询test表的存储过程delimiter //create procedure t1()begin select * from test;end //delimiter ;call t1();dr...