mysql存储过程赋值问题？

[电灯泡]

在mysql存储过程里面，我用： set max_search_id = select last_insert_id()
但貌似语法有问题，last_insert_id()是mysql内置方法，返回上次插入的id。如果想实现类似的东东，应该怎么写呢

[wwwwb]

set max_search_id = last_insert_id()

[mysdzlt2007]

楼上+1
或者这样也行吧

SELECT last_insert_id() INTO max_search_id;

[rucypli]

select last_insert_id() into max_search_id

[ACMAIN_CHM]

set max_search_id = last_insert_id();

[ACMAIN_CHM]

MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html

[Rotel-刘志东]

set max_search_id=last_insert_id();