sql tag

625 questions


1 answers
110 views
0
pymysql query rate (for statement)

try: with conn.cursor() as cursor: for i in range(0,len(Portfolio)): sql = 'Select Price_Div.Ticker, Price_Div.Date, Price_Div.Price_Div from Price_Div where Price_Div.Date = STR_TO_DATE(%s,\'%%Y%%m...

2 years ago

1 answers
50 views
0
Query Oracle SQL for rent on date

Hello, I'm a beginner developer.I want to think of it like this. I don't know how to calculate it, so I'm asking you this question.

2 years ago

1 answers
40 views
0
jsp, MySql Bulletin Select Query Questions

I'm working on the part where I look up the entire list of articles with jsp and mysqlI thought it was a simple task to change the code that Oracle already made once to mysql, but I'm having a hard ti...

2 years ago

1 answers
44 views
0
SQL Algorithm Question.

I don't know, so I'm asking you a question

2 years ago

1 answers
48 views
0
Database question!

Hello, I am a student who is studying at the academy.I'm working on a project, but I'm in trouble because the database connection is slow.I'm asking because I'm curious if it's because the grammar is ...

2 years ago

1 answers
78 views
0
Is there a way to use the column bar that I made in mssql select?

SELECT D.dev_serial ,D.dev_name /* /* location */ ,case when charIndex(']', dbo.funcSplit(dbo.funcSplit(D.dev_name, '(', 1) , '_', 3)) > 0 then dbo.funcSplit(dbo.funcSplit(dbo.funcSplit(D.dev_name,...

2 years ago

2 answers
114 views
0
How can I quickly insert a data frame with a large python capacity into msql?

I want to create a data frame with Python's Pandas and insert it into mssqlData frames are formed in 14 columns at an average of 250,000 rows.sqlalchemy.create_engine to insert the whole in sql form, ...

2 years ago

1 answers
97 views
0
Is there a way to call and use the newly created column right away when selecting in mssql?

select T.test_col ,MAX(T.test_co) as max_test ,max_test as max2 -- I want to use the column information that I calculated earlier like this right away.from test_table TIs it completely impossible? O...

2 years ago

1 answers
132 views
0
Can I link the mssql of azure in Hue?

Ubuntu server is using spark. I installed hue, for scheduling and monitoringhue seems to support mysql, postgresql, and sqlite by default.How can I use it in conjunction with mssql of azure in hue?

2 years ago

1 answers
43 views
0
Inserting Xml data into MySQL

Tool : Visual Studio 2017Language: C#(WinForm)The public data portal applies for and uses the COVID-19 outbreak status inquiry data (Xml) by city.Currently, when you run a program with Visual Studio, ...

2 years ago
« - 60 - »

© 2024 OneMinuteCode. All rights reserved.