SQL Bulk Insert csv

SQL Bulk Insert is used to import the records from csv  file to the same format table in a Mysql database.

Understand with Example

The Tutorial covers an example from 'SQL Bulk Insert CSV'.To understand and  grasp this example we create a table 'stu' with required fieldnames and datatypes respectively.Again, we create a file abc  with extension csv contain the records that are imported to the table 'stu'.

Create Table Stu

Create Table Stu( Id int, Name varchar(15), Class());

abc.csv

1	Komal	10
2	Ajay	10
3	Santosh	10
4	Rakesh	10
5	Bhau	10

Backup query 

The Backup query is used to import a abc.csv file into a table 'stu'.The LOAD DATA INFILE import the file abc.csv to the same format table stu of the database.

LOAD DATA INFILE 'c:/abc.csv' INTO TABLE stu
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n';

Table Stu_Table

+--------+----------+-----------+
| Stu_Id | Stu_Name | Stu_Class |
+--------+----------+-----------+
| 1      | Komal    | 10        |
| 2      | Ajay     | 10        |
| 3      | Santosh  | 10        |
| 4      | Rakesh   | 10        |
| 5      | Bhau     | 10        |
+--------+----------+-----------+

Related Tags for SQL Bulk Insert csv:
sql,  mysql,  c,  database,  file,  orm,  table,  data,  form,  csv,  import,  insert,  sed,  format,  port,  tab,  for,  record,  bulk,  records,  to,  base,  e,  il,  use,  ul,  im,  from,  in,  rm,  cs,  as,  m,  ase,  me,  same,  s,  at,  my,  k,  is,  rds,  rt,  sa,  s,  sam,  s,  sam,  rd,  th,  ab,  abl,  om,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: SQL Bulk Insert csv   View All Comments

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):