lundi 25 mai 2015

how insert into different tables (sqlite)?

How i can insert values into different tables after 'case when'?

select case when state=1 then ('insert into table1 insert into table2') else '0' end from mytable;

Aucun commentaire:

Enregistrer un commentaire