Press enter to see results or esc to cancel.


Export MySQL table To Excel or CSV without any Software

In this video I have shown how you can export a MySQL table to excel or CSV without any third party software.
All you can use CMD prompt to export export the table.

1. First login to your MySQL database through command prompt. You can check below link to see the steps for that.
https://chillyfacts.com/connect-remote-mysql-database-using-command-prompt/

2. Now use the database in which you have the table to export.

3. Now I am going to export a table ‘attendance_time_shifts’ in the database ‘hr’
The command to be used to export is shown below,

select * from 'table_name' into outfile 'path'  fields terminated by ',' lines terminated by '\n'

So in our example the command will be

select * from attendance_time_shifts into outfile "G:\\jinu\\attendance_time_shifts.csv" fields terminated by ',' lines terminated by '\n'

4. After executing the above command, The data of the table should have exported to the location specified.


Tags

Comments

Leave a Comment