?? ansi.test
字號(hào):
## Test of ansi mode#--disable_warningsdrop table if exists t1;--enable_warningsset sql_mode="MySQL40";select @@sql_mode;set @@sql_mode="ANSI";select @@sql_mode;# Test some functions that works different in ansi modeSELECT 'A' || 'B';# Test GROUP BY behaviourCREATE TABLE t1 (id INT, id2 int);SELECT id,NULL,1,1.1,'a' FROM t1 GROUP BY id;#No --error 1055 error due to temporary fix for BUG#8510:#ONLY_FULL_GROUP_BY is overly restrictive, so remove it from ANSI mode.SELECT id FROM t1 GROUP BY id2;drop table t1;SET @@SQL_MODE="";# Bug#14515CREATE TABLE t1 (i int auto_increment NOT NULL, PRIMARY KEY (i));SHOW CREATE TABLE t1;SET @@SQL_MODE="MYSQL323";SHOW CREATE TABLE t1;SET @@SQL_MODE="MYSQL40";SHOW CREATE TABLE t1;SET @@SQL_MODE="NO_FIELD_OPTIONS";SHOW CREATE TABLE t1;DROP TABLE t1;# End of 4.1 tests?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -