oceanbase
16 строк · 507.0 Байт
1--disable_query_log
2set @@session.explicit_defaults_for_timestamp=off;
3--enable_query_log
4#owner : dachuan.sdc
5#owner group : sql2
6#description : test information_schema.views
7
8connect (obsys,$OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
9connection obsys;
10use information_schema;
11select * from views where table_schema = 'mysql' order by table_name desc;
12--source mysql_test/include/show_create_table_old_version_replica2.inc
13show create view views;
14desc views;
15disconnect obsys;
16connection default;
17