Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am cleaning some data bases and was wondering that if there is any proper way to export any single column and all it's entries from a SQL table.
Being specific, I am dealing with SQL tables in phpmyadmin; if i am not wrong, there must be a SQL query for such tasks.
Using phpMyAdmin run a SQL query against the table that you want a column of data from and select only that column (something along the lines of SELECT cas_number FROM analytes).
Scroll to the bottom of the results and click on Export. The only thing that will be exported is the column of data that was selected.
