Backstage function is as follows:
1. Read the file regularly, automatically update the database, a table
2. According to a table of data automatically update the database table, b

Update:
Comment out code automatically update table b

Now you need to edit a SQL script to test whether b table will be updated according to a table

CodePudding user response:

1, provide the file content,
The structure of 2, table A and table B,
3, update rules,

CodePudding user response:

The content that is updated table b? Is to keep the ab table structure, content exactly?
SQL script and testing table, b can only judge execute SQL script point ab table is consistent, can't judge is updated in real time