mysql从第一行insert_MySql ：插入一行并获取内容_insert_酷徒编程知识库

存储过程调用mysql> call insert_user('bar');

+---------+----------+

| user_id | username |

+---------+----------+

| 1 | bar |

+---------+----------+

1 row in set (0.02 sec)

$sqlCmd = sprintf("call insert_user('%s')", ...);

简单示例：drop table if exists users;

create table users

(

user_id int unsigned not null auto_increment primary key,

username varchar(32) unique not null

)

engine=innodb;

drop procedure if exists insert_user;

delimiter #

create procedure insert_user

(

in p_username varchar(32)

)

begin

declare v_user_id int unsigned default 0;

insert into users (username) values (p_username);

set v_user_id = last_insert_id();

-- do more stuff with v_user_id e.g. logs etc...

select * from users where user_id = v_user_id;

end#

delimiter ;

call insert_user('bar');