question 1:
created a view-based view using mysql, and when you use navicate to restore sql database files, the prompt child view (the view called by the parent view) does not exist. (this is the case with more than one view)
question 2
when you restore the database, the view restore is not successful, and then the view is copied manually, and the view name is changed to lowercase.
- View of the original database
attempted solution:
if you copy the child view first, and then copy the parent view, you can write normally. Is it because of the order in which mysql views are restored?
< hr >error message is as follows:
[Err] 1146-Table "test.v_actlist" doesn"t exist
[Err] 1146-Table" test.v_useract" doesn"t exist