Get last row of SQL database and update

Thread Rating:

Thread Modes

Get last row of SQL database and update

buran

Posts: 8,094

Threads: 154

Joined: Sep 2016

Reputation: 582

Oct-14-2021, 05:16 AM (This post was last modified: Oct-14-2021, 05:16 AM by buran.)

You need to fetch the result, e.g.

print(result.fetchone())

At the moment you print the result

Same apply if you use Larz's SQL statement.

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Messages In This Thread

RE: Get last row of SQL database and update - by buran - Oct-14-2021, 05:16 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Python + Google Sheet \| Best way to update specific cells in a single Update()?	Vokofe	1	2,786	Dec-16-2020, 05:26 AM Last Post: Vokofe
	Update database in tkinter	shahulvk	3	3,269	Oct-24-2020, 04:48 PM Last Post: shahulvk
	How to update sql database from csv	Prince_Bhatia	0	2,660	Feb-09-2019, 09:15 PM Last Post: Prince_Bhatia
	add content of database to text widgte with update	atlass218	1	2,642	Jan-06-2019, 02:13 AM Last Post: woooee
	How to update only two colums in database from csv without touching data in other col	Prince_Bhatia	0	2,325	Aug-21-2018, 09:13 AM Last Post: Prince_Bhatia
	problem with select and update the data into the database	chris0147	1	3,264	Aug-18-2017, 09:38 PM Last Post: chris0147
	Search the data to update in a database	chris0147	7	6,913	Oct-27-2016, 03:16 PM Last Post: Ofnuts
	update the data into the database	chris0147	3	6,343	Oct-19-2016, 12:12 AM Last Post: Yoriz

Users browsing this thread: 1 Guest(s)