7 questions
Developing node.js. I have two years of experience in mssql.Initially, the db part was developed using the mysql module.But I found out that it's called Sequelize.js, so I've been using it.It was a li...
Hello.This is a question about the sort query. Queries three tables of many-to-many relationships. If you query as below:const data = await product.findOne({ where: { product_id: id }, include: [ { ...
First of all, the data and table are as follows.CREATE TABLE products( p_id INT, p_name VARCHAR(32), PRIMARY KEY (p_id));CREATE TABLE color( p_id INT, p_color VARCHAR(24));CREATE TABLE size( p_id INT,...
When a member enters my page, he or she wants to print out only what he or she wrote. I'm currently printing all the writings that other members wrote. Only the user's nickname is properly brought.I d...
A query is a self-joined sentence with one table as follows:SELECT cat.cat_id, cat.cat_name, sub_cat.cat_id, sub_cat.cat_nameFROM Categories AS catLEFT JOIN Categories AS sub_catON sub_cat.parent = ca...
The work environment is NodeJS v8, KoaJS, SequelizeJS (MySQL). First of all, I wrote the code like first. .getUserByUserId() is a method for checking ID duplication. If you already have duplicate IDs,...
When node.js connects to MySQL server using Sequelize, it seems that the port is basically connected to 3306, is there a way to change this port?
© 2024 OneMinuteCode. All rights reserved.