Export particular column data from table in phpmyadmin :
Here i will explain how to export particular column data from table. we can store the output in .sql or .csv file. In this method the output data will store in a file with newline (\n) separaters.
The syntax is :
SELECT column_name FROM table_name INTO OUTFILE '/opt/lampp/htdocs/fileName.sql'
The above syntax is store the output file in .sql format. you can change the format what you need. In the below example i will make the ooutput file in .csv format.
Example :
SELECT second_name FROM employee INTO OUTFILE '/opt/lampp/htdocs/secondName.csv'
Note : Best to download output file with .csv format. because .csv file format import has many advanced option when we import data to db. you can export with CSV, .zip, .gzip, etc... format.
The syntax is :
SELECT column_name FROM table_name INTO OUTFILE '/opt/lampp/htdocs/fileName.sql'
The above syntax is store the output file in .sql format. you can change the format what you need. In the below example i will make the ooutput file in .csv format.
Example :
SELECT second_name FROM employee INTO OUTFILE '/opt/lampp/htdocs/secondName.csv'
Note : Best to download output file with .csv format. because .csv file format import has many advanced option when we import data to db. you can export with CSV, .zip, .gzip, etc... format.
0 comments:
Post a Comment