View source for JDatabaseImporterMySQL

=={{JVer|11.1}} JDatabaseImporterMySQL==
===Description===


===Methods===
{| class="wikitable sortable"
|-
!Visibility
!Method name
!Description
|-
|public 
|[[API17:JDatabaseImporterMySQL::__construct|__construct]]
|Constructor. 
|-
|public 
|[[API17:JDatabaseImporterMySQL::asXml|asXml]]
|Set the output option for the exporter to XML format. 
|-
|public 
|[[API17:JDatabaseImporterMySQL::check|check]]
|Checks if all data and options are in order prior to exporting. 
|-
|public 
|[[API17:JDatabaseImporterMySQL::from|from]]
|Specifies the data source to import. 
|-
|public 
|[[API17:JDatabaseImporterMySQL::setDbo|setDbo]]
|Sets the database connector to use for exporting structure and/or data from MySQL. 
|-
|public 
|[[API17:JDatabaseImporterMySQL::withStructure|withStructure]]
|Sets an internal option to merge the structure based on the input data. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getAddColumnSQL|getAddColumnSQL]]
|Get the SQL syntax to add a column. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getAddKeySQL|getAddKeySQL]]
|Get the SQL syntax to add a key. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getAlterTableSQL|getAlterTableSQL]]
|Get alters for table if there is a difference. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getChangeColumnSQL|getChangeColumnSQL]]
|Get the syntax to alter a column. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getColumns|getColumns]]
|Get the details list of columns for a table. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getColumnSQL|getColumnSQL]]
|Get the SQL syntax for a single column that would be included in a table create or alter statement. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getDropColumnSQL|getDropColumnSQL]]
|Get the SQL syntax to drop a column. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getDropKeySQL|getDropKeySQL]]
|Get the SQL syntax to drop a key. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getDropPrimaryKeySQL|getDropPrimaryKeySQL]]
|Get the SQL syntax to drop a key. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getKeyLookup|getKeyLookup]]
|Get the details list of keys for a table. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getKeys|getKeys]]
|Get the details list of keys for a table. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getKeySQL|getKeySQL]]
|Get the SQL syntax for a key. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::getRealTableName|getRealTableName]]
|Get the real name of the table, converting the prefix wildcard string if present. 
|-
|protected 
|[[API17:JDatabaseImporterMySQL::mergeStructure|mergeStructure]]
|Merges the incoming structure definition with the existing structure. 
|-
|}
* '''Defined in''' libraries/joomla/database/database/mysqlimporter.php
===Importing===
<source lang="php">jimport( 'joomla.database.database.mysqlimporter' );</source>
===See also===
* {{JVer|11.1}} '''JDatabaseImporterMySQL source code''' on [[jplatform:database/database/mysqlimporter.php|BitBucket]]
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
* [[API17:JDatabaseImporterMySQL|Other versions of JDatabaseImporterMySQL]]


===User contributed notes===
=== Code Examples ===
<dpl>
noresultsheader=\n
category=JDatabaseImporterMySQL
namespace=CodeExample
category=ClassExample
include=*
namespace=CodeExample
format= ,,,
</dpl>
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>