Member Avatar for anjagma

updating into two tables is possible?

  • 3 Contributors
  • 2 Replies
  • 72 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for Ranap Manalu

updating into two tables is possible?

why not?

Member Avatar for rch1231

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.