I can save a record from the table using the query:

SELECT * INTO OUTFILE 'D://result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM `my_table` WHERE `id` = 302294;

but then only values ​​will be saved to my file, for example:

302294, "2016-11-09 16:23:01", 1478697787000.1 ...

Is it possible to save the data in a file so that they are in the form of a script, for example:

INSERT INTO my_table ( id , date , time , status ...) VALUES (302294, "2016-11-09 16:23:01", 1478697787000.1 ...)

Those. That one record was saved in the same form in which the dump of all table remains. Is there a way to do this automatically?

    1 answer 1

    Perhaps something like

     mysqldump -c "-wid=302294" yourdbname my_table

    will do what you need.