Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Auto fill in mysql

 
Namnai Kidorkar
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
say i've two tables. they both have 2 columns in common. Is there anyway, that each time i update those two columns in table one, table two gets updated as well? how about updating with different informatin such as lengh of table 1 column 1 goes to table2 column 1. thanks in advanced.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could do this with triggers. Alternatively, if you have shared data you could store this in a seperate table and refer to it from each existing table.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic