GreatNeyo的专栏

[code="java"] //查询最后生成的ID select @@session.identity //创建视图 create view v_add_friends as (select u.userID,u.real_name,u.sex,d.college,d.academe,d.speciality, d.init_college_date,d.head_pic from...

create procedure proc_main() begin declare done INT default 0; declare d_user_id varchar(50); declare username_c varchar(50); declare userid CURSOR for select user_id from u...