Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Alzabo::SQLMaker::MySQUser Contributed Perl DocumentAlzabo::SQLMaker::MySQL(3)

NAME
       Alzabo::SQLMaker::MySQL - Alzabo	SQL making class for MySQL

SYNOPSIS
	 use Alzabo::SQLMaker;

	 my $sql = Alzabo::SQLMaker->new( sql => 'MySQL' );

DESCRIPTION
       This class implementes MySQL-specific SQL creation.  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.

METHODS
       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.

EXPORTED SQL FUNCTIONS
       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:

   :math
	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

   :string
	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

   :datetime
	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
	YEAR
	YEARWEEK
	HOUR
	MINUTE
	SECOND
	TO_DAYS
	FROM_DAYS
	SEC_TO_TIME
	TIME_TO_SEC

   :aggregate
       These are functions which operate on an aggregate set of	values all at
       once.

	COUNT
	AVG
	MIN
	MAX
	SUM
	STD
	STDDEV

   :system
       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

   :control
       These are flow control functions:

	IFNULL
	NULLIF
	IF

   :misc
       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

   :fulltext
       These are functions related to MySQL's fulltext searching capabilities.

	MATCH
	AGAINST
	IN_BOOLEAN_MODE

       NOTE: In	MySQL 4.0 and greater, it is possible to say that a search is
       in boolean mode in order	to change how MySQL handles the	argument given
       to AGAINST.  This will not work with earlier versions.

   :common
       These are functions from	other groups that are most commonly used.

	NOW
	COUNT
	AVG
	MIN
	MAX
	SUM
	DISTINCT

AUTHOR
       Dave Rolsky, <dave@urth.org>

perl v5.32.0			  2020-08-08	    Alzabo::SQLMaker::MySQL(3)

NAME | SYNOPSIS | DESCRIPTION | METHODS | EXPORTED SQL FUNCTIONS | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Alzabo::SQLMaker::MySQL&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help