Home » MySQL
Convert MySQL table to CSV file
on March 27, 2008 – 4:41 pm 6 Comments
CSV is a field-separated format that can be easily imported into a spreadsheet application. Usually the separator field is a comma. However, sometimes it is easier to select a more unusual character (like “@” for example), so that the field separator is not confused with commas in the field values.
In the example below we will dump contents of table1 in database1 to /tmp/database1_table1.csv. On the command line type this:
mysql -udbuser -pdbpasswd << EOF SELECT * INTO OUTFILE '/tmp/database1_table1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY 'n' FROM database1.table1; EOF
![wyryr1sn52gntzn65v4fpz5lc6v[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/wyryr1sn52gntzn65v4fpz5lc6v1-80x80.jpg "Plundering Facebook Photo Albums")
![clfud46mxf2t5zph2l04zlpgl1d[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/clfud46mxf2t5zph2l04zlpgl1d1-80x80.jpg "Scraping a Web Page in Bash")
![DSCF5361[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/DSCF53611-80x80.jpg "Processing Videos with ffmpeg and Lightroom")
![Cat-Devouring-A-Bird-Pablo-Picasso[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2020/10/Cat-Devouring-A-Bird-Pablo-Picasso1-80x80.jpg "Searching Twitter")
![91ebozy1e3b138waujy28agrngy[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/91ebozy1e3b138waujy28agrngy1-80x80.jpg "Generating Random Text Files for Testing")
![iwoau71okwxqh4jv3k4ook32qps[1]](https://i2.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/iwoau71okwxqh4jv3k4ook32qps1-80x80.jpg "Finding Cron Jobs")
![5gtysva4wkc8mzc1k3e66vaycxx[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2021/08/5gtysva4wkc8mzc1k3e66vaycxx1-80x80.jpg "Understanding Memory Utilization in Linux")
![sy2zeb1vp2h8itlxfbbylw0jrm0[1]](https://i0.wp.com/www.krazyworks.com/wp-content/uploads/2019/12/sy2zeb1vp2h8itlxfbbylw0jrm01-80x80.jpg "Validating HTTPS Cache Peers for Squid")
![Photo-2019-10-07-14-39-03_0266[1]](https://i1.wp.com/www.krazyworks.com/wp-content/uploads/2019/11/Photo-2019-10-07-14-39-03_02661-80x80.jpg "Verifying SNMP Connectivity on Multiple Hosts")
i have a data base in csv formate , i will like to know how to use it in php mysql . i am building a website for a school and they have the grades in csv format and the site i am building is in php mysql . i will like to know how to convert the csv format to a formate that can be used in mysql
i need a script to run in php, so when i run it, it takes the info and gives me the option to save it as a csv file.
any idea?
or do i need to set up a page to receive it….halp! and can the stuff attached to it come too
I have multiple .csv files with raw data in them. I need to summarize them and bring them all together into a readable, “pretty,” output. This data comes monthly right now, but in the same format. So is there a scripting language I can learn to do this? Where should I start?
So, I’m looking for a way for my php page with a html table + data from mysql db and converting the html table and its data to a .doc so that after it has been downloaded and can be opened and printed in MS word.
thanks for those who will reply
I have a LINUX web server, which supports SQL database only. How can I convert my Access database into SQL?