class_docstr: This handler handles connection and execution of the MySQL statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","MySQL","statements","."]
docstr: Get a list with all of the tabels in MySQL selected database
docstr_tok: ["Get","a","list","with","all","of","the","tabels","in","MySQL","selected","database"]
code: def get_tables(self) -> Response:
      """
      Get a list with all of the tabels in MySQL selected database
      """
      sql = """
              SELECT
                  TABLE_SCHEMA AS table_schema,
                  TABLE_NAME AS table_name,
                  TABLE_TYPE AS table_type
              FROM
                  information_schema.TABLES
              WHERE
                  TABLE_TYPE IN ('BASE TABLE', 'VIEW') 
                  AND TABLE_SCHEMA = DATABASE()
              ORDER BY 2
              ;
          """
      result = self.native_query(sql)
      return result
  
imports: from collections import OrderedDict
  import pandas
  import mysql.connector
  from urllib.parse import urlparse
  from sqlalchemy import create_engine
  from mindsdb_sql import parse_sql
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.utilities import log
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
label_desc: Use image node_id 9 for calling the MySQLHandler obj's underlying member method code with example usage: obj.get_tables() and returns: result