Home > database >  How to view the first three lines of the all tables under a database information
How to view the first three lines of the all tables under a database information

Time:09-26

Assume that the database DataBase_A here are 1000 tables, how to batch to see the 1000 copies of each table in the table in the first three rows of data information? Was tormented by the question dead

CodePudding user response:

The Oracle database, or a Mysql database?

CodePudding user response:

The first three lines of judgment is what?
You didn't say take 3 data is random,

CodePudding user response:

Is the MySQL database, is a database of all tables below the first three lines of data, can understand into random pick up three lines

CodePudding user response:

A database table next year? This is going to write a dynamic SQL, wrapped it in PL/SQL blocks or the process,

CodePudding user response:

Has a very obvious problem: each table table structure is different, how to save the data?

So this requirement isn't reasonable,
  • Related