information_schema.schemata-Mysql查询

        

          

            
              
                mysql
                >
                 select schema_name from information_schema
                
                  .
                  schemata
                
                ;
              
            
          
          

            
              +--------------------+
            
          
          

            
              |
               schema_name        
              |
            
          
          

            
              +--------------------+
            
          
          

            
              |
               information_schema 
              |
            
          
          

            
              |
               mysql              
              |
            
          
          

            
              |
               newdb              
              |
            
          
          

            
              |
               performance_schema 
              |
            
          
          

            
              |
               test               
              |
            
          
          

            
              +--------------------+
            
          
          

            
              5
               rows in 
              set
               
              (
              0.02
               sec
              )
            
          
        
      

        

          

            
              mysql
              >
               select table_name from information_schema
              
                .
              
              tables 
              where
               table_schema
              =
              datab
            
          
          

            
              ase
              ();
            
          
          

            
              Empty
               
              set
               
              (
              0.00
               sec
              )
            
          
        
      

        

          

            mysql> select 
            column_name
             from 
            information_schema.columns
             where 
            table_schema
            ='newdb' and 
            table_name
            ='users';
+-------------+
| column_name |
+-------------+
| id          |
| username    |
| password    |
+-------------+
3 rows in set (0.05 sec)