I'm having many tables (shall we call them tableN
) with fields: id
, valueN
. Assume that we have array (value1 => 'val1', value2 => 'val2', value10 => 'val10')
, what is the way to insert values into table1
, table2
and table10
(I mean something better then doing 3 requests to DB). What is the simpliest way to update values in tables from row (of cause if we know id
). And finally what is the most elegant way to get all values with id=ID
from tables (JOIN
?).
Thank you in advance!