是否可以使用数据自动填充数据库

Question

I was just wondering, is it possible to have a database that can be auto populated with specific data. For example, if you have a table consisting of electricity consumption and gas consumption, instead of me having to manually enter data of energy consumption, is there any way of this data being populated in the table periodically? Is such a thing possible?

Currently, my data is stored in phpmyAdmin.

Im asking because the project I'm working on requires data to be automatically populated.

Thanks!

Answer 1

If your energy consumption data is dependent on the gas and electricity consumption, you could always create a trigger in your database. Check out the documentation here.

Then you could create a trigger on your gas and electricity tables so that when a record is inserted or updated, it automatically performs some other action, whether it be updating your energy consumption or something else.