Is there an SQL query equivalent to the mysqldump console command?

Question

MySQL

Hello.
There is a mysqldump console command that allows you to dump the structure and data of a table and send it all to a file.
There is a SQL query "SHOW CREATE TABLE tbl_name" which allows you to get the table structure in the application.
Question : Is there a SQL query that allows the application to get a dump (similar to the mysqldump console command) of table data?
Thanks for answers.

Answer 1

You can get a list of tables, structure, procedures, triggers, events and data with separate queries:
https://dev.mysql.com/doc/refman/8.0/en/show-table...
https://dev.mysql.com /doc/refman/8.0/en/show-creat...
https://dev.mysql.com/doc/refman/8.0/en/show-proce...
https://dev.mysql.com/doc /refman/8.0/en/show-trigg...
https://dev.mysql.com/doc/refman/8.0/en/show-event...
https://dev.mysql.com/doc/refman /8.0/en/select.html
You can query to create a backup and send output to a file using the mysql console utility without using mysqldump:
Like this:

mysql -e "select * from table_name" -u user_name -p******** database_name > file_name.txt