409 questions
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...
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,...
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...
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...
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...
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...
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...
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...
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...
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 ...
| « | - 33 - | » |
© 2024 OneMinuteCode. All rights reserved.