Re: MySQL Tutorial: LAST_INSERT_ID()

[kamal patel]

How I can Insert tow table data?
This are tables
Products
Products_description

I am not good in stored procedure. I wrote following code, but it did not work.
Can any body help me?


DELIMITER $$

DROP PROCEDURE IF EXISTS `esale`.`PRODUCTSs` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `PRODUCTSs`()
BEGIN
insert into products(products_id,products_price)
values(NULL,200);
commit;
insert into products_description(products_id,products_name)
values(LAST_INSERT_ID(),'Paper');
commit;
END $$


Thanks,

DELIMITER ;