mssql tag

13 questions

1 answers
159 views
0

When sql select, what should I do if I want to see the general column and the column with the count function applied at the same time?

Table_1 shows the picture belowIt has a number and its corresponding name.And table_2 has numbers.select number, name from table_1Can I check the number and name of table_1 by selecting it as above an...

sql mssql select join count

2 years ago

1 answers
94 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
121 views
0

How to INSERT and UPDATE many rows in python pyodbc?

Regardless of the database in pspark or python (I would like you to let me know around mssql and postgreSQL), you need to insert or update coding for each row.However, Spark does not support update, s...

python mssql python3 sql

2 years ago

- 2 -

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