Category

Mysql Error

Category

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

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?