updating into two tables is possible?

updating into two tables is possible?

why not?

Hello,

Yes it is possible. your code will look something like this:

UPDATE table1, table2 
SET table1.field1 = table2.field99,
table2.date_posted = now()
where table1.id = table2.table1id
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.