Followers count

I want to put the number of followers and likes, can I use the Count() honestly?

6 Replies

Hello, @melodyclue! count() us used to count rows. Followers and likes are columns?

@solo I also want information about people I follow and like, so I store it in the JUNCTION TABLE. So by counting the number of records in the condition, that is the number of followers and likes

Mykhailo•14mo ago

Could you please show me your schema?

melodyclueOP•14mo ago

I don't have full table but like this...

export const followers = mysqlTable("followers", {
    userId: varchar("user_id", { length: 255 }).notNull(),
    followerId: varchar("follower_id", { length: 255 }).notNull(),
})

export const followers = mysqlTable("followers", {
    userId: varchar("user_id", { length: 255 }).notNull(),
    followerId: varchar("follower_id", { length: 255 }).notNull(),
})

Mykhailo•14mo ago

what do you want to achieve with the query?

melodyclueOP•14mo ago

i want users I followed

Gaming

Programming

Followers count

Did you find this page helpful?