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

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
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
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Snoor Salihi
0
10
Resolved: Drop table from the database
Ashakah Onome Andrew
0
10
Resolved: Salaries table is empty, showing Null
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
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?
Shelly Stanton
0
6
Should this be a select all records from the customers table?