Sample Conversion: MySQL DDL → Drizzle mysqlTable
Input (MySQL DDL)
CREATE TABLE tags (
id INT AUTO_INCREMENT PRIMARY KEY,
slug VARCHAR(50) UNIQUE NOT NULL
); Output (Drizzle mysqlTable)
import { mysqlTable, int, varchar } from "drizzle-orm/mysql-core";
export const tags = mysqlTable("tags", {
id: int("id").autoincrement().primaryKey(),
slug: varchar("slug", { length: 50 }).notNull().unique(),
}); Frequently Asked Questions
Does Drizzle have separate imports for MySQL?
Yes, MySQL schema builders are imported from drizzle-orm/mysql-core.