Sql

Search

how to load files in mysql

LOAD DATA INFILE 'c:/tmp/discounts.csv' 
INTO TABLE discounts 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 ROWS;
Code language: SQL (Structured Query Language) (sql)

Comment

PREVIOUS	NEXT

Code Example
Sql :: python simple connect to mysql
Sql :: get clob size oracle
Sql :: sql parent child tree query
Sql :: how to change db owner postgres
Sql :: execute sp in sql server
Sql :: alternative for LIMIT sql
Sql :: groupby error in mysql
Sql :: data formate in sql
Sql :: mysql drop key
Sql :: SQL Database backup history
Sql :: oracle alter table add column default value
Sql :: oracle dependency
Sql :: sql download for windows 10
Sql :: sequence postgresql
Sql :: subquery in sql
Sql :: pl sql
Sql :: how to delete all duplicate items in mysql
Sql :: sql server delete table
Sql :: alter table query sql server change column
Sql :: insert array into mysql column
Sql :: mysql create a user
Sql :: how to get previous year from sysdate in oracle
Sql :: how to tun mysql on ubunto
Sql :: MySQL import data from large CSV file
Sql :: convert dd/mm/yyyy to yyyy-mm-dd in sql server
Sql :: mysql for windows 10 64 bit
Sql :: convert html to plain text in sql server
Sql :: how to get nth number in sql
Sql :: how to duplicate mysql table
Sql :: mysql regexp replace

Search

SQL

how to load files in mysql

ADD CONTENT