Question: Create A table named RMA to store RMA information with a primary key of RMA ID and a foreign key of Order ID . Provide

Create A table named RMA to store RMA information with a primary key of RMA ID and a foreign key of Order ID. Provide the SQL commands you ran against MySQL to complete this step.
Step Two: Load and Query the Data
1. Import the data from each file into tables.
a. Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.
b. Use the import utility of your database program to load the data from each file into the table of the same name. Perform this step three times, once for each table.
c. Provide the SQL commands you ran against MySQL to complete this step.
I have the steps but I am getting an error How do I fix this?
ERROR 1406(22001): Data too long for column 'Reason' at row 1
mysql> CREATE TABLE RMA (
-> RMAID INT,
-> OrderID INT,
-> Reason VARCHAR(25),
-> Status VARCHAR(50),
-> Step VARCHAR(15),
-> PRIMARY KEY(RMAID));
Query OK,0 rows affected (0.23 sec)
mysql> LOAD DATA INFILE '/home/codio/workspace/customers.csv'
-> INTO TABLE Customers
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '
';
Query OK,37994 rows affected (2.35 sec)
Records: 37994 Deleted: 0 Skipped: 0 Warnings: 0
mysql> LOAD DATA INFILE '/home/codio/workspace/rma.csv'
-> INTO TABLE RMA
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '
';
ERROR 1406(22001): Data too long for column 'Reason' at row 1
Create A table named RMA to store RMA information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!