Mysql Error

What is CSV file? or how can we upload bulk files in database using csv format?

Google+ Pinterest LinkedIn Tumblr

What is CSV file?

A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma , file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers.
{ Source: wiki }.

In Spreed Sheets You can download data as csv file format which means each column data separated by (,).

Using this csv formats we can easily upload bulk files and database tables in MySQL database.

Export or dowload msword or spreadsheet files in .csv
It shows like:

name, firstname, email, password, phone,
abc, d, abc@gmail.com, 123, 9876543210,
abce, df, abgc@gmail.com, 123, 9876543210,
abcf, dd, abbc@gmail.com, 123, 9876543210,
abcf, df, abcb@gmail.com, 123, 9876543210,
abcfd, fd, abbc@gmail.com, 123, 9876543210,
abcf, df, abbc@gmail.com, 123, 9876543210,

What is CSV file? or how can we upload bulk files in database using csv format?

I'm Rajasekar - Web developer, Freelancer, Blogger and Owner of DeveloperDesks. From India lives in Bahrain. I love to do coding, Creating websites and trying different with code and designs. You Can Hire Me