/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 vote130 views1 answer
Check if table exists oracle
SQL
0 vote159 views1 answer
Mysql config slave
SQL
0 vote128 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote134 views1 answer
Php delete database
SQL
11 votes207 views5 answers
Update table from another table mysql
SQL
0 vote148 views1 answer
Casterar postgres
SQL
6 votes154 views2 answers
What is non relational database
SQL
0 vote133 views1 answer
Mysql config address
SQL
1 vote127 views1 answer
Oracle rolling back
SQL
0 vote133 views1 answer
Min mysql
SQL

Share