mysql decimal取数据

DECIMAL(precision, scale)

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    amount DECIMAL(10, 2),
    description VARCHAR(255)
);

INSERT INTO transactions (amount, description) VALUES (123.45, 'Deposit');

SELECT * FROM transactions;

-- 错误示例
INSERT INTO transactions (amount, description) VALUES (123456789012.34, 'Deposit');

-- 正确示例
INSERT INTO transactions (amount, description) VALUES (1234567890.12, 'Deposit');

# Python示例
import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="mydatabase")
cursor = db.cursor()

cursor.execute("SELECT amount FROM transactions WHERE id = 1")
result = cursor.fetchone()

# 确保正确处理DECIMAL类型的数据
amount = result[0]
print(f"Amount: {amount}")