/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 vote381 views1 answer
Sql script to remove default from column
SQL
6 votes377 views2 answers
Sql sequence
SQL
0 vote367 views1 answer
Get a list of tables and the primary key
SQL
-1 vote350 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote360 views1 answer
Sql add calculated column
SQL
6 votes353 views2 answers
Oracle
SQL
0 vote340 views2 answers
How to update date in oracle
SQL
0 vote374 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote359 views1 answer
Raiserror with nowait
SQL
-1 vote371 views2 answers
Installing mysql on centos 7
SQL

Share