![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
greatneyo
不是程序员
展开
-
mysql数据库操作笔记
[code="java"]//查询最后生成的IDselect @@session.identity//创建视图create view v_add_friendsas (select u.userID,u.real_name,u.sex,d.college,d.academe,d.speciality,d.init_college_date,d.head_pic from...2010-05-04 00:47:47 · 84 阅读 · 0 评论 -
存储过程调用存储过程
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...原创 2015-01-20 16:38:30 · 124 阅读 · 0 评论