select tables with name like mysql 1

select tables with name like mysql

SELECT table_name
FROM information_schema.tables

Here is what the above code is Doing:
1. We’re using the SELECT statement to select the table_name column from the information_schema.tables table.
2. We’re using the FROM statement to select the information_schema.tables table.

The information_schema.tables table contains a row for each table in the database.

The table_name column contains the name of each table.

So, the above code will return the names of all the tables in the database.

Let’s run the code:

Similar Posts