Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

select all tables from database where table name like mysql

select table_schema as database_name,
    table_name
from information_schema.tables
where table_type = 'BASE TABLE'
    and table_name like 'cu%'
order by table_schema,
     table_name;
Source by dataedo.com #
 
PREVIOUS NEXT
Tagged: #select #tables #database #table #mysql
ADD COMMENT
Topic
Name
4+5 =