Posts by Nidorus • 59 points

9 posts

0
votes

1
answer

401
views

Q: While Python repetition structure

Good afternoon guys, I’m trying to make a program that always updates a month to my date: Example I have a minimum date, maximum date and the current date I want that whenever my min date is less…

python loop date while
asked 5 years, 2 months ago Nidorus 59
0
votes

3
answers

1324
views

A: Select records from one record to another in sql server

Good afternoon Buddy try it this way. USE vendateste GO WITH TesteVenda AS --Nesse Sub Select uso o ROW_NUMBER Para numerar a saída do conjunto do resultado ( SELECT ROW_NUMBER() OVER(ORDER BY…

sql select server
answered 5 years, 3 months ago Nidorus 59
1
votes

1
answer

4919
views

Q: Comparing column values in dataframe pandas rows

Good afternoon. I am comparing two given frames, data frame 1 has an sql query and data frame 2 a mysql query I want to compare the two. When the DF 1 record is not in DF 2 I want to save the result…

mysql sql python
asked 5 years, 3 months ago Nidorus 59
-1
votes

1
answer

962
views

Q: How to compare two Python data frames

Hello guys I am trying to automate a loading process with python bringing data from sql and sending to a mysql table and I am facing some problems. Problem: I need that when I have new data in my…

mysql sql python
asked 5 years, 4 months ago Nidorus 59
-1
votes

3
answers

2084
views

Q: Check if records exist with Python

I’m going from SQL to python and I’m still a little confused. It is the following here in my code I want to know if the values of the select of the result variable exist in the select of the sale…

mysql sql python if else
asked 5 years, 4 months ago Nidorus 59
1
votes

1
answer

79
views

Q: Dataframe Python

Good afternoon guys, I have a question and I wanted to ask for your help. I wanted to know how to make a Dataframe in python that stores the data of an sql view and also know how the syntax would…

mysql sql python syntax
asked 5 years, 4 months ago Nidorus 59
0
votes

2
answers

1609
views

Q: Python Mysql database connection

Trying to make the connection to my database, but is returning me the following error! Exception has occurred: Attributeerror 'Connection' Object has no attribute 'execute' Exception has occurred:…

mysql sql python python-3.x connection
asked 5 years, 4 months ago Nidorus 59
2
votes

1
answer

1508
views

Q: SQL Server Connection - Python

Good afternoon guys I’m having trouble making a connection with sql, whenever I try to make the connection the following error occurs: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL…

sql python api syntax connection
asked 5 years, 4 months ago Nidorus 59
0
votes

1
answer

62
views

Q: Stored Procedures parameters

I have a question and I wanted to ask for your help. Next: I have a proc and I want when I don’t pass a parameter it returns to me null and when this happens bring the date of the day -1 and time…

sql sql-server stored-procedures
asked 5 years, 5 months ago Nidorus 59