Geek Answers Handbook

How to export part of a table as SQL in Adminer?

In Adminer, I can export entire tables with the Export menu option. When I enter a query, I can export the results as .CSV or .TSV, but not as SQL.

Is there any option? Plugin or configuration switch?

enter image description here

+3
database php mysql export adminer
source share
4 answers

The administrator does not offer SQL export of the general SQL query, because the query can join more tables that could not be exported to SQL.

To export a subset of the rows in one table, go to the “Select” view of this table, filter the results as you wish and check the rows you want to export (or check “whole result” to export all rows to the result). Then use the "Export" button under the table.

+8
source share

if you click on export, then on this page you will see a radio button with the name dump . do not put the lines that you would like to pick up and start the index number of the record. then you will get the expected result

+1
source share

Here is how I did it:

  • Go to Adminer Click on Dump in the upper left corner.
  • Output → check save switch
  • Format → check SQL radio button
  • Go to the Export button
  • Check the Tables checkboxes (if you want the data to then check the Data )
  • If you need 1 table, select one table check box.
  • Click the Export button.

Here we go :), Coool;)

0
source share

In the current version, this is possible when searching

  • Select column
  • Select SQL as Label
  • In the value field, enter the subquery IN (SELECT id FROM ...)
0
source share

More articles:


All Articles