import { sql } from "drizzle-orm";
import {
mysqlTable,
varchar,
} from "drizzle-orm/mysql-core";
const users = mysqlTable("users", {
id: varchar("id", { length: 255 }).notNull().primaryKey(),
name: varchar("name", { length: 255 })
});
export const getUsers = async () => {
const result = await db.select({
field1: users.id,
field2: users.name,
}).from(users);
const { field1, field2 } = result[0];
return result;
}
import { sql } from "drizzle-orm";
import {
mysqlTable,
varchar,
} from "drizzle-orm/mysql-core";
const users = mysqlTable("users", {
id: varchar("id", { length: 255 }).notNull().primaryKey(),
name: varchar("name", { length: 255 })
});
export const getUsers = async () => {
const result = await db.select({
field1: users.id,
field2: users.name,
}).from(users);
const { field1, field2 } = result[0];
return result;
}