Select first 50 rows of each table in phpmyadmin

[vinpkl]

Hi all

how can i limit number of rows while creating dump from inside phpmyadmin

Normally for creating dump i click export tab then select all and create the dump.

But this creates dump of all rows of each table.

I need dump of only first 50 rows from each table.

I know i can do it by manually selecting each table and selecting 50 rows manually.

But is there any other alternative for automatically selecting first 50 rows from each and every table with any single command inside phpmyadmin.

vineet

[SamA74]

Add a limit to the end of your query

"SELECT Columns FROM table LIMIT 50"

[vinpkl]

@SamA74

SELECT Columns FROM table LIMIT 50

Hi Sam

With this method, I will have to update query for each table manually one by one.

i want to select first 20 rows of all tables in single query.

vineet

[r937]

[quote=“vinpkl, post:3, topic:229701, full:true”]
i want to select first 20 rows of all tables in single query.[/quote]

this is unreasonable

you just cannot do it