Osama Elsayed Mohamed
Last answered:

27 Mar 2023

 Posted on:

25 Mar 2023
0

insert into department_dub (dept_name) Values ('Public Relations')

in SQL / Introduction to JOINs

Error when inserting this query: Error Code: 1146. Table 'employees.department_dub' doesn't exist ????

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

27 Mar 2023
0

Hi Osama!
Thanks for reaching out.


Actually, the name of the table is departments_dup. Please, correct it and you will resolve the issue.


Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Rhys Morgan
3
28
Rollback not reverting DB state after using INSERT INTO
Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
Anna Znosko
0
12
Resolved: SELECT first_name FROM employees GROUP BY first name did not work properly
Michael A. Ingram
1
12
Loading my previous database into a new installation of MySQL
Ana Coelho
0
8
Resolved: Non null values
Kshitij Yende
3
8
Resolved: Values asked for both IN and OUT Parameter
Sumit Pardeshi
0
8
Resolved: My Certificate Name
Ashraf Shagar
1
6
Resolved: Is the minus sign to keep null values of the emp_no at the bottom?