[BUG]: Push only works on first push (drizzle with mysql)

[Dadangdut33]

What version of drizzle-orm are you using?

0.30.10

What version of drizzle-kit are you using?

0.21.1

Describe the Bug

I'm using drizzle with mysql, and i'm trying to make development easy by using the push command as stated in the docs

I'm trying to sync my schema with the database using drizzle-kit push but the problem is that it only works when there is no data in the database. I have also tried using drizzle-kit migrate but it also won't work because the table have been created.

So what is wrong here, am i just using drizzle the wrong way or is it a bug? because i was previously using prisma and in there you can sync between the schema and the db using push command.

Also here is the error that i get:

drizzle config:

// env.mjs
import { createEnv } from "@t3-oss/env-nextjs";
import { z } from "zod";
import "dotenv/config";

export const env = createEnv({
  server: {
    NODE_ENV: z
      .enum(["development", "test", "production"])
      .default("development"),
    DATABASE_URL: z.string().min(1),
    DATABASE_NAME: z.string().min(1),
  },
});

// drizzle.config.ts
import { env } from "@/lib/env.mjs";
import { defineConfig } from "drizzle-kit";

export default defineConfig({
  schema: "./src/lib/db/schema",
  dialect: "mysql",
  dbCredentials: {
    url: (env.DATABASE_URL as string) ?? "",
  },
});

Expected behavior

It should sync between the database and the schema without any problem

Environment & setup

development environment i guess

[AndriiSherman]

This should be fixed in drizzle-kit@0.21.3. If the issue persists, feel free to reopen it!