How to change the format of a query result?

Question

I would like to know if there is any argument in select that changes the format of result to be used as dump. Example:

create table `table_name` (`id` int, `value` text);
insert into `table_name` values (1, "a"), (2, "b"), (3, "c");

select * from `table_name`;
/* Result: "insert into `table_name` values (1, "a"), (2, "b"), (3, "c")" */

Answer 1

Paulo, I have never seen in any database any function that does what you want, but you can get the similar result by mounting the sql inside select using the function Concat(), with this your example would be this way:

select concat('insert into table_name values (',id,',',value,');') from table_name;

Each row of the result will be an Insert with a table record.

Answer 2

I don’t know this function of generating the Insert by SQL.

However Mysql Workbench after script execution has export option for various formats: CSV, HTML, JSON, SQL INSERT and etc.