Advanced Search

Return to Snippet

Revision: 70282
at January 3, 2016 13:32 by ktrout
Initial Code 
select table_catalog, table_schema, table_name, table_type, engine
from information_schema.tables
where table_name like '%digits%'
;

/*
+---------------+--------------+------------+------------+--------+
| table_catalog | table_schema | table_name | table_type | engine |
+---------------+--------------+------------+------------+--------+
| def           | test         | digits_v   | VIEW       | NULL   |
+---------------+--------------+------------+------------+--------+
*/
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
search for tables in mysql catalog ( information_schema )

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
mysql tablename search information schema

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, search

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL