Do not understand program.

[23bca312]

I understand how to create and insert record from sqlite3 but how to export table in csv file?

Please explain and help me to solve this problem.

[23bca307]

to export table into csv file use dump command

[23bca312]

How to apply dump command.

[23bca307]

.dump > .csv

This is the syntax but replace the content written in < > . i am not sure but try this solution.

[23bca261]

to export table data into csv file , you have to use .output command.

[23bca312]

Please explain with example.

[23bca261]

ok.. let me explain you...!!!

for example your table name is stud. and you want to export its data into "stud.csv" file. you have to enter below command.

.mode column .mode csv .output stud > stud.csv

[23bca312]

Is this command is given after creating insert command.

[23bca261]

yes... you have to apply this command after creating and inserting record.

one main point is after giving above command, write select query.

select * from stud.