409 questions
***AddIf you insert, it becomes a part and there are values that go to the null value.Table: CREATE TABLE goods(rnum INT AUTO_INCREMENT PRIMARY KEY,deal_code VARCHAR(15) ,category_code VARCHAR(15) ,go...
Hello, I'm a beginner at mysql.c# is currently using mysql.I feel difficult and ask for advice while doing it, so I ask for advice.The data in the DB is being updated, ignored, and if not, INSERT.Ther...
Example) member_tableno - auto increment,id - not null,pw - not null,email, phone, address $sql1= INSERT INTO member_table (no ,id, pw, email,phone,address) VALUES (NULL, '$id', '$pw', '$email', '$...
Product ------FK----> Purchase ListIf the product on the purchase list is deleted, the purchase list is supposed to be deleted. Is it the right way not to delete the purchase list?Or is it right to...
My web app has a search field and a combo box that receives some strings. So we send two factors as a remote function. All I want is to configure the query by checking whether the input value is null ...
We are currently using mysql as rds, and we have something to use stored process of an external company in mysql.I received stored procedure in the form of sql extension, and I wonder how I can apply ...
Hello, I am a 21-year-old young man who is working as a service planner and studying mysql.I'm just asking you a question because I couldn't get an answer because I was stuck in the middle of my ql as...
Regarding the API Driver for Django and MySQL connections, Django Tutorial recommends mysqlclient among MySQLdb, mysqlclient, and MySQL Connector/Python, but MySQL Connector/Python is recommended on t...
select name from DB limit 0,1; in mysqlThis query will output a total of one record from 0 records for the data in the field name in a table called DB.What I want is to update that selected data. But....
Hi, everyone. CREATE TABLE profession( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, profession VARCHAR(20)) ASSELECT profession AS mc_prof FROM my_contacts AS mcGROUP BY mc_profORDER BY mc_prof;You wan...
| « | - 35 - | » |
© 2024 OneMinuteCode. All rights reserved.