151 lines
8.7 KiB
HTML
151 lines
8.7 KiB
HTML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<!DOCTYPE html SYSTEM "about:legacy-compat">
|
||
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
|
||
<head>
|
||
<title>phpDox - Query\Drivers\Mysql\SQL</title>
|
||
<link rel="stylesheet" type="text/css" href="../css/style.css" media="screen"/>
|
||
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
|
||
</head>
|
||
<body>
|
||
<nav class="topnav">
|
||
<ul>
|
||
<li>
|
||
<div class="logo"><span>/**</span>phpDox</div>
|
||
</li>
|
||
<li class="separator">
|
||
<a href="../index.html">Overview</a>
|
||
</li>
|
||
<li class="separator">
|
||
<a href="../namespaces.html">Namespaces</a>
|
||
</li>
|
||
<li>
|
||
<a href="../interfaces.html">Interfaces</a>
|
||
</li>
|
||
<li>
|
||
<a href="../classes.html">Classes</a>
|
||
</li>
|
||
<li class="separator">
|
||
<a href="../source/index.html">Source</a>
|
||
</li>
|
||
</ul>
|
||
</nav>
|
||
<div id="mainstage">
|
||
<div class="box">
|
||
<ul class="breadcrumb">
|
||
<li>
|
||
<a href="../index.html">Overview</a>
|
||
</li>
|
||
<li class="separator">
|
||
<a href="../classes.html">Classes</a>
|
||
</li>
|
||
<li class="separator">
|
||
<a href="../classes.html#Query_Drivers_Mysql">Query\Drivers\Mysql</a>
|
||
</li>
|
||
<li class="separator">SQL</li>
|
||
</ul>
|
||
</div>
|
||
<nav class="box">
|
||
<ul>
|
||
<li>
|
||
<a href="#introduction">Introduction</a>
|
||
</li>
|
||
<li>
|
||
<a href="#synopsis">Synopsis</a>
|
||
</li>
|
||
<li>
|
||
<a href="#hierarchy">Hierarchy</a>
|
||
</li>
|
||
<li>
|
||
<a href="#methods">Methods</a>
|
||
</li>
|
||
<li>
|
||
<a href="../source/Drivers/Mysql/SQL.php.html#line23">Source</a>
|
||
</li>
|
||
</ul>
|
||
</nav>
|
||
<section>
|
||
<h1 id="introduction"><small>Query\Drivers\Mysql\</small>SQL</h1>
|
||
<h4>MySQL specific SQL</h4>
|
||
<p/>
|
||
<ul/>
|
||
<h2 id="synopsis">Synopsis</h2>
|
||
<div class="synopsis">class SQL
|
||
extends <a title="Query\Drivers\AbstractSQL" href="../classes/Query_Drivers_AbstractSQL.html">AbstractSQL</a>
|
||
{<br/><ul class="none"><li>// methods</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/limit.html">limit</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/explain.html">explain</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/random.html">random</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/dbList.html">dbList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/tableList.html">tableList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/systemTableList.html">systemTableList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/viewList.html">viewList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/triggerList.html">triggerList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/functionList.html">functionList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/procedureList.html">procedureList</a>()
|
||
</li><li>public ?string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/sequenceList.html">sequenceList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/typeList.html">typeList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/columnList.html">columnList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/fkList.html">fkList</a>()
|
||
</li><li>public string <a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/indexList.html">indexList</a>()
|
||
</li></ul><ul class="none"><li>// Inherited methods from <span title="Query\Drivers\AbstractSQL">AbstractSQL</span></li><li>public string <a title="Query\Drivers\AbstractSQL" href="../classes/Query_Drivers_AbstractSQL/limit.html">limit</a>()
|
||
</li></ul>
|
||
|
||
}<br/></div>
|
||
<h2 id="hierarchy">Hierarchy</h2>
|
||
<div class="styled">
|
||
<h4>Extends</h4>
|
||
<ul>
|
||
<li>
|
||
<a title="Query\Drivers\AbstractSQL" href="../classes/Query_Drivers_AbstractSQL.html">Query\Drivers\AbstractSQL</a>
|
||
</li>
|
||
</ul>
|
||
</div>
|
||
<h2 id="methods">Methods</h2>
|
||
<div class="styled">
|
||
<h4>public</h4>
|
||
<ul>
|
||
<li id="columnList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/columnList.html">columnList()</a>
|
||
— SQL to show information about columns in a table</li>
|
||
<li id="dbList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/dbList.html">dbList()</a>
|
||
— Returns sql to list other databases</li>
|
||
<li id="explain"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/explain.html">explain()</a>
|
||
— Get the query plan for the sql query</li>
|
||
<li id="fkList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/fkList.html">fkList()</a>
|
||
— Get the list of foreign keys for the current table</li>
|
||
<li id="functionList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/functionList.html">functionList()</a>
|
||
— Return sql to list functions</li>
|
||
<li id="indexList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/indexList.html">indexList()</a>
|
||
— Get the list of indexes for the current table</li>
|
||
<li id="limit"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/limit.html">limit()</a>
|
||
— Limit clause</li>
|
||
<li id="procedureList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/procedureList.html">procedureList()</a>
|
||
— Return sql to list stored procedures</li>
|
||
<li id="random"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/random.html">random()</a>
|
||
— Random ordering keyword</li>
|
||
<li id="sequenceList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/sequenceList.html">sequenceList()</a>
|
||
— Return sql to list sequences</li>
|
||
<li id="systemTableList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/systemTableList.html">systemTableList()</a>
|
||
— Overridden in MySQL class</li>
|
||
<li id="tableList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/tableList.html">tableList()</a>
|
||
— Returns sql to list tables</li>
|
||
<li id="triggerList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/triggerList.html">triggerList()</a>
|
||
— Returns sql to list triggers</li>
|
||
<li id="typeList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/typeList.html">typeList()</a>
|
||
— SQL to show list of field types</li>
|
||
<li id="viewList"><a title="Query\Drivers\Mysql\SQL" href="../classes/Query_Drivers_Mysql_SQL/viewList.html">viewList()</a>
|
||
— Returns sql to list views</li>
|
||
</ul>
|
||
<h3>Inherited from <a title="Query\Drivers\AbstractSQL" href="../classes/Query_Drivers_AbstractSQL.html">Query\Drivers\AbstractSQL</a></h3>
|
||
<h4>public</h4>
|
||
<ul>
|
||
<li id="limit"><a title="Query\Drivers\AbstractSQL" href="../classes/Query_Drivers_AbstractSQL/limit.html">limit()</a>
|
||
— Limit clause</li>
|
||
</ul>
|
||
</div>
|
||
</section>
|
||
</div>
|
||
<footer>
|
||
<span>Generated using phpDox 0.12.0-dev - Copyright (C) 2010 - 2020 by Arne Blankerts and Contributors</span>
|
||
</footer>
|
||
</body>
|
||
</html>
|