My table dept_manager_dup gets disappeared.
Dear Sir/Madam,
My table dept_manager_dup gets disappeared whenever I reopen the MySQL server. The table gets truncated as shown in the pic. I have to again perform the operation on this table dept_manager_dup. Please let me know the solution of this issue.
Thanks and Regards,
Shardul Dhage
2 answers ( 0 marked as helpful)
Hi Shardul!
Thanks for reaching out.
It seems that the table is empty. Please, fill the table with the data from the dept_manager table.
Hope this helps.
Best,
Tsvetelin
I had this problem you have to save your data by COMMIT; after you fill the table