← Back

MySQL ↔ SQLite Conversion

Bidirectional conversion between MySQL and SQLite CREATE TABLE, INSERT, etc., processed locally
Input
Output

Processed locally, data is not uploaded to server

Data Type Mapping Reference

MySQLSQLiteDescription
INT / TINYINT / SMALLINT / MEDIUMINT / BIGINTINTEGERAll integers mapped to INTEGER
VARCHAR(n) / CHAR(n) / TINYTEXT / MEDIUMTEXT / LONGTEXTTEXTAll text mapped to TEXT
FLOAT / DOUBLE / DECIMAL(m,n)REALAll floats mapped to REAL
DATETIME / TIMESTAMP / DATE / TIMETEXTSQLite stores dates as TEXT
BLOB / TINYBLOB / MEDIUMBLOB / LONGBLOBBLOBBinary types unchanged
ENUM('a','b')TEXTSQLite does not support ENUM
BOOLEAN / BOOLINTEGERSQLite uses 0/1
JSONTEXTSQLite stores JSON as TEXT
AUTO_INCREMENTAUTOINCREMENTAuto-increment keywords differ