I have a DB named **demo\_db**
with the following tables:

```
user
  Id
  Name

history
  Id
  userId
  report

start_test
  Id
  userId
  score

final_test
  Id
  userId
  score

```

How can I export all the tables into a CSV file using INTO OUTFILE in MySQL? So I can have the column name and below the data, i want to be a able to add filters, if there's maybe a way to add each table to a new tab in the same file....or if I can just display all the data in a single line for each user??

**Can't I do something like: SELECT user.*, history.*, start\_test.\*, final\_test.\* INTO OUTFILE FROM user, history, start\_test, final\_test**

I did it with mysqldump but it doesnt present the data as I want.

I'm doing this with PHP.