· 7 years ago · Nov 25, 2018, 04:50 PM
1stmt_query_list:
2 stmt_query ; | stmt_query ; stmt_query_list
3
4stmt_query:
5 stmt_prepare | call id_proc_name () | stmt_ddl | id_explain stmt_selects | id_explain stmt_selects | /*!50605 id_explain */ stmt_dml | /*!50605 id_explain */ stmt_dml | stmt_trx
6
7stmt_selects:
8 stmt_select | ( stmt_select_no_into ) id_union ( stmt_select_no_into )
9
10stmt_dml:
11 stmt_update | stmt_insert | stmt_delete | stmt_replace
12
13stmt_ddl:
14 stmt_create_view | stmt_add_col_to_table | stmt_drop_function | stmt_create_function | stmt_drop_procedure | stmt_create_procedure | stmt_create_table | stmt_drop_table | stmt_create_index | stmt_admin
15
16id_temporary:
17 | | | | temporary |
18
19stmt_prepare:
20 prepare stmt from " stmt_query " ;execute stmt;execute stmt;deallocate prepare stmt
21
22stmt_admin:
23 optimize table id_table_list | analyze table id_table_list | check table id_table_list
24
25stmt_drop_procedure:
26 drop procedure if exists id_proc_name
27
28stmt_create_index:
29 create index id_col id_digit on id_table ( id_col_list )
30
31stmt_create_procedure:
32 create procedure id_proc_name () begin stmt_query_list end;
33
34stmt_drop_function:
35 drop function id_func_name
36
37stmt_create_table:
38 create id_temporary table if not exists id_table ( id_col_def_list ) engine= id_engine row_format=compressed
39
40stmt_add_col_to_table:
41 alter table id_table add column id_col_def id_alter_pos |
42
43id_alter_pos:
44 | first | after id_col
45
46stmt_drop_table:
47 drop id_temporary table if exists id_table ;select sleep(0.01)
48
49id_engine:
50 myisam | innodb | blackhole | memory
51
52stmt_create_function:
53 create function id_func_name (a blob) returns id_coltype id_characteristic begin stmt_select_into ; return id_user_var ; end;
54
55id_characteristic:
56 | deterministic | not deterministic | no sql | reads sql data | modifies sql data
57
58stmt_create_view:
59 create or replace view id_table as stmt_select
60
61id_union:
62 union all | union distinct
63
64stmt_select:
65 select id_col_list from id_table id_where id_group_having_order id_limit id_into
66
67stmt_select_into:
68 select id_col_list from id_table id_where id_group_having_order id_limit into id_user_var_list
69
70stmt_select_no_into:
71 select id_col_list from id_table id_where id_group_having_order id_limit
72
73stmt_update:
74 update id_ignore id_table set id_assign_cols id_where id_order id_limit
75
76stmt_insert:
77 insert id_ignore into id_table set id_col = data_val
78
79stmt_delete:
80 delete id_ignore from id_table id_where id_order id_limit
81
82stmt_replace:
83 replace into id_table set id_assign_cols
84
85stmt_trx:
86 start transaction | commit | start transaction | commit | start transaction | commit | rollback
87
88id_group_having_order:
89 | id_group_with_rollup id_having | id_group id_having id_order
90
91id_explain:
92 | explain | explain extended | explain /*!50605 format= id_explain_format */ | explain partitions |
93
94id_explain_format:
95 traditional | json
96
97id_into:
98 | | | into id_user_var_list
99
100id_ignore:
101 | ignore
102
103id_having:
104 | having id_expr_list | having ( id_expr_list ) id_op ( id_expr_list )
105
106id_group:
107 group by id_expr_list id_dir
108
109id_group_with_rollup:
110 | id_group id_rollup
111
112id_rollup:
113 | with rollup
114
115id_order:
116 |/* order by id_expr_list id_dir */
117
118id_col_list:
119 id_func | id_col | id_col | id_col | id_col | id_col , id_col_list
120
121id_dir:
122 | asc | desc
123
124id_limit:
125 | limit data_digit
126
127id_where:
128 | where id_expr_list | where ( id_expr_list ) id_op ( id_expr_list )
129
130id_expr_list:
131 ( stmt_select_no_into ) | id_expr | id_expr | ( id_expr id_op id_expr_list )
132
133id_op:
134 <> | <=> | > | >= | < | <= | and | or | xor | & | not like | like | sounds like |=
135
136
137id_expr:
138 id_func | ( id_col id_op data_val ) | ( id_col id_op id_col ) | ( id_col ) | ( data_val ) | ( id_col is null )
139
140id_col_def_list:
141 id_col_def | id_col_def , id_col_def_list
142
143id_col_def:
144 id_col id_coltype
145
146id_assign_cols:
147 id_col = data_val | id_col = data_val , id_assign_cols
148
149data_val:
150 id_sign data_number . data_number | id_sign data_number | ' data_string ' | id_col | null
151
152id_sign:
153 |-|+
154data_number:
155 data_digit | data_digit |data_digit |data_digit | data_digit data_number
156
157data_digit:
158 0 | 1 | 2| 3
159
160data_string:
161 data_char | data_char |data_char |data_char | data_char data_string
162
163data_char:
164 a | b | c | d | e | f | g | h | i
165
166id_user_var_list:
167 id_user_var | id_user_var | id_user_var | id_user_var | id_user_var | id_user_var , id_user_var_list
168
169id_user_var:
170 @`a` | @`b` | @`c`
171
172id_table_list:
173 id_table | id_table , id_table_list
174
175id_table:
176 `t data_digit `
177
178id_col_list:
179 id_col | id_col , id_col_list
180
181id_col:
182 `col data_digit `
183
184id_coltype:
185 id_numeric_type | id_datetime_type | id_string_type
186
187id_string_type:
188 varchar( data_number ) | char( data_number ) | binary( data_number ) | tinyblob | blob | longblob | mediumblob | tinytext | text | longtext | mediumtext
189
190id_datetime_type:
191 date | time | datetime | timestamp
192id_numeric_type:
193 tinyint | smallint | mediumint | int | bigint | decimal | decimal( data_number , data_number ) | float | float( data_number , data_number ) | double | double( data_number , data_number ) | bit( data_number )
194
195
196id_proc_name:
197 `p1` | `p2` | `p3`
198
199id_func_name:
200 `f1` | `f2` | `f3`
201
202id_func:
203 id_func_name ( ( id_expr )) | id_func_name ( ( stmt_select )) | ABS( id_expr ) | ACOS( id_expr ) | ADDTIME( id_expr , id_expr ) | AES_DECRYPT( id_expr , id_expr ) | AES_ENCRYPT( id_expr , id_expr ) | AREA( id_expr ) | ASBINARY( id_expr ) | ASIN( id_expr ) | ASTEXT( id_expr ) | ASWKB( id_expr ) | ASWKT( id_expr ) | ATAN( id_expr ) | ATAN( id_expr , id_expr ) | ATAN2( id_expr ) | ATAN2( id_expr , id_expr ) | BENCHMARK( id_expr , id_expr ) | BIN( id_expr ) | BIT_COUNT( id_expr ) | BUFFER( id_expr , id_expr ) | BIT_LENGTH( id_expr ) | CEIL( id_expr ) | CEILING( id_expr ) | CENTROID( id_expr ) | CHARACTER_LENGTH( id_expr ) | CHAR_LENGTH( id_expr ) | COERCIBILITY( id_expr ) | COMPRESS( id_expr ) | CONCAT( id_expr ) | CONCAT( id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONCAT_WS( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | CONNECTION_ID( ) | CONV( id_expr , id_expr , id_expr ) | CONVERT_TZ( id_expr , id_expr , id_expr ) | COS( id_expr ) | CRC32( id_expr ) | CROSSES( id_expr , id_expr ) | DATEDIFF( id_expr , id_expr ) | DATE_FORMAT( id_expr , id_expr ) | DAYNAME( id_expr ) | DAYOFMONTH( id_expr ) | DAYOFWEEK( id_expr ) | DAYOFYEAR( id_expr ) | DECODE( id_expr , id_expr ) | DEGREES( id_expr ) | DES_DECRYPT( id_expr ) | DES_DECRYPT( id_expr , id_expr ) | DES_ENCRYPT( id_expr ) | DES_ENCRYPT( id_expr , id_expr ) | DIMENSION( id_expr ) | DISJOINT( id_expr , id_expr ) | ELT( id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr , id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | ELT( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | ENCODE( id_expr , id_expr ) | ENCRYPT( id_expr ) | ENCRYPT( id_expr , id_expr ) | ENDPOINT( id_expr ) | ENVELOPE( id_expr ) | EQUALS( id_expr , id_expr ) | EXP( id_expr ) | EXPORT_SET( id_expr , id_expr , id_expr ) | EXPORT_SET( id_expr , id_expr , id_expr , id_expr ) | EXPORT_SET( id_expr , id_expr , id_expr , id_expr , id_expr ) | EXTERIORRING( id_expr ) | FIELD( id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | FIELD( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | FIND_IN_SET( id_expr , id_expr ) | FLOOR( id_expr ) | FOUND_ROWS( ) | FROM_BASE64( id_expr ) | FROM_DAYS( id_expr ) | FROM_UNIXTIME( id_expr ) | FROM_UNIXTIME( id_expr , id_expr ) | GEOMCOLLFROMTEXT( id_expr ) | GEOMCOLLFROMTEXT( id_expr , id_expr ) | GEOMCOLLFROMWKB( id_expr ) | GEOMCOLLFROMWKB( id_expr , id_expr ) | GEOMETRYCOLLECTIONFROMTEXT( id_expr ) | GEOMETRYCOLLECTIONFROMTEXT( id_expr , id_expr ) | GEOMETRYCOLLECTIONFROMWKB( id_expr ) | GEOMETRYCOLLECTIONFROMWKB( id_expr , id_expr ) | GEOMETRYFROMTEXT( id_expr ) | GEOMETRYFROMTEXT( id_expr , id_expr ) | GEOMETRYFROMWKB( id_expr ) | GEOMETRYFROMWKB( id_expr , id_expr ) | GEOMETRYN( id_expr , id_expr ) | GEOMETRYTYPE( id_expr ) | GEOMFROMTEXT( id_expr ) | GEOMFROMTEXT( id_expr , id_expr ) | GEOMFROMWKB( id_expr ) | GEOMFROMWKB( id_expr , id_expr ) | GET_LOCK( id_expr , id_expr ) | GLENGTH( id_expr ) | GREATEST( id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | GREATEST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | HEX( id_expr ) | IFNULL( id_expr , id_expr ) | INET_ATON( id_expr ) | INET_NTOA( id_expr ) | INET6_ATON( id_expr ) | INET6_NTOA( id_expr ) | IS_IPV4( id_expr ) | IS_IPV6( id_expr ) | IS_IPV4_COMPAT( id_expr ) | IS_IPV4_MAPPED( id_expr ) | INSTR( id_expr , id_expr ) | INTERIORRINGN( id_expr , id_expr ) | INTERSECTS( id_expr , id_expr ) | ISCLOSED( id_expr ) | ISEMPTY( id_expr ) | ISNULL( id_expr ) | ISSIMPLE( id_expr ) | IS_FREE_LOCK( id_expr ) | IS_USED_LOCK( id_expr ) | LAST_DAY( id_expr ) | LAST_INSERT_ID( ) | LAST_INSERT_ID( id_expr ) | LEAST( id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | LEAST( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | LENGTH( id_expr ) | LIKE_RANGE_MIN( id_expr , id_expr ) | LIKE_RANGE_MAX( id_expr , id_expr ) | LINEFROMTEXT( id_expr ) | LINEFROMTEXT( id_expr , id_expr ) | LINEFROMWKB( id_expr ) | LINEFROMWKB( id_expr , id_expr ) | LINESTRINGFROMTEXT( id_expr ) | LINESTRINGFROMTEXT( id_expr , id_expr ) | LINESTRINGFROMWKB( id_expr ) | LINESTRINGFROMWKB( id_expr , id_expr ) | LN( id_expr ) | LOAD_FILE( id_expr ) | LOCATE( id_expr , id_expr ) | LOCATE( id_expr , id_expr , id_expr ) | LOG( id_expr ) | LOG( id_expr , id_expr ) | LOG10( id_expr ) | LOG2( id_expr ) | LOWER( id_expr ) | LPAD( id_expr , id_expr , id_expr ) | LTRIM( id_expr ) | MAKEDATE( id_expr , id_expr ) | MAKETIME( id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | MAKE_SET( id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr , id_expr ) | MASTER_POS_WAIT( id_expr , id_expr ) | MBRCONTAINS( id_expr , id_expr ) | MBRDISJOINT( id_expr , id_expr ) | MBREQUAL( id_expr , id_expr ) | MBRINTERSECTS( id_expr , id_expr ) | MBROVERLAPS( id_expr , id_expr ) | MBRTOUCHES( id_expr , id_expr ) | MBRWITHIN( id_expr , id_expr ) | MD5( id_expr ) | MLINEFROMTEXT( id_expr ) | MLINEFROMTEXT( id_expr , id_expr ) | MLINEFROMWKB( id_expr ) | MLINEFROMWKB( id_expr , id_expr ) | MONTHNAME( id_expr ) | MPOINTFROMTEXT( id_expr ) | MPOINTFROMTEXT( id_expr , id_expr ) | MPOINTFROMWKB( id_expr ) | MPOINTFROMWKB( id_expr , id_expr ) | MPOLYFROMTEXT( id_expr ) | MPOLYFROMTEXT( id_expr , id_expr ) | MPOLYFROMWKB( id_expr ) | MPOLYFROMWKB( id_expr , id_expr ) | MULTILINESTRINGFROMTEXT( id_expr ) | MULTILINESTRINGFROMTEXT( id_expr , id_expr ) | MULTILINESTRINGFROMWKB( id_expr ) | MULTILINESTRINGFROMWKB( id_expr , id_expr ) | MULTIPOINTFROMTEXT( id_expr ) | MULTIPOINTFROMTEXT( id_expr , id_expr ) | MULTIPOINTFROMWKB( id_expr ) | MULTIPOINTFROMWKB( id_expr , id_expr ) | MULTIPOLYGONFROMTEXT( id_expr ) | MULTIPOLYGONFROMTEXT( id_expr , id_expr ) | MULTIPOLYGONFROMWKB( id_expr , id_expr ) | NAME_CONST( id_expr , id_expr ) | NULLIF( id_expr , id_expr ) | NUMGEOMETRIES( id_expr ) | NUMINTERIORRINGS( id_expr ) | NUMPOINTS( id_expr ) | OCT( id_expr ) | OCTET_LENGTH( id_expr ) | ORD( id_expr ) | OVERLAPS( id_expr , id_expr ) | PERIOD_ADD( id_expr , id_expr ) | PERIOD_DIFF( id_expr , id_expr ) | PI( ) | POINTFROMTEXT( id_expr ) | POINTFROMTEXT( id_expr , id_expr ) | POINTFROMWKB( id_expr ) | POINTFROMWKB( id_expr , id_expr ) | POINTN( id_expr , id_expr ) | POLYFROMTEXT( id_expr ) | POLYFROMTEXT( id_expr , id_expr ) | POLYFROMWKB( id_expr ) | POLYFROMWKB( id_expr , id_expr ) | POLYGONFROMTEXT( id_expr ) | POLYGONFROMTEXT( id_expr , id_expr ) | POLYGONFROMWKB( id_expr ) | POLYGONFROMWKB( id_expr , id_expr ) | POW( id_expr , id_expr ) | POWER( id_expr , id_expr ) | QUOTE( id_expr ) | RADIANS( id_expr ) | RAND( ) | RAND( id_expr ) | RELEASE_LOCK( id_expr ) | REVERSE( id_expr ) | ROUND( id_expr ) | ROUND( id_expr , id_expr ) | RPAD( id_expr , id_expr , id_expr ) | RTRIM( id_expr ) | SEC_TO_TIME( id_expr ) | SHA( id_expr ) | SHA1( id_expr ) | SHA2( id_expr , id_expr ) | SIGN( id_expr ) | SIN( id_expr ) | SOUNDEX( id_expr ) | SPACE( id_expr ) | /*SQL_THREAD_WAIT_AFTER_GTIDS( id_expr )*/ | /*SQL_THREAD_WAIT_AFTER_GTIDS( id_expr , id_expr )*/ | SQRT( id_expr ) | SRID( id_expr ) | STARTPOINT( id_expr ) | STRCMP( id_expr , id_expr ) | STR_TO_DATE( id_expr , id_expr ) | ST_AREA( id_expr ) | ST_ASBINARY( id_expr ) | ST_ASTEXT( id_expr ) | ST_ASWKB( id_expr ) | ST_ASWKT( id_expr ) | ST_BUFFER( id_expr , id_expr ) | ST_CENTROID( id_expr ) | ST_CONTAINS( id_expr , id_expr ) | ST_CROSSES( id_expr , id_expr ) | ST_DIFFERENCE( id_expr , id_expr ) | ST_DIMENSION( id_expr ) | ST_DISJOINT( id_expr , id_expr ) | ST_DISTANCE( id_expr , id_expr ) | ST_ENDPOINT( id_expr ) | ST_ENVELOPE( id_expr ) | ST_EQUALS( id_expr , id_expr ) | ST_EQUALS( id_expr , id_expr ) | ST_EXTERIORRING( id_expr ) | ST_GEOMCOLLFROMTEXT( id_expr ) | ST_GEOMCOLLFROMTEXT( id_expr , id_expr ) | ST_GEOMCOLLFROMWKB( id_expr ) | ST_GEOMCOLLFROMWKB( id_expr , id_expr ) | ST_GEOMETRYCOLLECTIONFROMTEXT( id_expr ) | ST_GEOMETRYCOLLECTIONFROMTEXT( id_expr , id_expr ) | ST_GEOMETRYCOLLECTIONFROMWKB( id_expr ) | ST_GEOMETRYCOLLECTIONFROMWKB( id_expr , id_expr ) | ST_GEOMETRYFROMTEXT( id_expr ) | ST_GEOMETRYFROMTEXT( id_expr , id_expr ) | ST_GEOMETRYFROMWKB( id_expr ) | ST_GEOMETRYFROMWKB( id_expr , id_expr ) | ST_GEOMETRYN( id_expr , id_expr ) | ST_GEOMETRYTYPE( id_expr ) | ST_GEOMFROMTEXT( id_expr ) | ST_GEOMFROMTEXT( id_expr , id_expr ) | ST_GEOMFROMWKB( id_expr ) | ST_GEOMFROMWKB( id_expr , id_expr ) | ST_GIS_DEBUG( id_expr ) | ST_INTERIORRINGN( id_expr , id_expr ) | ST_INTERSECTS( id_expr , id_expr ) | ST_INTERSECTION( id_expr , id_expr ) | ST_ISCLOSED( id_expr ) | ST_ISEMPTY( id_expr ) | ST_ISSIMPLE( id_expr ) | ST_LENGTH( id_expr ) | ST_LINEFROMTEXT( id_expr ) | ST_LINEFROMTEXT( id_expr , id_expr ) | ST_LINEFROMWKB( id_expr ) | ST_LINEFROMWKB( id_expr , id_expr ) | ST_LINESTRINGFROMTEXT( id_expr ) | ST_LINESTRINGFROMTEXT( id_expr , id_expr ) | ST_LINESTRINGFROMWKB( id_expr ) | ST_LINESTRINGFROMWKB( id_expr , id_expr ) | ST_NUMGEOMETRIES( id_expr ) | ST_NUMINTERIORRINGS( id_expr ) | ST_NUMPOINTS( id_expr ) | ST_OVERLAPS( id_expr , id_expr ) | ST_POINTFROMTEXT( id_expr ) | ST_POINTFROMWKB( id_expr ) | ST_POINTFROMWKB( id_expr , id_expr ) | ST_POINTN( id_expr , id_expr ) | ST_POLYFROMTEXT( id_expr ) | ST_POLYFROMTEXT( id_expr , id_expr ) | ST_POLYFROMWKB( id_expr ) | ST_POLYFROMWKB( id_expr , id_expr ) | ST_POLYGONFROMTEXT( id_expr ) | ST_POLYGONFROMTEXT( id_expr , id_expr ) | ST_POLYGONFROMWKB( id_expr ) | ST_POLYGONFROMWKB( id_expr , id_expr ) | ST_SRID( id_expr ) | ST_STARTPOINT( id_expr ) | ST_SYMDIFFERENCE( id_expr , id_expr ) | ST_TOUCHES( id_expr , id_expr ) | ST_UNION( id_expr , id_expr ) | ST_WITHIN( id_expr , id_expr ) | ST_X( id_expr ) | ST_Y( id_expr ) | SUBSTRING_INDEX( id_expr , id_expr , id_expr ) | SUBTIME( id_expr , id_expr ) | TAN( id_expr ) | TIMEDIFF( id_expr , id_expr ) | TIME_FORMAT( id_expr , id_expr ) | TIME_TO_SEC( id_expr ) | TOUCHES( id_expr , id_expr ) | TO_BASE64( id_expr ) | TO_DAYS( id_expr ) | TO_SECONDS( id_expr ) | UCASE( id_expr ) | UNCOMPRESS( id_expr ) | UNCOMPRESSED_LENGTH( id_expr ) | UNHEX( id_expr ) | UNIX_TIMESTAMP( ) | UNIX_TIMESTAMP( id_expr ) | UPPER( id_expr ) | UUID( ) | UUID_SHORT( ) | VALIDATE_PASSWORD_STRENGTH( id_expr ) | VERSION( ) | WEEKDAY( id_expr ) | WEEKOFYEAR( id_expr ) | WITHIN( id_expr , id_expr ) | X( id_expr ) | Y( id_expr ) | YEARWEEK( id_expr ) | YEARWEEK( id_expr , id_expr ) |