Implementation of mysql decimal data type conversion

Recently, I encountered a database with the following data type: decimal(14,4)

The problems encountered are:

When I use Python to read data into memory, it always has decimal characters. When I write it into other MySQL tables, the data type is int, which causes data to fail to be stored.

import pymysql
# Create a database connection con = pymysql.connect()

sql = '''select
created_time
from schma.table
LIMIT 10'''

try:
  cur = con.cursor(cursor=pymysql.cursors.DictCursor)
  cur.execute(sql)
except Exception as e:
 print(e)
else:
 data = cur.fetchall()
finally:
 cur.close()
 con.close()

for d in data:
 created_time = d.get('created_time')
 print(created_time)

Solution:

Use mysql's cast method to convert

select
cast(created_time as signed) AS created_time 
from schma.table

This is the end of this article about the implementation of MySQL decimal data type conversion. For more information about MySQL decimal data type conversion, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!