/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 vote142 views1 answer
Sql server select value large text
SQL
1 vote96 views1 answer
Ms sql - add one hour to time
SQL
0 vote151 views1 answer
Mssql dockere
SQL
2 votes154 views1 answer
Sql percentage with % rounded down
SQL
10 votes145 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote152 views1 answer
Show all mongodb
SQL
0 vote97 views1 answer
Postgresql subquery
SQL
9 votes160 views3 answers
Where clause sql
SQL
16 votes139 views2 answers
Sql exists
SQL
1 vote137 views1 answer
Cross schema query oracle 2 users
SQL

Share