views in mysql

1
2        
3            
4        
5     SHOW FULL TABLES 
6WHERE table_type = 'VIEW';
7

1
2        
3            
4        
5     SELECT * 
6FROM information_schema.tables;
7

1
2        
3            
4        
5     SELECT 
6    customerName, 
7    checkNumber, 
8    paymentDate, 
9    amount
10FROM
11    customers
12INNER JOIN
13    payments USING (customerNumber);
14