Import data from mysql to excel

[shasiti]

hi...
im ct...actually im new in mysql...i done build survey use mysql as port data.the question is, how can i import the data from mysql to excel?

[vetrib2w]

if you can access the database just export data in csv format.

[Atli]

And to do that, you could use the SELECT INTO OUTFILE syntax.

For example:
[code=mysql]
SELECT * FROM `myTable` INTO OUTFILE '/path/to/my/file.cvs';
[/code]