/SQL/Select tables from mysql database

Select tables from mysql database

Mysql find tables with name

SELECT table_name 
FROM information_schema.tables 
WHERE table_type = 'base table' AND table_name like '%YOUR TABLE NAME%';

2

Mysql command show tables

SHOW TABLES;

2

Source: linuxize.com

Select tables from mysql database

SHOW TABLES from <databasename>;

1

Similar codes

0 vote111 views1 answer
Sql max min
SQL
7 votes236 views2 answers
Drop index oracle
SQL
3 votes111 views2 answers
Mysql create timestamp column
SQL
1 vote111 views2 answers
How to check if sql query is correct online
SQL
2 votes96 views1 answer
Ifnull postgres
SQL
1 vote116 views1 answer
Set autoincrement to 0
SQL
10 votes110 views2 answers
Tsql merge example
SQL
1 vote111 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote105 views1 answer
How to find sql server installation folder
SQL
0 vote130 views1 answer
Print hello world in plsql
SQL

Share