举个栗子： CREATE ALGORITHM = MERGE VIEW user_daily_stat AS SELECT
DATE_FORMAT(created, '%Y-%m-%d') AS date,
sum(1) AS count_user
FROM
`user`
GROUP BY
date;CREATE ALGORITHM = MERGE
好记性不如乱笔头吧....下面收藏整理了mysql中show 的使用技巧....有需要的博友可以看看哈 a. show tables或show tables from database_name; // 显示当前数据库中所有表的名称
b. show databases; // 显示mysql中所有数据库的名称
c. show columns from table_name from databa
grant select,update, insert, drop ,create on db_book_author_chapters.* to booktest@'10.148.150.207' identified by 'booktest' ;
flush privileges;
mysqladmin variables |SHOW VARIA
show errorshow allshow usersqlplusshow和set命令是两条用于维护SQLPlus系统变量的命令 ：SQL> show all --查看所有系统变量值SQL>show user --显示当前连接用户SQL>show error --显示错误(编译function,procedure,package,pl/sql的时候，可以查看具体的错误提示)SQ
