Need help making a trigger to update two columns(PHPMyAdmin)

Databases
1

Hello i never worked with triggers before so i would be really greatfull if someone could help me create a trigger that would update one column from one table with a column from anther table. This has to happen in Vice versa also so that if that column changes the other one will change also. My two databases are setup like this:

cardealer_inventory` (
  `ID` char(64) NOT NULL,
  `JSONData` text NOT NULL,
  `Money` bigint(20) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;`

and

CREATE TABLE IF NOT EXISTS `bw_money` (
  `UID` int(11) NOT NULL,
  `SteamID` text COLLATE utf8_unicode_ci NOT NULL,
  `Money` bigint(20) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=2147483648 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I need it so that in bw_money money will update the money table in cardealer_inventory and vice versa.
Would love any help Thank you!

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.