Query/apiDocumentation/classes/Query_Drivers_Mysql_SQL.html
2020-04-17 15:05:37 -04:00

151 lines
8.7 KiB
HTML
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?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>