sql基础知识

create table a(

id int(32) primary key ,

sex varchar(32) not null  unique ,

forgein key （name) references b(name),

age int(10) default 1,

customerID int(10) not null auto_increment

)engine=innodb,

default charset= utf8 collate utf8_general_ci ;

insert into a(id,sex)values(1,'m')

delete from a where id=1

update  a set sex='w' where id=1

alter table a add addr varvhar(32);

alter table a drop addr

alter table a modify sex varchar(21)

alter table a rename aaa

alter table aaa rename a

alter table a add constraint fk_dept forgen key (addr) references b (addr)

alter table a drop forgein key fk_dept

show create databases aaa;

show create table aaa;

show full columns from aaa;

create producer input(in id int)

as

begin 

        select id;

 set id=3;

select id;

end

set @id=1;

call input(@id);