What's wrong I took off state then another error occurred. Lab 3-1: Kim Tay Pet Supplies 0

What's wrong I took off state then another error occurred.

 

Transcribed Image Text:

Lab 3-1: Kim Tay Pet Supplies 0 Tasks 8 CENGAGE MINDTAP LO Create the REP table. Add the provided information to a new record in the REP table. Drop the REP table. Check that the KimTay database only has five tables. > > > Submit 0% query.sql X + 1 CREATE TABLE IF NOT EXISTS REP 2 ( 3 rep_id INT NOT NULL, 4 first_name VARCHAR (50) NOT NULL, 5 last_name VARCHAR(50) NOT NULL, 6 address VARCHAR (100) NOT NULL, 7 city VARCHAR(50) NOT NULL, 8 state VARCHAR(2) NOT NULL, 9 postal VARCHAR (5) NOT NULL, 10 cell phone VARCHAR (20) NOT NULL, 11 commission DECIMAL (10,2), 12 13 14 ); 15 rate DECIMAL (10,2), PRIMARY KEY (rep_id) NSERT INT REP (rep_id, first_name, last_name, address, city, cell_phone, state, postal, commission, rate) 17 VALUES (35, 'Fred', 'Kiser', '427 Billings Dr.', 'Cody', 'WY', '82414', '307-555-6309', 0.00', '0.05'); 18 10 SELECT FROM DED. SQL Viewer KimTay 7 X > Terminal + Q Search this course ERROR 1406 (22001) at line 16: Data too long for column 'state' at row 1 X Lab 3-1: Kim Tay Pet Supplies 0 Tasks 8 CENGAGE MINDTAP LO Create the REP table. Add the provided information to a new record in the REP table. Drop the REP table. Check that the KimTay database only has five tables. > > > Submit 0% query.sql X + 1 CREATE TABLE IF NOT EXISTS REP 2 ( 3 rep_id INT NOT NULL, 4 first_name VARCHAR (50) NOT NULL, 5 last_name VARCHAR(50) NOT NULL, 6 address VARCHAR (100) NOT NULL, 7 city VARCHAR(50) NOT NULL, 8 state VARCHAR(2) NOT NULL, 9 postal VARCHAR (5) NOT NULL, 10 cell phone VARCHAR (20) NOT NULL, 11 commission DECIMAL (10,2), 12 13 14 ); 15 rate DECIMAL (10,2), PRIMARY KEY (rep_id) NSERT INT REP (rep_id, first_name, last_name, address, city, cell_phone, state, postal, commission, rate) 17 VALUES (35, 'Fred', 'Kiser', '427 Billings Dr.', 'Cody', 'WY', '82414', '307-555-6309', 0.00', '0.05'); 18 10 SELECT FROM DED. SQL Viewer KimTay 7 X > Terminal + Q Search this course ERROR 1406 (22001) at line 16: Data too long for column 'state' at row 1 X

Answer rating: 100% (QA)

1 The error occurred because you tried to insert a record into the REP table with a NULL value in th... View the full answer