Python Forum
Replacing values ​​in Mysql with a condition
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Replacing values ​​in Mysql with a condition
#1
Good evening everyone. Help in python to create a query in the Mysql database. Problem essence: There is a table, in it columns (Sil1 | Sil2 | Sil3) the data in a format -37.4 | -98.0 | -25.2. I need to make a request and if there is a value greater than let's say -300.0, then it needs to be replaced with 0.0
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Get an average of the unique values of a column with group by condition and assign it klllmmm 0 289 Feb-17-2024, 05:53 PM
Last Post: klllmmm
  Mysql and mysql.connector error lostintime 2 692 Oct-03-2023, 10:25 PM
Last Post: lostintime
Photo How to select NULL and blank values from MySQL table into csv python300 9 2,456 Dec-27-2022, 09:43 PM
Last Post: deanhystad
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,141 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  else condition not called when if condition is false Sandz1286 10 5,913 Jun-05-2020, 05:01 PM
Last Post: ebolisa
  [HELP] Nested conditional? double condition followed by another condition. penahuse 25 8,021 Jun-01-2020, 06:00 PM
Last Post: penahuse

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020