mysql tag

409 questions

1 answers
86 views
0

Error setting MySQL Foreign key.

There are two tables.If the parent table has two pk, the creation of the child table fails.Is there a way? For no in the parent table, this is a formal sequence value. Do I have to abandon the sequenc...

mysql foreign-keys

2 years ago

1 answers
115 views
0

ORM: Sequelize: I want to change mySQL query to Sequelize query.

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,...

sequelize.js mysql sql node.js

2 years ago

1 answers
38 views
0

If conditions are given to the JOIN table, the conditions are given accordingly. Regardless of the conditions, if you want to select anything that matches PK

For example, table subjects that have a users table and a user's PK.SELECT u.id, GROUP_CONCAT(DISTINCT sbj.number)FROM users uJOIN subjects sbjON sbj.userId = u.id AND sbj.number IN (1)WHERE u.isDelet...

mysql

2 years ago

1 answers
150 views
0

Node.js How do I get a logged-in user post?

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...

node.js sequelize.js ejs mysql

2 years ago

2 answers
39 views
0

I'm studying web development and I have a question about images.

I'm studying web development with the goal of a shopping mall When I use the image (sales product) that I'm going to use on the web page, I set the path, right?I simply set the path with the image sto...

php html mysql

2 years ago

2 answers
98 views
0

Query to get daily visitor count as login history (MySQL)

There is a table that takes the user ID (INT) and login time (Timestamp) as columns, and INSERTs the record once every time the user logs in.I'd like to get the number of duplicate daily visitors from...

mysql querying sql database

2 years ago

1 answers
41 views
0

Is there a function like contents in mysql syntax?

I'm implementing an alarm window. Implement Table A as an alarm history table.I implemented table B as a history exclusion table If [Remove all alarms], except for the history existing in table B, I w...

mysql

2 years ago

2 answers
45 views
0

To obtain the minimum value for each Myql MyQuery group?

Hi, everyone. I'm trying to get the minimum value for each group, but I don't know well, so I'm uploading it here.----------------- Name 번호 Number 날짜 Date───────────────────────── Test 1 1 1 201...

php mysql

2 years ago

1 answers
118 views
0

Python 3 MySQL connection failed

import pymysqlimport MySQLdb'''db = MySQLdb.connect(host=13.209.68.158, # your host, usually localhost user=Woo, # your username passwd=cbnuroot123, # your password db=CBNU) # name of the d...

python-3.x mysql aws

2 years ago

2 answers
118 views
0

How MySQL conditions the select result value of another table and queries

Here's what I want to do.Example A)select col_name from table_a where col_name like '%val%';Result A)val1val2val3Example B)select col, count(col) from table_bwhere color '%result A value 1%' OR color ...

mysql querying

2 years ago

- 33 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656