Good day, can anyone help - there is a table, I select data from it with a query, about 100 lines are out, can these 100 lines be exported to an sql file in MySQL Workbench?

    1 answer 1

    Execute query SELECT * FROM db.table LIMIT 100

    After the request, click Export recordset to an external file :

    Then you need to select the SQL INSERT statements (*.sql) file type:

    Only the records from the sample *.sql be saved to the *.sql file (in example 100).

    • one
      Thanks, that is necessary. Immediately you will not think of it) - Sasha Borichevsky