how to export mysql database schema with data using query

Question

0.00/5 (No votes)

See more:

MySQL

Posted 5-Aug-15 22:32pm

aparnaChandras

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ChauhanAjay · Answer 1 · 2015-08-05T23:05:00

Solution 1

You could try the below mentioned query

SELECT * INTO OUTFILE '/path/to/my_table_structure.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES  TERMINATED BY '\n'
FROM   INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_SCHEMA = DATABASE()

Posted 5-Aug-15 23:05pm

ChauhanAjay

Updated 5-Aug-15 23:20pm

v2

Comments

aparnaChandras 6-Aug-15 5:08am

it's shell command i want query which i can use in stored procedure

ChauhanAjay 6-Aug-15 5:26am

updated the answer with a query.

how to export mysql database schema with data using query

1 solution

Solution 1

Add your solution here

Preview 0

how to export mysql database schema with data using query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us