Menu
How would I Export tables specifying only certain fields?
I am using mysql 5.0 - using either a sql command or mysqldump.
My table is X, and the fields I want to export are A,B,C
214
Open the MySQL database wizard & select the table you want to export. Right-click on the table name & select the table data export wizard option.
Within MySQL for Excel, Open a MySQL Connection, click the employee schema, Next, select the location table, click Edit MySQL Data, then choose Import to import the data into a new Microsoft Excel worksheet for editing.
Use the following command: ALTER TABLE myTable ENGINE=CSV; This statement changes the format of the database to CSV. You can then copy the CSV file to another system.
If you are using phpMyAdmin,
Run the query
SELECT A,B,C FROM X
and there is an export option in the bottom of the result.
129
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
