BenXk
BenXk
PostsComments
DTDrizzle Team
Created by BenXk on 1/12/2024 in #help
How to link data from two tables
I would like twoTab to have the value of one and two filled with the values from oneTab but under a category key
8 replies
DTDrizzle Team
Created by BenXk on 1/12/2024 in #help
How to link data from two tables
And 
export const oneTab = mysqlTable("one_tab", {
  one: varchar("one", { length: 10 }).default("").notNull(),
  two: varchar("two", { length: 10 }).default("").notNull(),
  tab: char("tab", { length: 3 }).default("two").notNull(),
export const oneTab = mysqlTable("one_tab", {
  one: varchar("one", { length: 10 }).default("").notNull(),
  two: varchar("two", { length: 10 }).default("").notNull(),
  tab: char("tab", { length: 3 }).default("two").notNull(),
8 replies
DTDrizzle Team
Created by BenXk on 1/12/2024 in #help
How to link data from two tables
export const twoTab = mysqlTable("two_tab", {
  seq: int("seq").default(0).notNull(),
  seq2: int("seq2").default(0).notNull(),
  one: char("one", { length: 3 }).default("").notNull(),
  two: char("two", { length: 3 }).default("").notNull(),
  id: int("id").autoincrement().notNull(),
export const twoTab = mysqlTable("two_tab", {
  seq: int("seq").default(0).notNull(),
  seq2: int("seq2").default(0).notNull(),
  one: char("one", { length: 3 }).default("").notNull(),
  two: char("two", { length: 3 }).default("").notNull(),
  id: int("id").autoincrement().notNull(),
8 replies
DTDrizzle Team
Created by BenXk on 1/12/2024 in #help
How to link data from two tables
Thanks, I have two tables
8 replies