• Post Reply Bookmark Topic Watch Topic
  • New Topic

Auto fill in mysql  RSS feed

 
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!