sql tag

625 questions


1 answers
44 views
0
Unable to save db in html.

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

2 years ago

1 answers
46 views
0
ignore mysql duplicate data insert if no duplicate data

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

2 years ago

1 answers
144 views
0
What is the difference between inserting NULL or '' in the auto_increment column in mysql?

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


2 answers
109 views
0
What should I do with logic when the purchase list product is deleted?

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


1 answers
115 views
0
How do I check if the String is null or not empty in Java?

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


1 answers
75 views
0
spring 500 ERROR .!

HTTP Status 500 - Request processing failed; nested exception is java.lang.ClassCastException: org.apache.catalina.connector.RequestFacade cannot be cast to org.springframework.web.multipart.Multipart...


1 answers
109 views
0
AWS RDS asking how to use stored procedure

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

2 years ago

2 answers
82 views
0
I have a question about my ql join Help me please. crying

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

2 years ago

1 answers
46 views
0
Problems Connecting Django to MySQL

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

2 years ago

1 answers
123 views
0
mysql select update

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

2 years ago
« - 53 - »

© 2024 OneMinuteCode. All rights reserved.