Move the data up to the next row in a database

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Move the data up to the next row in a database

nilamo
Last Thursdayist
Super Moderators

Posts: 3,458

Threads: 101

Joined: Sep 2016

Reputation: 143

Aug-13-2017, 02:42 AM

Are they always sequential like that? Because I think just writing sql will replace the entire python snippet: update programs set program_id=program_id-1

Find

Messages In This Thread

Move the data up to the next row in a database - by chris0147 - Aug-12-2017, 07:37 PM

RE: Move the data up to the next row in a database - by nilamo - Aug-13-2017, 02:42 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Python script to extract data from API to database	melpys	0	897	Aug-12-2024, 05:53 PM Last Post: melpys
	How to detect abnormal data in big database python	vanphuht91	5	2,423	Jun-27-2023, 11:22 PM Last Post: Skaperen
	Database that can compress a column, or all data, automatically?	Calab	3	2,182	May-22-2023, 03:25 AM Last Post: Calab
	shutil.move make data corrupt	kucingkembar	0	1,591	Feb-01-2023, 01:30 PM Last Post: kucingkembar
	Basic SQL query using Py: Inserting or querying sqlite3 database not returning data	marlonbown	3	3,229	Nov-08-2022, 07:16 PM Last Post: marlonbown
	Move a particular row in pandas data frame to last row	klllmmm	0	5,791	Dec-27-2021, 09:11 AM Last Post: klllmmm
	I need help parsing through data and creating a database using beautiful soup	username369	1	2,364	Sep-22-2021, 08:45 PM Last Post: Larz60+
	SaltStack: MySQL returner save less data into Database table columns	xtc14	2	3,051	Jul-02-2021, 02:19 PM Last Post: xtc14
	Looping to read data in database	CEC68	1	2,333	Sep-24-2020, 08:54 PM Last Post: scidam
	Get database used data space from pyodbc	susja	1	3,088	Aug-14-2020, 02:01 PM Last Post: susja

Users browsing this thread: 1 Guest(s)

View a Printable Version

Move the data up to the next row in a database

User Panel Messages

Announcements