1. View of single table
Create view v1 as select * from t_book2;
select * from v1;
create view v2 as select bookName, price from t_book2;
select * from v2;
create view v3 (b, p) as select bookName, price from t_book2;
2. View of multi table
Create view v4 as select tb.bookName, tbt.bookTypeName from t_book2 tb, t_bookType tbt where tb.bookTypeId=tbt.id;
3. Desc
desc v4;
4. Show table status
show table status like 'v4';
PS: virtual table
show table status like 't_book2';
PS: real table
5. Show create view
show create view v4;