Databases| SQL| MySQL| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials

Latest Questions
Comments
 
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.

 

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        |
+--------+----------+-----------+

                         

» View all related tutorials
Related Tags: sql mysql c database file text data import backup load sed port int create tab tex loader example to base

Leave your comment:

Name:

Email:

URL:

Title:

Comments:


Enter Code:

Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Software Solutions
Least Viewed
Most Rated
Recently Viewed
Search Tutorials

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.