数据库：简单题目练习（索引、存储过程）

目录

1、索引

2、存储过程-1

3、存储过程-2

---

1、索引

在student表的name上添加普通索引，在email上添加唯一索引，在age和birthday上添加组合索引

create table student (

id int,

name varchar(20),

email varchar(20),

age int,

birthday date,

index name_idex(name),

unique index email_idex(email),

index age_bir_idex(age,birthday)

)

show index from student

展示结果如下：

2、存储过程-1

Create table user(

  Id int primary key auto_increment,

  Username varchar(100),

  Password varchar(100),

  Age int

)

创建存储过程，向user表中添加数据

Delimiter $$

create procedure user_insert(in Username varchar(100),in Password varchar(100),in age int)

begin

         set @v1 = Username;

         set @v2 = Password;

         set @v3 = age;

        

         insert into user(Username,Password,age) values (@v1,@v2,@v3);

end;

$$

DElimiter;

call user_insert('老温','0511',28)

call user_insert('阿絮','1129',29)

3、存储过程-2

创建存储过程实现传入用户的编号，返回用户的姓名和年龄

Delimiter $$

create procedure user_select(in p int,out p1 varchar(100),out p2 varchar(100) )

begin

 

         set @v1 = p;

         select Username into p1 from user where id = p;

         select Age into p2 from user where id = p;

end;

$$

DElimiter;



call user_select(2,@n,@a);

select @n ,@a;