Shardul Dhage
Last answered:

14 May 2023

 Posted on:

08 Dec 2022
1

My table dept_manager_dup gets disappeared.

in SQL / The new and the old join syntax

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 Dhageimage

2 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

12 Dec 2022
0

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

Fatma Amer
Posted on:

14 May 2023
0

I had this problem you have to save your data by COMMIT; after you fill the table

Submit an answer

related questions

Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
Sivarajan Sivakumar
0
14
Cannot insert 999903 into the dept_emp table?
lalit yadav
6
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Ashakah Onome Andrew
0
10
Resolved: Salaries table is empty, showing Null
Snoor Salihi
0
10
Drop table from the database
Francois Chouinard
1
10
Can you show the instructions to reproduce dept_manager_dup table?
Matt Birch
0
10
Error after Error: Can't create a table this time
Longyin Li
0
8
cant't create table in sql