| List: | Commits | « Previous MessageNext Message » | |
| From: | paul | Date: | January 12 2007 7:17pm |
| Subject: | svn commit - mysqldoc@docsrva: r4478 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | ||
| View as plain text | |||
Author: paul Date: 2007-01-12 19:17:26 +0100 (Fri, 12 Jan 2007) New Revision: 4478 Log: r18017@polar: paul | 2007-01-12 12:05:28 -0600 Add function id tags. Modified: trunk/refman-4.1/functions.xml trunk/refman-5.0/functions.xml trunk/refman-5.1/functions.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:17990 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14416 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:18017 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:14416 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:13015 Modified: trunk/refman-4.1/functions.xml =================================================================== --- trunk/refman-4.1/functions.xml 2007-01-12 18:12:45 UTC (rev 4477) +++ trunk/refman-4.1/functions.xml 2007-01-12 18:17:26 UTC (rev 4478) Changed blocks: 217, Lines Added: 270, Lines Deleted: 217; 48761 bytes @@ -815,7 +815,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_between"> <indexterm> <primary>BETWEEN ... AND</primary> </indexterm> @@ -882,7 +882,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not_between"> <indexterm> <primary>NOT BETWEEN</primary> </indexterm> @@ -911,7 +911,7 @@ <remark role="help-syntax-begin"/> - <para id="function_is_null"> + <para id="function_coalesce"> <indexterm> <primary><literal>NULL</literal></primary> <secondary>testing for null</secondary> @@ -955,7 +955,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_greatest"> <indexterm> <primary>GREATEST()</primary> </indexterm> @@ -1003,7 +1003,7 @@ <remark role="help-syntax-begin"/> - <para id="function_between"> + <para id="function_in"> <indexterm> <primary>IN</primary> </indexterm> @@ -1090,7 +1090,7 @@ <remark role="help-syntax-begin"/> - <para id="function_not_between"> + <para id="function_not_in"> <indexterm> <primary>NOT IN</primary> </indexterm> @@ -1117,7 +1117,7 @@ <remark role="help-syntax-begin"/> - <para id="function_coalesce"> + <para id="function_isnull"> <indexterm> <primary>ISNULL()</primary> </indexterm> @@ -1167,7 +1167,7 @@ <remark role="help-syntax-begin"/> - <para id="function_greatest"> + <para id="function_interval"> <indexterm> <primary>INTERVAL()</primary> </indexterm> @@ -1213,7 +1213,7 @@ <remark role="help-syntax-begin"/> - <para id="function_in"> + <para id="function_least"> <indexterm> <primary>LEAST()</primary> </indexterm> @@ -1347,7 +1347,7 @@ <remark role="help-syntax-begin"/> - <para id="function_not_in"> + <para id="function_not"> <indexterm> <primary>NOT</primary> <secondary>logical</secondary> @@ -1404,7 +1404,7 @@ <remark role="help-syntax-begin"/> - <para id="function_isnull"> + <para id="function_and"> <indexterm> <primary>AND</primary> <secondary>logical</secondary> @@ -1468,7 +1468,7 @@ <remark role="help-syntax-begin"/> - <para id="function_interval"> + <para id="function_or"> <indexterm> <primary>OR</primary> <secondary>logical</secondary> @@ -1520,7 +1520,7 @@ <remark role="help-syntax-begin"/> - <para id="function_least"> + <para id="function_xor"> <indexterm> <primary>XOR</primary> <secondary>logical</secondary> @@ -1598,7 +1598,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_case"> <indexterm> <primary>CASE</primary> </indexterm> @@ -1680,7 +1680,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_if"> <indexterm> <primary>IF()</primary> </indexterm> @@ -1795,7 +1795,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ifnull"> <indexterm> <primary><literal>NULL</literal></primary> <secondary>testing for null</secondary> @@ -1869,7 +1869,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_nullif"> <indexterm> <primary>NULLIF()</primary> </indexterm> @@ -1954,7 +1954,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ascii"> <indexterm> <primary>ASCII()</primary> </indexterm> @@ -1999,7 +1999,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bin"> <indexterm> <primary>BIN()</primary> </indexterm> @@ -2036,7 +2036,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_length"> <indexterm> <primary>BIT_LENGTH()</primary> </indexterm> @@ -2072,7 +2072,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_char"> <indexterm> <primary>CHAR()</primary> </indexterm> @@ -2129,7 +2129,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_char_length"> <indexterm> <primary>CHAR_LENGTH()</primary> </indexterm> @@ -2159,7 +2159,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_character_length"> <indexterm> <primary>CHARACTER_LENGTH()</primary> </indexterm> @@ -2184,7 +2184,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_concat"> <indexterm> <primary>CONCAT()</primary> </indexterm> @@ -2234,7 +2234,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_concat_ws"> <indexterm> <primary>CONCAT_WS()</primary> </indexterm> @@ -2281,7 +2281,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_conv"> <indexterm> <primary>CONV()</primary> </indexterm> @@ -2332,7 +2332,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_elt"> <indexterm> <primary>ELT()</primary> </indexterm> @@ -2373,7 +2373,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_export_set"> <indexterm> <primary>EXPORT_SET()</primary> </indexterm> @@ -2416,7 +2416,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_field"> <indexterm> <primary>FIELD()</primary> </indexterm> @@ -2469,7 +2469,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_find_in_set"> <indexterm> <primary>FIND_IN_SET()</primary> </indexterm> @@ -2517,7 +2517,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_format"> <indexterm> <primary>FORMAT()</primary> </indexterm> @@ -2557,7 +2557,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_hex"> <indexterm> <primary>HEX()</primary> </indexterm> @@ -2609,7 +2609,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_insert"> <indexterm> <primary>INSERT()</primary> </indexterm> @@ -2657,7 +2657,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_instr"> <indexterm> <primary>INSTR()</primary> </indexterm> @@ -2700,7 +2700,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lcase"> <indexterm> <primary>LCASE()</primary> </indexterm> @@ -2725,7 +2725,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_left"> <indexterm> <primary>LEFT()</primary> </indexterm> @@ -2757,7 +2757,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_length"> <indexterm> <primary>LENGTH()</primary> </indexterm> @@ -2794,7 +2794,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_load_file"> <indexterm> <primary>FILE</primary> </indexterm> @@ -2850,7 +2850,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_locate"> <indexterm> <primary>LOCATE()</primary> </indexterm> @@ -2900,7 +2900,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lower"> <indexterm> <primary>LOWER()</primary> </indexterm> @@ -2938,7 +2938,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lpad"> <indexterm> <primary>LPAD()</primary> </indexterm> @@ -2976,7 +2976,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ltrim"> <indexterm> <primary>LTRIM()</primary> </indexterm> @@ -3012,7 +3012,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_make_set"> <indexterm> <primary>MAKE_SET()</primary> </indexterm> @@ -3058,7 +3058,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mid"> <indexterm> <primary>MID()</primary> </indexterm> @@ -3084,7 +3084,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_oct"> <indexterm> <primary>OCT()</primary> </indexterm> @@ -3121,7 +3121,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_octet_length"> <indexterm> <primary>OCTET_LENGTH()</primary> </indexterm> @@ -3146,7 +3146,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ord"> <indexterm> <primary>ORD()</primary> </indexterm> @@ -3192,7 +3192,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_position"> <indexterm> <primary>POSITION()</primary> </indexterm> @@ -3219,7 +3219,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_quote"> <indexterm> <primary>QUOTE()</primary> </indexterm> @@ -3261,7 +3261,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_repeat"> <indexterm> <primary>REPEAT()</primary> </indexterm> @@ -3298,7 +3298,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_replace"> <indexterm> <primary>REPLACE()</primary> </indexterm> @@ -3337,7 +3337,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_reverse"> <indexterm> <primary>REVERSE()</primary> </indexterm> @@ -3373,7 +3373,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_right"> <indexterm> <primary>RIGHT()</primary> </indexterm> @@ -3409,7 +3409,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rpad"> <indexterm> <primary>RPAD()</primary> </indexterm> @@ -3451,7 +3451,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rtrim"> <indexterm> <primary>RTRIM()</primary> </indexterm> @@ -3487,7 +3487,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_soundex"> <indexterm> <primary>SOUNDEX()</primary> </indexterm> @@ -3574,7 +3574,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sounds_like"> <indexterm> <primary>SOUNDS LIKE</primary> </indexterm> @@ -3602,7 +3602,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_space"> <indexterm> <primary>SPACE()</primary> </indexterm> @@ -3634,7 +3634,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_substring"> <indexterm> <primary>SUBSTRING()</primary> </indexterm> @@ -3712,7 +3712,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_substring_index"> <indexterm> <primary>SUBSTRING_INDEX()</primary> </indexterm> @@ -3763,7 +3763,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_trim"> <indexterm> <primary>TRIM()</primary> </indexterm> @@ -3814,7 +3814,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ucase"> <indexterm> <primary>UCASE()</primary> </indexterm> @@ -3843,7 +3843,7 @@ <remark role="help-description-begin"/> - <para> + <para id="function_unhex"> <indexterm> <primary>UNHEX()</primary> </indexterm> @@ -3885,7 +3885,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_upper"> <indexterm> <primary>UPPER()</primary> </indexterm> @@ -3969,7 +3969,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_like"> <indexterm> <primary>LIKE</primary> </indexterm> @@ -4152,7 +4152,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not_like"> <indexterm> <primary>NOT LIKE</primary> </indexterm> @@ -4181,7 +4181,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not_regexp"> <indexterm> <primary>NOT REGEXP</primary> </indexterm> @@ -4214,7 +4214,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rlike"> <indexterm> <primary>mSQL compatibility</primary> </indexterm> @@ -4310,7 +4310,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_strcmp"> <indexterm> <primary>STRCMP()</primary> </indexterm> @@ -4441,7 +4441,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_plus"> <indexterm> <primary>+ (addition)</primary> </indexterm> @@ -4476,7 +4476,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_minus"> <indexterm> <primary>- (subtraction)</primary> </indexterm> @@ -4511,7 +4511,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_unary_minus"> <indexterm> <primary>- (unary minus)</primary> </indexterm> @@ -4559,7 +4559,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_times"> <indexterm> <primary>* (multiplication)</primary> </indexterm> @@ -4605,7 +4605,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_by"> <indexterm> <primary>/ (division)</primary> </indexterm> @@ -4659,7 +4659,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_div"> <indexterm> <primary>DIV</primary> </indexterm> @@ -4699,7 +4699,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mod2"> <indexterm> <primary>%</primary> </indexterm> @@ -4754,7 +4754,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_abs"> <indexterm> <primary>ABS()</primary> </indexterm> @@ -4792,7 +4792,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_acos"> <indexterm> <primary>ACOS()</primary> </indexterm> @@ -4831,7 +4831,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_asin"> <indexterm> <primary>ASIN()</primary> </indexterm> @@ -4868,7 +4868,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_atan"> <indexterm> <primary>ATAN()</primary> </indexterm> @@ -4903,7 +4903,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_atan2"> <indexterm> <primary>ATAN2()</primary> </indexterm> @@ -4947,7 +4947,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ceiling"> <indexterm> <primary>CEILING()</primary> </indexterm> @@ -4992,7 +4992,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cos"> <indexterm> <primary>COS()</primary> </indexterm> @@ -5024,7 +5024,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cot"> <indexterm> <primary>COT()</primary> </indexterm> @@ -5057,7 +5057,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_crc32"> <indexterm> <primary>CRC32()</primary> </indexterm> @@ -5096,7 +5096,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_degrees"> <indexterm> <primary>DEGREES()</primary> </indexterm> @@ -5128,7 +5128,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_exp"> <indexterm> <primary>EXP()</primary> </indexterm> @@ -5163,7 +5163,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_floor"> <indexterm> <primary>FLOOR()</primary> </indexterm> @@ -5221,7 +5221,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ln"> <indexterm> <primary>LN()</primary> </indexterm> @@ -5262,7 +5262,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log"> <indexterm> <primary>LOG()</primary> </indexterm> @@ -5317,7 +5317,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log2"> <indexterm> <primary>LOG2()</primary> </indexterm> @@ -5359,7 +5359,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log10"> <indexterm> <primary>LOG10()</primary> </indexterm> @@ -5399,7 +5399,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mod"> <indexterm> <primary>MOD()</primary> </indexterm> @@ -5492,7 +5492,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_pi"> <indexterm> <primary>PI()</primary> </indexterm> @@ -5531,7 +5531,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_pow"> <indexterm> <primary>POW()</primary> </indexterm> @@ -5570,7 +5570,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_radians"> <indexterm> <primary>RADIANS()</primary> </indexterm> @@ -5603,7 +5603,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rand"> <indexterm> <primary>RAND()</primary> </indexterm> @@ -5703,7 +5703,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_round"> <indexterm> <primary>ROUND()</primary> </indexterm> @@ -5770,7 +5770,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sign"> <indexterm> <primary>SIGN()</primary> </indexterm> @@ -5808,7 +5808,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sin"> <indexterm> <primary>SIN()</primary> </indexterm> @@ -5842,7 +5842,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sqrt"> <indexterm> <primary>SQRT()</primary> </indexterm> @@ -5878,7 +5878,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_tan"> <indexterm> <primary>TAN()</primary> </indexterm> @@ -5912,7 +5912,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_truncate"> <indexterm> <primary>TRUNCATE()</primary> </indexterm> @@ -6070,7 +6070,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_adddate"> <indexterm> <primary>ADDDATE()</primary> </indexterm> @@ -6125,7 +6125,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_addtime"> <indexterm> <primary>ADDTIME()</primary> </indexterm> @@ -6172,7 +6172,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_convert_tz"> <indexterm> <primary>CONVERT_TZ()</primary> </indexterm> @@ -6238,7 +6238,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_curdate"> <indexterm> <primary>CURDATE()</primary> </indexterm> @@ -6274,7 +6274,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_date"> <indexterm> <primary>CURRENT_DATE</primary> </indexterm> @@ -6301,7 +6301,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_curtime"> <indexterm> <primary>CURTIME()</primary> </indexterm> @@ -6337,7 +6337,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_time"> <indexterm> <primary>CURRENT_TIME</primary> </indexterm> @@ -6364,7 +6364,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_timestamp"> <indexterm> <primary>CURRENT_TIMESTAMP</primary> </indexterm> @@ -6395,7 +6395,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date"> <indexterm> <primary>DATE()</primary> </indexterm> @@ -6431,7 +6431,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_datediff"> <indexterm> <primary>DATEDIFF()</primary> </indexterm> @@ -6484,7 +6484,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date_add"> <indexterm> <primary>DATE_ADD()</primary> </indexterm> @@ -6787,7 +6787,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date_format"> <indexterm> <primary>DATE_FORMAT()</primary> </indexterm> @@ -7017,7 +7017,7 @@ <remark role="help-syntax-begin"/> - <para> + <para if="function_date_sub"> <indexterm> <primary>DATE_SUB()</primary> </indexterm> @@ -7043,7 +7043,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_day"> <indexterm> <primary>DAY()</primary> </indexterm> @@ -7069,7 +7069,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayname"> <indexterm> <primary>DAYNAME()</primary> </indexterm> @@ -7104,7 +7104,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofmonth"> <indexterm> <primary>DAYOFMONTH()</primary> </indexterm> @@ -7137,7 +7137,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofweek"> <indexterm> <primary>DAYOFWEEK()</primary> </indexterm> @@ -7171,7 +7171,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofyear"> <indexterm> <primary>DAYOFYEAR()</primary> </indexterm> @@ -7204,7 +7204,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_extract"> <indexterm> <primary>EXTRACT()</primary> </indexterm> @@ -7250,7 +7250,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_from_days"> <indexterm> <primary>FROM_DAYS()</primary> </indexterm> @@ -7289,7 +7289,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_from_unixtime"> <indexterm> <primary>FROM_UNIXTIME()</primary> </indexterm> @@ -7349,7 +7349,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_get_format"> <indexterm> <primary>GET_FORMAT()</primary> </indexterm> @@ -7510,7 +7510,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_hour"> <indexterm> <primary>HOUR()</primary> </indexterm> @@ -7548,7 +7548,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_last_day"> <indexterm> <primary>LAST_DAY()</primary> </indexterm> @@ -7591,7 +7591,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_localtime"> <indexterm> <primary>LOCALTIME</primary> </indexterm> @@ -7617,7 +7617,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_localtimestamp"> <indexterm> <primary>LOCALTIMESTAMP</primary> </indexterm> @@ -7648,7 +7648,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_makedate"> <indexterm> <primary>MAKEDATE()</primary> </indexterm> @@ -7689,7 +7689,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_maketime"> <indexterm> <primary>MAKETIME()</primary> </indexterm> @@ -7727,7 +7727,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_microsecond"> <indexterm> <primary>MICROSECOND()</primary> </indexterm> @@ -7767,7 +7767,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_minute"> <indexterm> <primary>MINUTE()</primary> </indexterm> @@ -7799,7 +7799,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_month"> <indexterm> <primary>MONTH()</primary> </indexterm> @@ -7831,7 +7831,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_monthname"> <indexterm> <primary>MONTHNAME()</primary> </indexterm> @@ -7866,7 +7866,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_now"> <indexterm> <primary>NOW()</primary> </indexterm> @@ -7902,7 +7902,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_period_add"> <indexterm> <primary>PERIOD_ADD()</primary> </indexterm> @@ -7938,7 +7938,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_period_diff"> <indexterm> <primary>PERIOD_DIFF()</primary> </indexterm> @@ -7976,7 +7976,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_quarter"> <indexterm> <primary>QUARTER()</primary> </indexterm> @@ -8009,7 +8009,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_second"> <indexterm> <primary>SECOND()</primary> </indexterm> @@ -8041,7 +8041,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sec_to_time"> <indexterm> <primary>SEC_TO_TIME()</primary> </indexterm> @@ -8092,7 +8092,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_str_to_date"> <indexterm> <primary>STR_TO_DATE()</primary> </indexterm> @@ -8193,7 +8193,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_subdate"> <indexterm> <primary>SUBDATE()</primary> </indexterm> @@ -8244,7 +8244,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_subtime"> <indexterm> <primary>SUBTIME()</primary> </indexterm> @@ -8291,7 +8291,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sysdate"> <indexterm> <primary>SYSDATE()</primary> </indexterm> @@ -8322,7 +8322,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time"> <indexterm> <primary>TIME()</primary> </indexterm> @@ -8360,7 +8360,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timediff"> <indexterm> <primary>TIMEDIFF()</primary> </indexterm> @@ -8412,7 +8412,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timestamp"> <indexterm> <primary>TIMESTAMP()</primary> </indexterm> @@ -8455,7 +8455,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time_format"> <indexterm> <primary>TIME_FORMAT()</primary> </indexterm> @@ -8499,7 +8499,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time_to_sec"> <indexterm> <primary>TIME_TO_SEC()</primary> </indexterm> @@ -8533,7 +8533,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_to_days"> <indexterm> <primary>TO_DAYS()</primary> </indexterm> @@ -8590,7 +8590,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_unix_timestamp"> <indexterm> <primary>UNIX_TIMESTAMP()</primary> </indexterm> @@ -8697,7 +8697,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_date"> <indexterm> <primary>UTC_DATE()</primary> </indexterm> @@ -8735,7 +8735,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_time"> <indexterm> <primary>UTC_TIME()</primary> </indexterm> @@ -8773,7 +8773,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_timestamp"> <indexterm> <primary>UTC_TIMESTAMP()</primary> </indexterm> @@ -8813,7 +8813,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_week"> <indexterm> <primary>WEEK()</primary> </indexterm> @@ -9001,7 +9001,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_weekday"> <indexterm> <primary>WEEKDAY()</primary> </indexterm> @@ -9036,7 +9036,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_weekofyear"> <indexterm> <primary>WEEKOFYEAR()</primary> </indexterm> @@ -9076,7 +9076,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_year"> <indexterm> <primary>YEAR()</primary> </indexterm> @@ -9109,7 +9109,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_yearweek"> <indexterm> <primary>YEARWEEK()</primary> </indexterm> @@ -11238,7 +11238,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_binary"> <indexterm> <primary>BINARY</primary> </indexterm> @@ -11306,7 +11306,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cast"> <indexterm> <primary>CAST</primary> </indexterm> @@ -11677,7 +11677,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_or"> <indexterm> <primary>| (bitwise OR)</primary> </indexterm> @@ -11717,7 +11717,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_and"> <indexterm> <primary>& (bitwise AND)</primary> </indexterm> @@ -11757,7 +11757,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_xor"> <indexterm> <primary>^ (bitwise XOR)</primary> </indexterm> @@ -11805,7 +11805,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_left_shift"> <indexterm> <primary><< (left shift)</primary> </indexterm> @@ -11841,7 +11841,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_right_shift"> <indexterm> <primary>>> (right shift)</primary> </indexterm> @@ -11877,7 +11877,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_tilde"> <indexterm> <primary>~</primary> </indexterm> @@ -11912,7 +11912,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_count"> <indexterm> <primary>BIT_COUNT()</primary> </indexterm> @@ -11960,9 +11960,62 @@ <para> The functions in this section perform encryption and decryption, - and compression and uncompression. + and compression and uncompression: </para> + <informaltable> + <tgroup cols="2"> + <colspec colwidth="50*"/> + <colspec colwidth="50*"/> + <tbody> + <row> + <entry><emphasis role="bold">Compression or encryption</emphasis></entry> + <entry><emphasis role="bold">Uncompression or decryption</emphasis></entry> + </row> + <row> + <entry><link linkend="function_aes_encrypt">AES_ENCRYT()</link></entry> + <entry><link linkend="function_aes_encrypt">AES_DECRYPT()</link></entry> + </row> + <row> + <entry><link linkend="function_compress">COMPRESS()</link></entry> + <entry><link linkend="function_uncompress">UNCOMPRESS()</link></entry> + </row> + <row> + <entry><link linkend="function_encode">ENCODE()</link></entry> + <entry><link linkend="function_decode">DECODE()</link></entry> + </row> + <row> + <entry><link linkend="function_des_encrypt">DES_ENCRYPT()</link></entry> + <entry><link linkend="function_des_decrypt">DES_DECRYPT()</link></entry> + </row> + <row> + <entry><link linkend="function_encrypt">ENCRYPT()</link></entry> + <entry>Not available</entry> + </row> + <row> + <entry><link linkend="function_md5">MD5()</link></entry> + <entry>Not available</entry> + </row> + <row> + <entry><link linkend="function_old_password">OLD_PASSWORD()</link></entry> + <entry>Not available</entry> + </row> + <row> + <entry><link linkend="function_password">PASSWORD()</link></entry> + <entry>Not available</entry> + </row> + <row> + <entry><link linkend="function_sha1">SHA() or SHA1()</link></entry> + <entry>Not available</entry> + </row> + <row> + <entry>Not available</entry> + <entry><link linkend="function_uncompressed_length">UNCOMPRESSED_LENGTH()</link></entry> + </row> + </tbody> + </tgroup> + </informaltable> + <para> <emphasis role="bold">Note</emphasis>: The encryption and compression functions return binary strings. For many of these @@ -11991,7 +12044,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_aes_encrypt"> <indexterm> <primary>AES_ENCRYPT()</primary> </indexterm> @@ -12071,7 +12124,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_compress"> <indexterm> <primary>COMPRESS()</primary> </indexterm> @@ -12146,7 +12199,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_decode"> <indexterm> <primary>DECODE()</primary> </indexterm> @@ -12174,7 +12227,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_encode"> <indexterm> <primary>ENCODE()</primary> </indexterm> @@ -12210,7 +12263,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_des_decrypt"> <indexterm> <primary>DES_DECRYPT()</primary> </indexterm> @@ -12269,7 +12322,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_des_encrypt"> <indexterm> <primary>DES_ENCRYPT()</primary> </indexterm> @@ -12401,7 +12454,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_encrypt"> <indexterm> <primary>ENCRYPT()</primary> </indexterm> @@ -12460,7 +12513,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_md5"> <indexterm> <primary>MD5()</primary> </indexterm> @@ -12516,7 +12569,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_old_password"> <indexterm> <primary>OLD_PASSWORD()</primary> </indexterm> @@ -12549,7 +12602,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_password"> <indexterm> <primary>PASSWORD()</primary> </indexterm> @@ -12617,7 +12670,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sha1"> <indexterm> <primary>SHA1()</primary> </indexterm> @@ -12668,7 +12721,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_uncompress"> <indexterm> <primary>UNCOMPRESS()</primary> </indexterm> @@ -12711,7 +12764,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_uncompressed_length"> <indexterm> <primary>UNCOMPRESSED_LENGTH()</primary> </indexterm> @@ -12769,7 +12822,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_benchmark"> <indexterm> <primary>BENCHMARK()</primary> </indexterm> @@ -12819,7 +12872,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_charset"> <indexterm> <primary>CHARSET()</primary> </indexterm> @@ -12858,7 +12911,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_coercibility"> <indexterm> <primary>COERCIBILITY()</primary> </indexterm> @@ -12990,7 +13043,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_collation"> <indexterm> <primary>COLLATION()</primary> </indexterm> @@ -13027,7 +13080,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_connection_id"> <indexterm> <primary>CONNECTION_ID()</primary> </indexterm> @@ -13065,7 +13118,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_user"> <indexterm> <primary>CURRENT_USER()</primary> </indexterm> @@ -13126,7 +13179,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_database"> <indexterm> <primary>DATABASE()</primary> </indexterm> @@ -13162,7 +13215,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_found_rows"> <indexterm> <primary>FOUND_ROWS()</primary> </indexterm> @@ -13313,7 +13366,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_last_insert_id"> <indexterm> <primary>LAST_INSERT_ID([<replaceable>expr</replaceable>])</primary> </indexterm> @@ -13565,7 +13618,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_session_user"> <indexterm> <primary>SESSION_USER()</primary> </indexterm> @@ -13590,7 +13643,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_system_user"> <indexterm> <primary>SYSTEM_USER()</primary> </indexterm> @@ -13615,7 +13668,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_user"> <indexterm> <primary>USER()</primary> </indexterm> @@ -13677,7 +13730,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_version"> <indexterm> <primary>VERSION()</primary> </indexterm> @@ -13736,7 +13789,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_default"> <indexterm> <primary>DEFAULT()</primary> </indexterm> @@ -13789,7 +13842,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_get_lock"> <indexterm> <primary>timeout</primary> </indexterm> @@ -13881,7 +13934,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_inet_aton"> <indexterm> <primary>INET_ATON()</primary> </indexterm> @@ -13947,7 +14000,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_inet_ntoa"> <indexterm> <primary>INET_NTOA()</primary> </indexterm> @@ -13983,7 +14036,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_is_free_lock"> <indexterm> <primary>IS_FREE_LOCK()</primary> </indexterm> @@ -14016,7 +14069,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_is_used_lock"> <indexterm> <primary>IS_USED_LOCK()</primary> </indexterm> @@ -14047,7 +14100,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_master_pos_wait"> <indexterm> <primary>MASTER_POS_WAIT()</primary> </indexterm> @@ -14099,7 +14152,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_release_lock"> <indexterm> <primary>RELEASE_LOCK()</primary> </indexterm> @@ -14137,7 +14190,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_uuid"> <indexterm> <primary>UUID()</primary> </indexterm> @@ -14235,7 +14288,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_values"> <indexterm> <primary>VALUES()</primary> </indexterm> @@ -14349,7 +14402,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_avg"> <indexterm> <primary>AVG()</primary> </indexterm> @@ -14383,7 +14436,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_and"> <indexterm> <primary>BIT_AND()</primary> </indexterm> @@ -14418,7 +14471,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_or"> <indexterm> <primary>BIT_OR()</primary> </indexterm> @@ -14449,7 +14502,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_xor"> <indexterm> <primary>BIT_XOR()</primary> </indexterm> @@ -14484,7 +14537,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_count"> <indexterm> <primary>COUNT()</primary> </indexterm> @@ -14556,7 +14609,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_count_distinct"> <indexterm> <primary>COUNT(DISTINCT)</primary> </indexterm> @@ -14615,7 +14668,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_group_concat"> <indexterm> <primary>GROUP_CONCAT()</primary> </indexterm> @@ -14760,7 +14813,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_min"> <indexterm> <primary>MIN()</primary> </indexterm> @@ -14820,7 +14873,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_std"> <indexterm> <primary>STD()</primary> </indexterm> @@ -14866,7 +14919,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sum"> <indexterm> <primary>SUM()</primary> </indexterm> @@ -14897,7 +14950,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_variance"> <indexterm> <primary>VARIANCE()</primary> </indexterm> Modified: trunk/refman-5.0/functions.xml =================================================================== --- trunk/refman-5.0/functions.xml 2007-01-12 18:12:45 UTC (rev 4477) +++ trunk/refman-5.0/functions.xml 2007-01-12 18:17:26 UTC (rev 4478) Changed blocks: 203, Lines Added: 203, Lines Deleted: 203; 43081 bytes @@ -1414,7 +1414,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not"> <indexterm> <primary>NOT</primary> <secondary>logical</secondary> @@ -1477,7 +1477,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_and"> <indexterm> <primary>AND</primary> <secondary>logical</secondary> @@ -1529,7 +1529,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_or"> <indexterm> <primary>OR</primary> <secondary>logical</secondary> @@ -1581,7 +1581,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_xor"> <indexterm> <primary>XOR</primary> <secondary>logical</secondary> @@ -1655,7 +1655,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_case"> <indexterm> <primary>CASE</primary> </indexterm> @@ -1737,7 +1737,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_if"> <indexterm> <primary>IF()</primary> </indexterm> @@ -1858,7 +1858,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ifnull"> <indexterm> <primary><literal>NULL</literal></primary> <secondary>testing for null</secondary> @@ -1931,7 +1931,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_nullif"> <indexterm> <primary>NULLIF()</primary> </indexterm> @@ -2012,7 +2012,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ascii"> <indexterm> <primary>ASCII()</primary> </indexterm> @@ -2057,7 +2057,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bin"> <indexterm> <primary>BIN()</primary> </indexterm> @@ -2094,7 +2094,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_length"> <indexterm> <primary>BIT_LENGTH()</primary> </indexterm> @@ -2126,7 +2126,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_char"> <indexterm> <primary>CHAR()</primary> </indexterm> @@ -2223,7 +2223,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_char_length"> <indexterm> <primary>CHAR_LENGTH()</primary> </indexterm> @@ -2253,7 +2253,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_character_length"> <indexterm> <primary>CHARACTER_LENGTH()</primary> </indexterm> @@ -2278,7 +2278,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_concat"> <indexterm> <primary>CONCAT()</primary> </indexterm> @@ -2328,7 +2328,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_concat_ws"> <indexterm> <primary>CONCAT_WS()</primary> </indexterm> @@ -2374,7 +2374,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_conv"> <indexterm> <primary>CONV()</primary> </indexterm> @@ -2425,7 +2425,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_elt"> <indexterm> <primary>ELT()</primary> </indexterm> @@ -2466,7 +2466,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_export_set"> <indexterm> <primary>EXPORT_SET()</primary> </indexterm> @@ -2509,7 +2509,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_field"> <indexterm> <primary>FIELD()</primary> </indexterm> @@ -2562,7 +2562,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_find_in_set"> <indexterm> <primary>FIND_IN_SET()</primary> </indexterm> @@ -2610,7 +2610,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_format"> <indexterm> <primary>FORMAT()</primary> </indexterm> @@ -2650,7 +2650,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_hex"> <indexterm> <primary>HEX()</primary> </indexterm> @@ -2702,7 +2702,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_insert"> <indexterm> <primary>INSERT()</primary> </indexterm> @@ -2750,7 +2750,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_instr"> <indexterm> <primary>INSTR()</primary> </indexterm> @@ -2792,7 +2792,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lcase"> <indexterm> <primary>LCASE()</primary> </indexterm> @@ -2817,7 +2817,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_left"> <indexterm> <primary>LEFT()</primary> </indexterm> @@ -2851,7 +2851,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_length"> <indexterm> <primary>LENGTH()</primary> </indexterm> @@ -2888,7 +2888,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_load_file"> <indexterm> <primary>FILE</primary> </indexterm> @@ -2942,7 +2942,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_locate"> <indexterm> <primary>LOCATE()</primary> </indexterm> @@ -2991,7 +2991,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lower"> <indexterm> <primary>LOWER()</primary> </indexterm> @@ -3029,7 +3029,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_lpad"> <indexterm> <primary>LPAD()</primary> </indexterm> @@ -3067,7 +3067,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ltrim"> <indexterm> <primary>LTRIM()</primary> </indexterm> @@ -3103,7 +3103,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_make_set"> <indexterm> <primary>MAKE_SET()</primary> </indexterm> @@ -3149,7 +3149,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mid"> <indexterm> <primary>MID()</primary> </indexterm> @@ -3175,7 +3175,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_oct"> <indexterm> <primary>OCT()</primary> </indexterm> @@ -3212,7 +3212,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_octet_length"> <indexterm> <primary>OCTET_LENGTH()</primary> </indexterm> @@ -3237,7 +3237,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ord"> <indexterm> <primary>ORD()</primary> </indexterm> @@ -3283,7 +3283,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_position"> <indexterm> <primary>POSITION()</primary> </indexterm> @@ -3310,7 +3310,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_quote"> <indexterm> <primary>QUOTE()</primary> </indexterm> @@ -3351,7 +3351,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_repeat"> <indexterm> <primary>REPEAT()</primary> </indexterm> @@ -3388,7 +3388,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_replace"> <indexterm> <primary>REPLACE()</primary> </indexterm> @@ -3427,7 +3427,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_reverse"> <indexterm> <primary>REVERSE()</primary> </indexterm> @@ -3463,7 +3463,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_right"> <indexterm> <primary>RIGHT()</primary> </indexterm> @@ -3501,7 +3501,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rpad"> <indexterm> <primary>RPAD()</primary> </indexterm> @@ -3543,7 +3543,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rtrim"> <indexterm> <primary>RTRIM()</primary> </indexterm> @@ -3579,7 +3579,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_soundex"> <indexterm> <primary>SOUNDEX()</primary> </indexterm> @@ -3666,7 +3666,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sounds_like"> <indexterm> <primary>SOUNDS LIKE</primary> </indexterm> @@ -3693,7 +3693,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_space"> <indexterm> <primary>SPACE()</primary> </indexterm> @@ -3725,7 +3725,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_substring"> <indexterm> <primary>SUBSTRING()</primary> </indexterm> @@ -3803,7 +3803,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_substring_index"> <indexterm> <primary>SUBSTRING_INDEX()</primary> </indexterm> @@ -3854,7 +3854,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_trim"> <indexterm> <primary>TRIM()</primary> </indexterm> @@ -3905,7 +3905,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ucase"> <indexterm> <primary>UCASE()</primary> </indexterm> @@ -3934,7 +3934,7 @@ <remark role="help-description-begin"/> - <para> + <para id="function_unhex"> <indexterm> <primary>UNHEX()</primary> </indexterm> @@ -3972,7 +3972,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_upper"> <indexterm> <primary>UPPER()</primary> </indexterm> @@ -4056,7 +4056,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_like"> <indexterm> <primary>LIKE</primary> </indexterm> @@ -4246,7 +4246,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not_like"> <indexterm> <primary>NOT LIKE</primary> </indexterm> @@ -4275,7 +4275,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_not_regexp"> <indexterm> <primary>NOT REGEXP</primary> </indexterm> @@ -4308,7 +4308,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rlike"> <indexterm> <primary>mSQL compatibility</primary> </indexterm> @@ -4404,7 +4404,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_strcmp"> <indexterm> <primary>STRCMP()</primary> </indexterm> @@ -4545,7 +4545,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_plus"> <indexterm> <primary>+ (addition)</primary> </indexterm> @@ -4580,7 +4580,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_minus"> <indexterm> <primary>- (subtraction)</primary> </indexterm> @@ -4615,7 +4615,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_unary_minus"> <indexterm> <primary>- (unary minus)</primary> </indexterm> @@ -4663,7 +4663,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_times"> <indexterm> <primary>* (multiplication)</primary> </indexterm> @@ -4709,7 +4709,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_by"> <indexterm> <primary>/ (division)</primary> </indexterm> @@ -4763,7 +4763,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_div"> <indexterm> <primary>DIV</primary> </indexterm> @@ -4799,7 +4799,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mod2"> <indexterm> <primary>%</primary> </indexterm> @@ -4854,7 +4854,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_abs"> <indexterm> <primary>ABS()</primary> </indexterm> @@ -4892,7 +4892,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_acos"> <indexterm> <primary>ACOS()</primary> </indexterm> @@ -4931,7 +4931,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_asin"> <indexterm> <primary>ASIN()</primary> </indexterm> @@ -4981,7 +4981,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_atan"> <indexterm> <primary>ATAN()</primary> </indexterm> @@ -5016,7 +5016,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_atan2"> <indexterm> <primary>ATAN2()</primary> </indexterm> @@ -5060,7 +5060,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ceiling"> <indexterm> <primary>CEILING()</primary> </indexterm> @@ -5100,7 +5100,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cos"> <indexterm> <primary>COS()</primary> </indexterm> @@ -5132,7 +5132,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cot"> <indexterm> <primary>COT()</primary> </indexterm> @@ -5165,7 +5165,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_crc32"> <indexterm> <primary>CRC32()</primary> </indexterm> @@ -5202,7 +5202,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_degrees"> <indexterm> <primary>DEGREES()</primary> </indexterm> @@ -5236,7 +5236,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_exp"> <indexterm> <primary>EXP()</primary> </indexterm> @@ -5273,7 +5273,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_floor"> <indexterm> <primary>FLOOR()</primary> </indexterm> @@ -5331,7 +5331,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_ln"> <indexterm> <primary>LN()</primary> </indexterm> @@ -5372,7 +5372,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log"> <indexterm> <primary>LOG()</primary> </indexterm> @@ -5426,7 +5426,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log2"> <indexterm> <primary>LOG2()</primary> </indexterm> @@ -5468,7 +5468,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_log10"> <indexterm> <primary>LOG10()</primary> </indexterm> @@ -5514,7 +5514,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mod"> <indexterm> <primary>MOD()</primary> </indexterm> @@ -5594,7 +5594,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_pi"> <indexterm> <primary>PI()</primary> </indexterm> @@ -5633,7 +5633,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_pow"> <indexterm> <primary>POW()</primary> </indexterm> @@ -5672,7 +5672,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_radians"> <indexterm> <primary>RADIANS()</primary> </indexterm> @@ -5705,7 +5705,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_rand"> <indexterm> <primary>RAND()</primary> </indexterm> @@ -5805,7 +5805,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_round"> <indexterm> <primary>ROUND()</primary> </indexterm> @@ -5925,7 +5925,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sign"> <indexterm> <primary>SIGN()</primary> </indexterm> @@ -5963,7 +5963,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sin"> <indexterm> <primary>SIN()</primary> </indexterm> @@ -5997,7 +5997,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sqrt"> <indexterm> <primary>SQRT()</primary> </indexterm> @@ -6033,7 +6033,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_tan"> <indexterm> <primary>TAN()</primary> </indexterm> @@ -6067,7 +6067,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_truncate"> <indexterm> <primary>TRUNCATE()</primary> </indexterm> @@ -6223,7 +6223,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_adddate"> <indexterm> <primary>ADDDATE()</primary> </indexterm> @@ -6277,7 +6277,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_addtime"> <indexterm> <primary>ADDTIME()</primary> </indexterm> @@ -6320,7 +6320,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_convert_tz"> <indexterm> <primary>CONVERT_TZ()</primary> </indexterm> @@ -6382,7 +6382,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_curdate"> <indexterm> <primary>CURDATE()</primary> </indexterm> @@ -6418,7 +6418,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_date"> <indexterm> <primary>CURRENT_DATE</primary> </indexterm> @@ -6445,7 +6445,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_curtime"> <indexterm> <primary>CURTIME()</primary> </indexterm> @@ -6481,7 +6481,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_time"> <indexterm> <primary>CURRENT_TIME</primary> </indexterm> @@ -6508,7 +6508,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_timestamp"> <indexterm> <primary>CURRENT_TIMESTAMP</primary> </indexterm> @@ -6539,7 +6539,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date"> <indexterm> <primary>DATE()</primary> </indexterm> @@ -6571,7 +6571,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_datediff"> <indexterm> <primary>DATEDIFF()</primary> </indexterm> @@ -6620,7 +6620,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date_add"> <indexterm> <primary>DATE_ADD()</primary> </indexterm> @@ -6898,7 +6898,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date_format"> <indexterm> <primary>DATE_FORMAT()</primary> </indexterm> @@ -7120,7 +7120,7 @@ <remark role="help-syntax-begin"/> - <para> + <para if="function_date_sub"> <indexterm> <primary>DATE_SUB()</primary> </indexterm> @@ -7146,7 +7146,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_day"> <indexterm> <primary>DAY()</primary> </indexterm> @@ -7171,7 +7171,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayname"> <indexterm> <primary>DAYNAME()</primary> </indexterm> @@ -7206,7 +7206,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofmonth"> <indexterm> <primary>DAYOFMONTH()</primary> </indexterm> @@ -7239,7 +7239,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofweek"> <indexterm> <primary>DAYOFWEEK()</primary> </indexterm> @@ -7273,7 +7273,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_dayofyear"> <indexterm> <primary>DAYOFYEAR()</primary> </indexterm> @@ -7306,7 +7306,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_extract"> <indexterm> <primary>EXTRACT()</primary> </indexterm> @@ -7348,7 +7348,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_from_days"> <indexterm> <primary>FROM_DAYS()</primary> </indexterm> @@ -7387,7 +7387,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_from_unixtime"> <indexterm> <primary>FROM_UNIXTIME()</primary> </indexterm> @@ -7447,7 +7447,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_get_format"> <indexterm> <primary>GET_FORMAT()</primary> </indexterm> @@ -7603,7 +7603,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_hour"> <indexterm> <primary>HOUR()</primary> </indexterm> @@ -7641,7 +7641,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_last_day"> <indexterm> <primary>LAST_DAY()</primary> </indexterm> @@ -7680,7 +7680,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_localtime"> <indexterm> <primary>LOCALTIME</primary> </indexterm> @@ -7706,7 +7706,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_localtimestamp"> <indexterm> <primary>LOCALTIMESTAMP</primary> </indexterm> @@ -7733,7 +7733,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_makedate"> <indexterm> <primary>MAKEDATE()</primary> </indexterm> @@ -7770,7 +7770,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_maketime"> <indexterm> <primary>MAKETIME()</primary> </indexterm> @@ -7804,7 +7804,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_microsecond"> <indexterm> <primary>MICROSECOND()</primary> </indexterm> @@ -7839,7 +7839,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_minute"> <indexterm> <primary>MINUTE()</primary> </indexterm> @@ -7871,7 +7871,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_month"> <indexterm> <primary>MONTH()</primary> </indexterm> @@ -7903,7 +7903,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_monthname"> <indexterm> <primary>MONTHNAME()</primary> </indexterm> @@ -7938,7 +7938,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_now"> <indexterm> <primary>NOW()</primary> </indexterm> @@ -8006,7 +8006,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_period_add"> <indexterm> <primary>PERIOD_ADD()</primary> </indexterm> @@ -8042,7 +8042,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_period_diff"> <indexterm> <primary>PERIOD_DIFF()</primary> </indexterm> @@ -8080,7 +8080,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_quarter"> <indexterm> <primary>QUARTER()</primary> </indexterm> @@ -8113,7 +8113,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_second"> <indexterm> <primary>SECOND()</primary> </indexterm> @@ -8145,7 +8145,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sec_to_time"> <indexterm> <primary>SEC_TO_TIME()</primary> </indexterm> @@ -8182,7 +8182,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_str_to_date"> <indexterm> <primary>STR_TO_DATE()</primary> </indexterm> @@ -8291,7 +8291,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_subdate"> <indexterm> <primary>SUBDATE()</primary> </indexterm> @@ -8342,7 +8342,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_subtime"> <indexterm> <primary>SUBTIME()</primary> </indexterm> @@ -8385,7 +8385,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sysdate"> <indexterm> <primary>SYSDATE()</primary> </indexterm> @@ -8461,7 +8461,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time"> <indexterm> <primary>TIME()</primary> </indexterm> @@ -8495,7 +8495,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timediff"> <indexterm> <primary>TIMEDIFF()</primary> </indexterm> @@ -8543,7 +8543,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timestamp"> <indexterm> <primary>TIMESTAMP()</primary> </indexterm> @@ -8582,7 +8582,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timestampadd"> <indexterm> <primary>TIMESTAMPADD()</primary> </indexterm> @@ -8637,7 +8637,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_timestampdiff"> <indexterm> <primary>TIMESTAMPDIFF()</primary> </indexterm> @@ -8681,7 +8681,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time_format"> <indexterm> <primary>TIME_FORMAT()</primary> </indexterm> @@ -8725,7 +8725,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_time_to_sec"> <indexterm> <primary>TIME_TO_SEC()</primary> </indexterm> @@ -8759,7 +8759,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_to_days"> <indexterm> <primary>TO_DAYS()</primary> </indexterm> @@ -8816,7 +8816,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_unix_timestamp"> <indexterm> <primary>UNIX_TIMESTAMP()</primary> </indexterm> @@ -8919,7 +8919,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_date"> <indexterm> <primary>UTC_DATE()</primary> </indexterm> @@ -8953,7 +8953,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_time"> <indexterm> <primary>UTC_TIME()</primary> </indexterm> @@ -8987,7 +8987,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_utc_timestamp"> <indexterm> <primary>UTC_TIMESTAMP()</primary> </indexterm> @@ -9022,7 +9022,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_week"> <indexterm> <primary>WEEK()</primary> </indexterm> @@ -9192,7 +9192,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_weekday"> <indexterm> <primary>WEEKDAY()</primary> </indexterm> @@ -9227,7 +9227,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_weekofyear"> <indexterm> <primary>WEEKOFYEAR()</primary> </indexterm> @@ -9262,7 +9262,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_year"> <indexterm> <primary>YEAR()</primary> </indexterm> @@ -9295,7 +9295,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_yearweek"> <indexterm> <primary>YEARWEEK()</primary> </indexterm> @@ -11403,7 +11403,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_binary"> <indexterm> <primary>BINARY</primary> </indexterm> @@ -11469,7 +11469,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_cast"> <indexterm> <primary>CAST</primary> </indexterm> @@ -11778,7 +11778,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_or"> <indexterm> <primary>| (bitwise OR)</primary> </indexterm> @@ -11818,7 +11818,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_and"> <indexterm> <primary>& (bitwise AND)</primary> </indexterm> @@ -11858,7 +11858,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bitwise_xor"> <indexterm> <primary>^ (bitwise XOR)</primary> </indexterm> @@ -11902,7 +11902,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_left_shift"> <indexterm> <primary><< (left shift)</primary> </indexterm> @@ -11938,7 +11938,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_right_shift"> <indexterm> <primary>>> (right shift)</primary> </indexterm> @@ -11974,7 +11974,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_tilde"> <indexterm> <primary>~</primary> </indexterm> @@ -12009,7 +12009,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_count"> <indexterm> <primary>BIT_COUNT()</primary> </indexterm> @@ -12946,7 +12946,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_charset"> <indexterm> <primary>CHARSET()</primary> </indexterm> @@ -12981,7 +12981,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_coercibility"> <indexterm> <primary>COERCIBILITY()</primary> </indexterm> @@ -13109,7 +13109,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_collation"> <indexterm> <primary>COLLATION()</primary> </indexterm> @@ -13142,7 +13142,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_connection_id"> <indexterm> <primary>CONNECTION_ID()</primary> </indexterm> @@ -13175,7 +13175,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_current_user"> <indexterm> <primary>CURRENT_USER()</primary> </indexterm> @@ -13235,7 +13235,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_database"> <indexterm> <primary>DATABASE()</primary> </indexterm> @@ -13272,7 +13272,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_found_rows"> <indexterm> <primary>FOUND_ROWS()</primary> </indexterm> @@ -13417,7 +13417,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_last_insert_id"> <indexterm> <primary>LAST_INSERT_ID([<replaceable>expr</replaceable>])</primary> </indexterm> @@ -13697,7 +13697,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_row_count"> <indexterm> <primary>ROW_COUNT()</primary> </indexterm> @@ -13756,7 +13756,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_schema"> <indexterm> <primary>SCHEMA()</primary> </indexterm> @@ -13781,7 +13781,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_session_user"> <indexterm> <primary>SESSION_USER()</primary> </indexterm> @@ -13806,7 +13806,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_system_user"> <indexterm> <primary>SYSTEM_USER()</primary> </indexterm> @@ -13831,7 +13831,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_user"> <indexterm> <primary>USER()</primary> </indexterm> @@ -13879,7 +13879,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_version"> <indexterm> <primary>VERSION()</primary> </indexterm> @@ -13937,7 +13937,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_default"> <indexterm> <primary>DEFAULT()</primary> </indexterm> @@ -13988,7 +13988,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_get_lock"> <indexterm> <primary>timeout</primary> </indexterm> @@ -14080,7 +14080,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_inet_aton"> <indexterm> <primary>INET_ATON()</primary> </indexterm> @@ -14142,7 +14142,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_inet_ntoa"> <indexterm> <primary>INET_NTOA()</primary> </indexterm> @@ -14174,7 +14174,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_is_free_lock"> <indexterm> <primary>IS_FREE_LOCK()</primary> </indexterm> @@ -14203,7 +14203,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_is_used_lock"> <indexterm> <primary>IS_USED_LOCK()</primary> </indexterm> @@ -14230,7 +14230,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_master_pos_wait"> <indexterm> <primary>MASTER_POS_WAIT()</primary> </indexterm> @@ -14276,7 +14276,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_name_const"> <indexterm> <primary>NAME_CONST()</primary> </indexterm> @@ -14321,7 +14321,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_release_lock"> <indexterm> <primary>RELEASE_LOCK()</primary> </indexterm> @@ -14359,7 +14359,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sleep"> <indexterm> <primary>SLEEP()</primary> </indexterm> @@ -14387,7 +14387,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_uuid"> <indexterm> <primary>UUID()</primary> </indexterm> @@ -14481,7 +14481,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_values"> <indexterm> <primary>VALUES()</primary> </indexterm> @@ -14596,7 +14596,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_avg"> <indexterm> <primary>AVG()</primary> </indexterm> @@ -14647,7 +14647,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_and"> <indexterm> <primary>BIT_AND()</primary> </indexterm> @@ -14680,7 +14680,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_or"> <indexterm> <primary>BIT_OR()</primary> </indexterm> @@ -14711,7 +14711,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_bit_xor"> <indexterm> <primary>BIT_XOR()</primary> </indexterm> @@ -14742,7 +14742,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_count"> <indexterm> <primary>COUNT()</primary> </indexterm> @@ -14814,7 +14814,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_count_distinct"> <indexterm> <primary>COUNT(DISTINCT)</primary> </indexterm> @@ -14868,7 +14868,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_group_concat"> <indexterm> <primary>GROUP_CONCAT()</primary> </indexterm> @@ -14997,7 +14997,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_min"> <indexterm> <primary>MIN()</primary> </indexterm> @@ -15081,7 +15081,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_std"> <indexterm> <primary>STD()</primary> </indexterm> @@ -15129,7 +15129,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_stddev_pop"> <indexterm> <primary>STDDEV_POP()</primary> </indexterm> @@ -15163,7 +15163,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_stddev_samp"> <indexterm> <primary>STDDEV_SAMP()</primary> </indexterm> @@ -15199,7 +15199,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_sum"> <indexterm> <primary>SUM()</primary> </indexterm> @@ -15242,7 +15242,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_var_pop"> <indexterm> <primary>VAR_POP()</primary> </indexterm> @@ -15277,7 +15277,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_var_samp"> <indexterm> <primary>VAR_SAMP()</primary> </indexterm> @@ -15309,7 +15309,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_variance"> <indexterm> <primary>VARIANCE()</primary> </indexterm> Modified: trunk/refman-5.1/functions.xml =================================================================== --- trunk/refman-5.1/functions.xml 2007-01-12 18:12:45 UTC (rev 4477) +++ trunk/refman-5.1/functions.xml 2007-01-12 18:17:26 UTC (rev 4478) Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 656 bytes @@ -4770,7 +4770,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_mod2"> <indexterm> <primary>%</primary> </indexterm> @@ -7073,7 +7073,7 @@ <remark role="help-syntax-begin"/> - <para> + <para id="function_date_sub"> <indexterm> <primary>DATE_SUB()</primary> </indexterm>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r4478 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 12 Jan |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 1.334 sec. using MySQL 5.1.14-beta-log