Back to Drizzle Orm

CreateTable

src/mdx/get-started/mysql/CreateTable.mdx

latest412 B
Original Source

Create a schema.ts file in the src/db directory and declare your table:

typescript
import { int, mysqlTable, serial, varchar } from 'drizzle-orm/mysql-core';

export const usersTable = mysqlTable('users_table', {
  id: serial().primaryKey(),
  name: varchar({ length: 255 }).notNull(),
  age: int().notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});