User:Elaeagnifolia/Sandbox
From Another Eden Wiki
Cargo SQL Functions Added (Refer to MySQL Documentation for usage)
- 'ABS',
- 'CAST',
- 'CONCAT_WS',
- 'CURDATE', // different from NOW() (CURTIME)
- 'DAY',
- 'DAYNAME',
- 'DAYOFWEEK',
- 'DAYOFYEAR',
- 'FIELD',
- 'FIND_IN_SET',
- 'FROM_DAYS',
- 'FROM_UNIXTIME',
- 'GREATEST',
- 'GROUP_CONCAT',
- 'HOUR',
- 'IFNULL',
- 'IN',
- 'INSERT',
- 'LAST_DAY',
- 'LEAST',
- 'LEFT',
- 'LENGTH',
- 'LPAD',
- 'MAKEDATE',
- 'MAKETIME',
- 'MINUTE',
- 'MOD',
- 'NULLIF',
- 'OVER',
- 'PERCENT_RANK',
- 'QUARTER',
- 'RAND',
- 'REGEXP',
- 'REGEXP_LIKE', // same as REGEXP, but in function form.
- 'REGEXP_INSTR',
- 'REGEXP_REPLACE',
- 'REGEXP_SUBSTR',
- 'REPEAT',
- 'REPLACE',
- 'REVERSE',
- 'RIGHT',
- 'RPAD',
- 'SEC_TO_TIME',
- 'SECOND',
- 'SIGN',
- 'SQRT',
- 'STR_TO_DATE',
- 'SUBSTRING_INDEX',
- 'SUBTIME',
- 'TIME',
- 'TIMEDIFF',
- 'TIMESTAMP',
- 'TIMESTAMPADD',
- 'TIMESTAMPDIFF',
- 'TO_DAYS',
- 'TO_SECONDS',
- 'TRUNCATE',
- 'UTC_DATE',
- 'UTC_TIME',
- 'UTC_TIMESTAMP',
- 'WEEK',
- 'WEEKDAY', // Similar to DAYOFWEEK, but starts on Monday instead of Sunday.
- 'YEARWEEK',
List of functions that had issues:
- EXTRACT() - Formatted as EXTRACT(YEAR FROM NOW()), but FROM is not an allowed keyword in Cargo.
- FOUND_ROWS() - Use COUNT() and a high limit instead.
- GROUPING()/ROLLUP - No way to specify WITH ROLLUP, so GROUPING() doesn't have a point.
- SPACE() - Slightly pointless since MediaWiki just cuts out the extra spaces when formatting anyway.