adspace


How will you export tables as an xml file in mysql?

Answer Posted / Rochak Mehrotra

To export tables as XML files in MySQL, use the `mysqldump` command-line tool with the `--xml` option. Here's an example:

```sh
mysqldump -u [username] -p[password] --xml=[table_name].xml [database_name] [table_name]
```

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105


How to Change a users password from unix shell.

1223


What is current version of mysql?

1084


Which statement is used in a select query for partial matching?

1247