409 questions
I'm making my own homepageThe sql that I learn from the state-funded academy is Oracle dbLooking at Cafe24, I thought that only my ql is supported for dbSince I'm using it as a beggar, I can find and ...
create user 'test'@'%' identified with sha256_password by 'password!';I created the user and made it with the password sha256 password.And select user, host, plugin, authentication_string from mysql.u...
Hi, everyone.You want to find data from specific words to initial z.I searched for regular expressions, but I don't know how to do it, so I'm asking you this question.I've looked for these methodssele...
DB : MySQL 5.7TABLE : my_tableDB NAME : testTABLE NAME : my_table id INT table_name VARCHAR(32) PK (table_name)TARGET DB NAME : test2Like the schema information mentioned above,The table my_table in ...
What I want to make is a homepage that stores and prints the name and image in DB when I put it in the homepage.DB StatusKiller dto (You can think of it as a user)killer mapperInput formController I d...
I'm a beginner, so I don't know the exact keyword of the question.table_studenttable_student_infoselect t1.student_id, t1.student_name, t2.email from student as t1 join student_info as t2 on t1.studen...
import sysimport pymysqlfrom PyQt5.QtWidgets import *def connectDB(): host = localhost user = root pw = **** db = world conn = pymysql.connect( host= host, user = user, password = pw, db = db) return(...
There is a document that shows the time by date.I want to convert it to hourly data by date!Help me.I want to write an if sentence, but I have no idea.
CREATE TABLE `user_data` ( `u_id` int NOT NULL, `nick_name` varchar(255) NOT NULL, `kor` int NOT NULL, `eng` int NOT NULL, `math` int NOT NULL, `date` date NOT NULL)SELECT * FROM (SELECT u_id, nick_na...
| « | - 41 - |
© 2024 OneMinuteCode. All rights reserved.