select * from reader where reader_no like '%'+r_no+'%';
END 作者: 张忠豹 时间: 2012-10-25 10:15
DELIMITER $$
DROP PROCEDURE IF EXISTS `jdbc`.`addUser` $$
CREATE PROCEDURE `jdbc`.`addUser` (in name varchar(255), in birthday date,in money float, out id int)
BEGIN
insert into user(`name`,`birthday`,`money`) values(name,birthday, money);
select last_insert_id() into id;
END $$
DELIMITER ;