Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql load csv into table

LOAD DATA INFILE 'c:/tmp/discounts.csv' 
INTO TABLE discounts 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 ROWS;
Comment

How to import CSV file into a MySQL table

LOAD DATA LOCAL INFILE  
'c:/temp/some-file.csv'
INTO TABLE your_awesome_table  
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 ROWS
(field_1,field_2 , field_3);
Comment

how to dump .csv file into mysql

LOAD DATA LOCAL INFILE 'c:/country.csv' 
INTO TABLE country 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 ROWS;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql practice 
Sql :: pg_pretty_size 
Sql :: sql left join 
Sql :: sql online 
Sql :: stuff sql server 
Sql :: SQLITE_BUSY: database is locked 
Sql :: delete * from where id = 1; 
Sql :: if else in mysql stored procedure 
Sql :: mysql timezone 
Sql :: error 1054 mysql 
Sql :: how to get all dates in a month in oracle 
Sql :: between vs in sql 
Sql :: oracle get ddl 
Sql :: postgresql newline character 
Sql :: sql unique constraint 
Sql :: sql rename column in select query 
Sql :: right join sql 
Sql :: how to make case insensitive in sql 
Sql :: delete table cassandra 
Sql :: forcefully delete a row in mysql which has references 
Sql :: sqlite unix timestamp 
Sql :: oracle get foreign keys on table 
Sql :: oracle db timestamp auto add 
Sql :: mysqldump 1 table only 
Sql :: SQL Server OPENJSON FROM table column 
Sql :: DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER 
Sql :: sql describe 
Sql :: create-table 
Sql :: oracle ora-00054 how to unlock 
Sql :: how to add more columns to a table in mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+5 =