格式化与代码
PostgreSQL → MySQL 转换器
Translate Postgres DDL into MySQL-compatible SQL.
CREATE TABLE users (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
email TEXT UNIQUE,
data JSON,
created_at TIMESTAMP DEFAULT NOW()
);
INSERT INTO users (email) VALUES ('[email protected]')
;Manual review notes
- MySQL TIMESTAMP is UTC; ensure server tz.
- MySQL has no RETURNING; use SELECT LAST_INSERT_ID().
编辑注
Understanding · Two SQLs that look the same — until they don't.
本深度章节目前仅有英文版本。上方的转换工具支持您的语言;长篇说明文章尚未翻译。
常见问题
Quick answers.
›How are PostgreSQL data types handled?
Data types like `TEXT` and `BOOLEAN` are mapped to their MySQL equivalents, such as `LONGTEXT` or `TINYINT(1)`. Specific Postgres types like `UUID` are converted to compatible string formats.
›Does this tool support data migration?
No. This tool is designed specifically for DDL statements (schema definitions) rather than SQL `INSERT` data or binary row migration.
›What happens to Postgres sequences?
Postgres `SERIAL` or `BIGSERIAL` columns are converted to the MySQL `AUTO_INCREMENT` attribute on the primary key. Individual sequence objects are generally omitted as MySQL manages incrementing at the table level.
›Is my schema sent to a server?
No. The translation logic is executed entirely in your browser. Your database structure remains private and is never transmitted over the network.
大家也在搜索
相关工具