Problem is with connections between tables

Developers Dev talks
1

when addon is installing i want to run query wich will add new shipping method, the problem is with connections between tables




SET @max_id = (SELECT MAX( `shipping_id` ) FROM `cscart_shipping_descriptions`);
INSERT INTO `cscart_shipping_descriptions` (`shipping_id` ,`lang_code` ,`shipping` ,`delivery_time`)
VALUES (@max_id+1, 'EN', 'teszt', 'will never deliver');



in few tables more i need to use this shipping_id, and i dont know how to get it when my addon is installing

2

stupid me, i dont know why i started run 2 qweryes together,



SET @max_id = (SELECT MAX( `shipping_id` ) FROM `cscart_shipping_descriptions`);

INSERT INTO `cscart_shipping_descriptions` (`shipping_id` ,`lang_code` ,`shipping` ,`delivery_time`)
VALUES (@max_id+1, 'EN', 'teszt', 'will never deliver');




no problem anymore