📄 mysql-4.1.cfg
字号:
date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format ###< insert into crash_me_d(a) values ('1963-08-16') ###> OK ### ###<select a from crash_me_d ###>1963-08-16 ### ###< delete from crash_me_d ###> OKdate_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format ###< insert into crash_me_d(a) values (DATE '1963-08-16') ###> OK ### ###<select a from crash_me_d ###>1963-08-16 ### ###< delete from crash_me_d ###> OKdate_format_USA=error # Supports MM/DD/YYYY format ###< insert into crash_me_d(a) values ('08/16/1963') ###> OK ### ###<select a from crash_me_d ###>0000-00-00 ###We expected '1963-08-16' but got '0000-00-00' ### ###< delete from crash_me_d ###> OKdate_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format ###< insert into crash_me_d(a) values (DATE '08/16/1963') ###> OK ### ###<select a from crash_me_d ###>0000-00-00 ###We expected '1963-08-16' but got '0000-00-00' ### ###< delete from crash_me_d ###> OKdate_format_YYYYMMDD=yes # Supports YYYYMMDD format ###< insert into crash_me_d(a) values ('19630816') ###> OK ### ###<select a from crash_me_d ###>1963-08-16 ### ###< delete from crash_me_d ###> OKdate_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format ###< insert into crash_me_d(a) values (DATE '19630816') ###> OK ### ###<select a from crash_me_d ###>1963-08-16 ### ###< delete from crash_me_d ###> OKdate_format_inresult=iso # Date format in result ###< insert into crash_me_d values( sysdate() ) ###> OK ### ###< select a from crash_me_d ###> 2004-04-06 ###< delete from crash_me_d ###> OKdate_infinity=error # Supports 'infinity dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('infinity') ###> OK ### ###<select a from crash_me2 ###>0000-00-00 ###We expected 'infinity' but got '0000-00-00' ### ###< drop table crash_me2 ###> OKdate_last=yes # Supports 9999-12-31 dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('9999-12-31') ###> OK ### ###<select a from crash_me2 ###>9999-12-31 ### ###< drop table crash_me2 ###> OKdate_one=yes # Supports 0001-01-01 dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('0001-01-01') ###> OK ### ###<select a from crash_me2 ###>0001-01-01 ### ###< drop table crash_me2 ###> OKdate_with_YY=yes # Supports YY-MM-DD 2000 compilant dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('98-03-03') ###> OK ### ###<select a from crash_me2 ###>1998-03-03 ### ###< drop table crash_me2 ###> OK ### ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('10-03-03') ###> OK ### ###<select a from crash_me2 ###>2010-03-03 ### ###< drop table crash_me2 ###> OKdate_zero=yes # Supports 0000-00-00 dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('0000-00-00') ###> OK ### ###<select a from crash_me2 ###>0000-00-00 ### ###< drop table crash_me2 ###> OKdomains=no # Domains (ANSI SQL) ###< create domain crash_d as varchar(10) default 'Empty' check (value <> 'abcd') ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'domain crash_d as varchar(10) default 'Empty' check (value <> ' ###< create table crash_q(a crash_d, b int) ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'crash_d, b int)' at line 1 ###< insert into crash_q(a,b) values('xyz',10) ###> execute error:Table 'test.crash_q' doesn't exist ###< insert into crash_q(b) values(10) ###> execute error:Table 'test.crash_q' doesn't exist ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ###< drop domain crash_d ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'domain crash_d' at line 1 ### ###As far as some queries didnt return OK, result is NOdont_require_cast_to_float=yes # No need to cast from integer to float ###< select exp(1) ###> OK ### ###As far as all queries returned OK, result is YESdouble_quotes=yes # Double '' as ' in strings ### ###<select 'Walker''s' ###>Walker'sdrop_if_exists=yes # drop table if exists ###< create table crash_q (q integer) ###> OK ###< drop table if exists crash_q ###> OK ### ###As far as all queries returned OK, result is YESdrop_index=with 'ON' # drop index ###< drop index crash_q ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ### ###< drop index crash_q from crash_me ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from crash_me' at line 1 ### ###< drop index crash_q on crash_me ###> OKdrop_requires_cascade=no # drop table require cascade/restrict ###< create table crash_me (a integer not null) ###> OK ###< drop table crash_me ###> OKdrop_restrict=yes # drop table with cascade/restrict ###< create table crash_q (a int) ###> OK ###< drop table crash_q restrict ###> OK ### ###As far as all queries returned OK, result is YESend_colon=yes # allows end ';' ###< select * from crash_me; ###> OK ### ###As far as all queries returned OK, result is YESexcept=no # except ###< select * from crash_me except select * from crash_me3 ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NOexcept_all=no # except all ###< select * from crash_me except all select * from crash_me3 ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NOexcept_all_incompat=no # except all (incompatible lists) ###< select * from crash_me except all select * from crash_me2 ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NOexcept_incompat=no # except (incompatible lists) ###< select * from crash_me except select * from crash_me2 ###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NOfield_name_case=yes # case independent field names ###< create table crash_q (q integer) ###> OK ###< insert into crash_q(Q) values (1) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YESfloat_int_expr=yes # mixing of integer and float in expression ###< select 1+1.0 ###> OK ### ###As far as all queries returned OK, result is YESforeign_key=syntax only # foreign keys ###< create table crash_me_qf (a integer not null,primary key (a)) ###> OK ### ###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a)) ###> OK ### ###< insert into crash_me_qf values (1) ###> OK ### ###< insert into crash_me_qf2 values (2) ###> OK ### ###< drop table crash_me_qf2 ###> OK ### ###< drop table crash_me_qf ###> OKfull_outer_join=no # full outer join ###< select crash_me.a from crash_me full join crash_me2 ON ### crash_me.a=crash_me2.a ###> execute error:Unknown table 'crash_me' in field list ### ###As far as some queries didnt return OK, result is NOfunc_extra_!=yes # Function NOT as '!' in SELECT ### ###<select ! 1 ###>0func_extra_%=yes # Function MOD as % ### ###<select 10%7 ###>3func_extra_&=yes # Function & (bitwise and) ### ###<select 5 & 3 ###>1func_extra_&&=yes # Function AND as '&&' ### ###<select 1=1 && 2=2 ###>1func_extra_<>=yes # Function <> in SELECT ### ###<select 1<>1 ###>0func_extra_==yes # Function = ### ###<select (1=1) ###>1func_extra_add_months=no # Function ADD_MONTHS ### ###<select add_months('1997-01-01',1) from crash_me_d ###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '('1997-01-01',1) from crash_me_d' at line 1func_extra_adddate=yes # Function ADDDATE ### ###<select ADDDATE('2002-12-01',3) from crash_me_d ###>2002-12-04func_extra_addtime=yes # Function ADDTIME ### ###<select ADDTIME('20:02:12','00:00:03') ###>20:02:15func_extra_alpha=no # Function ALPHA ### ###<select alpha('A⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -