Problem: Having created the table structure in Problem 1, write the SQL code to enter the first two rows for the table shown in Figure P8.2. Each row should be inserted individually, without using a subquery. Insert the rows in the order that they are listed in the figure.I gor an error: RROR 1062 (23000) at line 1: Duplicate entry '101' for key 'PRIMARY'
Problem:
Having created the table structure in Problem 1, write the SQL code to enter the first two rows for the table shown in Figure P8.2. Each row should be inserted individually, without using a subquery. Insert the rows in the order that they are listed in the figure.I gor an error: RROR 1062 (23000) at line 1: Duplicate entry '101' for key 'PRIMARY'
when I used this script below, I got an error. see image.
ERROR 1062 (23000) at line 1: Duplicate entry '101' for key 'PRIMARY'
INSERT INTO EMP_1 VALUES ('101','News','John','G','2000-11-08','502');
INSERT INTO EMP_1 VALUES ('102','Senior','David','H','1989-07-12','501');
The given problem deals with inserting the data in the database table using SQL INSERT query.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
