mysql tag

409 questions

1 answers
112 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...

pymysql

2 years ago

1 answers
42 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...

jsp mysql

2 years ago

1 answers
80 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,...

mssql sql mysql

2 years ago

1 answers
46 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, ...

c# mysql

2 years ago

1 answers
86 views
0

I'm using DBeaver, how can I copy the database?

DBeaver is using this and that database.By the way, I want to copy the database that I use by accessing DBeaver from another remote computer.How should I do it?

database postgresql hadoop mysql mssql

2 years ago

1 answers
120 views
0

I want to group based on one column of mysql and join with another table after getting the number.

I made a GROUP based on ID in Table A.SELECT TOP 200 A.ID,COUNT(A.ID) AS CNT FROM A A LEFT join ANAME as Aname on A.ID = Aname.ID LEFT join BNAME as Bname on Aname.SEQ = Bname.SEQ where A.POI_ID > ...

mysql sql querying group-by

2 years ago

1 answers
33 views
0

Mysql's insert query statement type question

sql = insert into tb_q (q_num, title, contents, tag, user, time) values (%s,%s,%s,%s,%s,%s)We've created a query statement like thisThe q_num variable is an integer type, but even if it is %s, is i...

mysql python

2 years ago

1 answers
43 views
0

PHP question!(Crying)

I'm trying to build a system for texting...There is a part where you receive PHP API from an existing text company and enter the reception number$_POST['receiver'] = '010xxx,010xxxx,... '; //You can t...

php mysql

2 years ago

1 answers
95 views
0

When the current utc time value is inserted through spark sqlcontext, it is inserted into the current local state, not utc

After purifying the data frame through sql context in spark, Write the code below and attach it to jdbc write.df_2.createOrReplaceTempView(vms_status)q = SELECT srv_name, srv_serial, groups_id, item_i...

python mysql mssql

2 years ago

1 answers
36 views
0

I'm trying to modify the value of the column in mysql column, but it doesn't work

mysql

2 years ago

- 40 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656