CREATE TABLE sales_data_new (
`ORDERNUMBER` DECIMAL(38, 0) NOT NULL,
`QUANTITYORDERED` DECIMAL(38, 0) NOT NULL,
`PRICEEACH` DECIMAL(38, 2) NOT NULL,
`ORDERLINENUMBER` DECIMAL(38, 0) NOT NULL,
`SALES` DECIMAL(38, 2) NOT NULL,
`ORDERDATE` VARCHAR(30),
`STATUS` VARCHAR(10) NOT NULL,
`QTR_ID` DECIMAL(38, 0) NOT NULL,
`MONTH_ID` DECIMAL(38, 0) NOT NULL,
`YEAR_ID` DECIMAL(38, 0) NOT NULL,
`PRODUCTLINE` VARCHAR(16) NOT NULL,
`MSRP` DECIMAL(38, 0) NOT NULL,
`PRODUCTCODE` VARCHAR(9) NOT NULL,
`CUSTOMERNAME` VARCHAR(34) NOT NULL,
`PHONE` VARCHAR(17) NOT NULL,
`ADDRESSLINE1` VARCHAR(100) NOT NULL,
`ADDRESSLINE2` VARCHAR(50),
`CITY` VARCHAR(14) NOT NULL,
`STATE` VARCHAR(13),
`POSTALCODE` VARCHAR(9),
`COUNTRY` VARCHAR(11) NOT NULL,
`TERRITORY` VARCHAR(5),
`CONTACTLASTNAME` VARCHAR(11) NOT NULL,
`CONTACTFIRSTNAME` VARCHAR(10) NOT NULL,
`DEALSIZE` VARCHAR(6) NOT NULL
);
load data infile '/Users/thispc/Downloads/sales_data_sample_cleaned.csv'
into table sales_data_new
fields terminated by ','
enclosed by '"'
lines terminated by 'n'
ignore 1 rows;
Everything is fine till now
select count(*) from sales_data_new;
#output 2823
select * from sales_data_new;
after this i got the records
When i downloaded the file then in excel the count is 65443
#how
SET SESSION SQL_MODE = ‘ ‘;
SHOW VARIABLES LIKE ‘secure_file_priv’;
SET NAMES ‘utf8mb4’;
SET SQL_SAFE_UPDATES = 0;
SHOW WARNINGS;
tried something like this but didn’t find nothing
New contributor
Sahil Patel is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.