フォーマッター＆コード
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.
他の人はこちらも検索しています
関連ツール