{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21787,"path":"integrate-applications/mysql-zcc.md","title":"MySQL","bundle":null,"doc_type":null,"release":"australia","body":"\n# MySQL\n\nThe MySQL connector enables access to relational database data from your MySQL instance without moving or copying data.\n\nConnection admins set up connections to MySQL in the Zero Copy Connector Hub and grant data stewards access. Data stewards use the connection to create data fabric tables and map data from MySQL. Users can then access MySQL data through the table list view or GlideRecord scripts. For details, see [Managing data fabric tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/managing-data-fabric-tables-zcc.md).\n\n**Important:** The MySQL primary connector is in preview. A primary connector in preview is developed and supported by ServiceNow, but is still being enhanced to include all planned functionality. While in preview, a connector may have limitations in platform support or available features.\n\nA primary connector in preview is fully functional for its documented scope and receives the same ServiceNow support as other primary connectors. For details on specific functionality limitations, see [Primary Connectors Limitations \\(KBB0010487\\)](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KBB0010487).\n\nThe connector supports pushdown for the following Glide queries and list view operations, allowing most queries to execute at the data source:\n\n-   Sort\n-   Limit\n-   Offset\n-   Filter\n-   GroupBy\n-   avg\\(\\)\n-   count\\(\\)\n-   max\\(\\)\n-   min\\(\\)\n-   sum\\(\\)\n-   References\n\n## Supported data types\n\nThe following table lists supported MySQL data types and the default matching data types in a data fabric table.\n\n|MySQL|Data fabric table|\n|-----|-----------------|\n|tinyint unsigned|Integer|\n|smallint unsigned|Integer|\n|int unsigned|Long|\n|bigint unsigned|Decimal|\n|json|Not supported|\n|enum|String|\n|datetime|Basic Date/Time|\n|bit\\(1\\)|True/False|\n|tinyint|Long|\n|smallint|Integer|\n|int/integer|Integer|\n|bigint|Long|\n|float \\(Real\\)|Floating Point Number|\n|DOUBLE|Floating Point Number|\n|decimal/numeric|Decimal|\n|char\\(n\\)|Char \\(fixed-length character field\\)|\n|varchar/nvarchar/longvarchar/longvarchar|String \\(variable-length character field\\)|\n|date|Date|\n|time|Basic Time|\n|timestamp|Date/Time|\n|binary/varbinary/longvarbinary|Varbinary|\n\nMySQL data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.\n\n**Related topics**  \n\n\n[Create a MySQL connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-mysql-connection-zcc.md)\n\n"}}