# MySQL components

| [tMysqlBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlbulkexec) | Offers gains in performance while executing the Insert operations on a MySQL or<br>Aurora database. |
| --- | --- |
| [tMysqlClose](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlclose) | Closes the transaction committed in a Mysql database. |
| [tMysqlColumnList](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlcolumnlist) | Iterates on all columns of a given Mysql table and lists column<br>names. |
| [tMysqlCommit](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlcommit) | Commits in one go, using a unique connection, a global transaction instead of doing<br>that on every row or every batch and thus provides gain in performance. |
| [tMysqlConfiguration](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlconfiguration) | Stores connection information and credentials to be reused by other MySQL<br>components. |
| [tMysqlConnection](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlconnection) | Opens a connection to the specified MySQL database for reuse in the subsequent<br>subJob or subJobs. |
| [tMysqlInput](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlinput) | Executes a DB query with a strictly defined order which must correspond to the<br>schema definition. |
| [tMySQLInvalidRows](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlinvalidrows) | Checks MySQL database rows against specific Data Quality patterns (regular<br>expression) or Data Quality rules (business rule). |
| [tMysqlLastInsertId](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqllastinsertid) | Obtains the primary key value of the record that was last inserted in a Mysql table<br>by a user. |
| [tMysqlLookupInput](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqllookupinput) | Reads a MySQL database and extracts fields based on a query. |
| [tMysqlOutput](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqloutput) | Writes, updates, makes changes or suppresses entries in a database. |
| [tMysqlOutputBulk](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqloutputbulk) | Writes a file with columns based on the defined delimiter and the MySQL or Aurora<br>standards. |
| [tMysqlOutputBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqloutputbulkexec) | Executes the Insert action in the specified MySQL or Aurora database. |
| [tMysqlRollback](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlrollback) | Cancels the transaction commit in the connected MySQL database to avoid committing<br>part of a transaction involuntarily. |
| [tMysqlRow](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlrow) | Executes the stated SQL query on the specified MySQL database. |
| [tMysqlSP](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlsp) | Calls a MySQL database stored procedure. |
| [tMysqlTableList](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqltablelist) | Lists the names of a given set of Mysql tables using a select<br>statement based on a Where clause. |
| [tMySQLValidRows](https://help.qlik.com/talend/r/en-US/7.3/components/mysql/tmysqlvalidrows) | Checks MySQL database rows against Data Quality patterns (regular<br>expression). |