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

Recommended Answers

All 2 Replies

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.