Documentation

SQL extends AbstractSQL
in package

MySQL specific SQL

Table of Contents

columnList()  : string
SQL to show information about columns in a table
dbList()  : string
Returns sql to list other databases
explain()  : string
Get the query plan for the sql query
fkList()  : string
Get the list of foreign keys for the current table
functionList()  : string
Return sql to list functions
indexList()  : string
Get the list of indexes for the current table
limit()  : string
Limit clause
procedureList()  : string
Return sql to list stored procedures
random()  : string
Random ordering keyword
sequenceList()  : string|null
Return sql to list sequences
systemTableList()  : string
Overridden in MySQL class
tableList()  : string
Returns sql to list tables
triggerList()  : string
Returns sql to list triggers
typeList()  : string
SQL to show list of field types
viewList()  : string
Returns sql to list views

Methods

columnList()

SQL to show information about columns in a table

public columnList(string $table) : string
Parameters
$table : string
Return values
string

dbList()

Returns sql to list other databases

public dbList() : string
Return values
string

explain()

Get the query plan for the sql query

public explain(string $sql) : string
Parameters
$sql : string
Return values
string

fkList()

Get the list of foreign keys for the current table

public fkList(string $table) : string
Parameters
$table : string
Return values
string

functionList()

Return sql to list functions

public functionList() : string
Return values
string

indexList()

Get the list of indexes for the current table

public indexList(string $table) : string
Parameters
$table : string
Return values
string

limit()

Limit clause

public limit(string $sql, int $limit[, int|null $offset = NULL ]) : string
Parameters
$sql : string
$limit : int
$offset : int|null = NULL
Return values
string

procedureList()

Return sql to list stored procedures

public procedureList() : string
Return values
string

random()

Random ordering keyword

public random() : string
Return values
string

sequenceList()

Return sql to list sequences

public sequenceList() : string|null
Return values
string|null

systemTableList()

Overridden in MySQL class

public systemTableList() : string
Return values
string

tableList()

Returns sql to list tables

public tableList([string $database = '' ]) : string
Parameters
$database : string = ''
Return values
string

triggerList()

Returns sql to list triggers

public triggerList() : string
Return values
string

typeList()

SQL to show list of field types

public typeList() : string
Return values
string

viewList()

Returns sql to list views

public viewList() : string
Return values
string

        

Search results