1 reply

MariaDB driver and generate migrations

The company im working for insists on using MariaDB but im having issues generating migrations for my mariaDB.
For schemas i am using

'drizzle-orm/mysql-core'

'drizzle-orm/mysql-core'

and i create tables with

mysqlTable()

mysqlTable()

and for generating the migrations im using

drizzle-kit generate:mysql

drizzle-kit generate:mysql

.
In the

drizzle.config.ts

drizzle.config.ts

i set the driver to this

driver: 'mysql2'

driver: 'mysql2'

when i now want to run

drizzle-kit push:mysql

drizzle-kit push:mysql

i get this error message

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'

this is my user.ts schema:

export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  fullName: text('full_name'),
});

export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  fullName: text('full_name'),
});

this is the generated migration:

CREATE TABLE `users` (
    `id` serial AUTO_INCREMENT NOT NULL,
    `full_name` text,
    CONSTRAINT `users_id` PRIMARY KEY(`id`)
);

CREATE TABLE `users` (
    `id` serial AUTO_INCREMENT NOT NULL,
    `full_name` text,
    CONSTRAINT `users_id` PRIMARY KEY(`id`)
);

Am i doing something wrong??

thx for help in advance

MariaDB driver and generate migrations

The company im working for insists on using MariaDB but im having issues generating migrations for my mariaDB.
For schemas i am using

'drizzle-orm/mysql-core'

'drizzle-orm/mysql-core'

and i create tables with

mysqlTable()

mysqlTable()

and for generating the migrations im using

drizzle-kit generate:mysql

drizzle-kit generate:mysql

.
In the

drizzle.config.ts

drizzle.config.ts

i set the driver to this

driver: 'mysql2'

driver: 'mysql2'

when i now want to run

drizzle-kit push:mysql

drizzle-kit push:mysql

i get this error message

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'

this is my user.ts schema:

export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  fullName: text('full_name'),
});

export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  fullName: text('full_name'),
});

this is the generated migration:

CREATE TABLE `users` (
    `id` serial AUTO_INCREMENT NOT NULL,
    `full_name` text,
    CONSTRAINT `users_id` PRIMARY KEY(`id`)
);

CREATE TABLE `users` (
    `id` serial AUTO_INCREMENT NOT NULL,
    `full_name` text,
    CONSTRAINT `users_id` PRIMARY KEY(`id`)
);

Am i doing something wrong??

thx for help in advance

MariaDB driver and generate migrations

Similar Threads

MariaDB driver and generate migrations

Similar Threads

Similar Threads

Similar Threads