sql tag

625 questions


1 answers
131 views
0
How can I add 1 to the ms sql/column?;;

To be exact, when you insert the LEVL1 and LEVL2 columns, you add +1 to the record value of LEVL1I want to reflect it in LEVL2 When I saved it as Merge into, I created a query... How can LEVL2 reflect...

2 years ago

1 answers
46 views
0
Check if php file is uploaded

I'm making a bulletin board, but I want to check if the file is attached in the file upload, but it's not working well.ㅠ

2 years ago

1 answers
107 views
0
Interworking with Python data values in Python pimysql

When you have a table called X in the Workbench (in which you have columns called value1, value2) and you define a list called A=[1,2,3] in Python, what should I do with this Python mysql code? For ex...

2 years ago

1 answers
35 views
0
Pymysql where clause triple in list

For example, A = [[1,a],[2,b],[3,c]] and Myqldb has Table X (column1, coulmn2)select X.column1, X.column2 where [X.column1, X.column2] in A I'd like to write a query that means, so please tell me how ...

2 years ago

1 answers
40 views
0
Ubuntu server mysql workbench external access

I want to access Ubuntu server at work from home, how can I do it?Should I allow the IP address of the computer at home?Can I set the port number to 3306?I would appreciate it if you could tell me the...

2 years ago

1 answers
132 views
0
It's a question from MAPPER

I'm planning a car rental systemWe are implementing a function that shows the rental area on the next screen after inserting the rental area and the return area on the web. There are other columns in ...

2 years ago

1 answers
39 views
0
Allow external access to Ubuntu mysql server

I want to connect to my sql server at home (Window 10).In the previous article, you said you needed permission from a company network administratorMy previous boss handed me the server and leftI can c...

2 years ago

1 answers
58 views
0
Error question creating view.

CREATE VIEW C_R ASSELECT LICENSEPLATE, CARNAME, CARMODEL, CARCOM, CONDITION, FUEL, RENT, PASSENGER, DISTANCEFROM CAR_RELATIONS CR, CAR CA, CARMODEL CM, CARCOM CO, PASSENGER PG, RENT RT, FUEL FL, CONDI...

2 years ago

1 answers
94 views
0
pymysql error

The following sql full text fails:Select Price_Div.Ticker, Price_Div.Date, Price_Div.Price_Div from Price_Div where ((Price_Div.Ticker in ('000080 KS Equity', '001530 KS Equity', '001750 KS Equity', '...

2 years ago

1 answers
49 views
0
SQL query question.

On the reservation table, there are columns such as SYSDATE, rental fee, rental date, return date, payment amount, and final payment amount.When the rental fee is 30,000 won per day, When I rented it ...

2 years ago
« - 59 - »

© 2024 OneMinuteCode. All rights reserved.