How to export part of a table as SQL in Adminer?
Solution 1
Adminer doesn't offer SQL export of a general SQL query because the query may join more tables which would be impossible to export to SQL.
To export a subset of rows in a single 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 in the result). Then use the Export button under the table.
Solution 2
if you click on export then on that page see there is a radio button named dump
. put no of rows you wanted to pick up and starting record index number. then you will get your expected result
Solution 3
In current version it is possible with Search
- Select column
- Select SQL as mark
- Into value field fill subquery IN (SELECT id FROM ...)
Mateng
PHP & TYPO3 Developer from Cologne, Germany. My most popular answer as voted by Google: What is the best way to debug Typoscript Currently aiming for 2500 reputation points at SO in order to create tag synonyms.
Updated on July 16, 2022Comments
-
Mateng almost 2 years
In Adminer, I can export whole 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 to do so? A plugin or a config switch?
-
Mateng about 11 yearsSorry @ripa, but I can't find this option. I checked in Adminer 3.6.1 and Adminer 3.6.3