|
Alzabo::SQLMaker::MySQL - Alzabo SQL making class for MySQL |
Alzabo::SQLMaker::MySQL - Alzabo SQL making class for MySQL
use Alzabo::SQLMaker;
my $sql = Alzabo::SQLMaker->new( sql => 'MySQL' );
MySQL-specific SQL creation. It is worth noting that MySQL does not
allow subselects. Any attempt to use a subselect (by passing an
Alzabo::SQMaker object in as parameter to a method) will result in
an Alzabo::Exception::SQL error.
Almost all of the functionality inherited from Alzabo::SQLMaker is
used as is. The only overridden methods are limit and
get_limit, as MySQL does allow for a LIMIT clause in its SQL.
SQL may be imported by name or by tags. They take arguments as documented in the MySQL documentation (version 3.23.39). The functions (organized by tag) are:
PI RAND MOD ROUND POW POWER ATAN2 ABS SIGN FLOOR CEILING EXP LOG LOG10 SQRT COS SIN TAN ACOS ASIN ATAN COT DEGREES RADIANS TRUNCATE
CHAR POSITION INSTR LEFT RIGHT FIND_IN_SET REPEAT LEAST GREATEST CONCAT ELT FIELD MAKE_SET LOCATE SUBSTRING CONV LPAD RPAD MID SUBSTRING_INDEX REPLACE CONCAT_WS EXPORT_SET INSERT ASCII ORD BIN OCT HEX LENGTH OCTET_LENGTH CHAR_LENGTH CHARACTER_LENGTH TRIM LTRIM RTRIM SOUNDEX SPACE REVERSE LCASE LOWER UCASE UPPER
CURDATE CURRENT_DATE CURTIME CURRENT_TIME NOW SYSDATE CURRENT_TIMESTAMP UNIX_TIMESTAMP WEEK PERIOD_ADD PERIOD_DIFF DATE_ADD DATE_SUB ADDDATE SUBDATE DATE_FORMAT TIME_FORMAT FROM_UNIXTIME DAYOFWEEK WEEKDAY DAYOFYEAR MONTH DAYNAME MONTHNAME QUARTER YEARWEEK HOUR MINUTE SECOND TO_DAYS FROM_DAYS SEC_TO_TIME TIME_TO_SEC
These are functions which operate on an aggregate set of values all at once.
COUNT AVG MIN MAX SUM STD STDDEV DISTINCT
These are functions which return information about the MySQL server.
DATABASE USER SYSTEM_USER SESSION_USER VERSION CONNECTION_ID LAST_INSERT_ID GET_LOCK RELEASE_LOCK BENCHMARK MASTER_POS_WAIT
These are functions which don't fit into any other categories.
ENCRYPT ENCODE DECODE FORMAT INET_NTOA INET_ATON BIT_OR BIT_AND PASSWORD MD5 LOAD_FILE
These are functions from other groups that are most commonly used.
NOW COUNT AVG MIN MAX SUM DISTINCT
Dave Rolsky, <dave@urth.org>
|
Alzabo::SQLMaker::MySQL - Alzabo SQL making class for MySQL |