sql tag

625 questions

1 answers
33 views
0

NULL entries are included when using the SQL aggregation function.

INSERT INTO customers (customer_id, customer_name, age, ranking, job, savings)VALUES ('apple', 'Hong Gil-dong', 20, 'gold', 'student', 1000), ('banana', 'Kim Cheol-soo', 25, 'vip', 'Nurse', 2500), (...

sql

2 years ago

1 answers
87 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
39 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
40 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
99 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
56 views
0

How do I not save values in db where the primary_key setting and primary_key overlap in sql database? (Android) (Beginner)

While using sql statements and inserting data into the database as insert statements, it is difficult to implement a way to move over data that overlaps the key without storing it in the database. How...

android sql database

2 years ago

1 answers
42 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
48 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

- 50 -

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