php - 插入 MySQL 1 时的 DECIMAL 值不正确

Question

名称类型

小数点价格(7,0)

INSERT INTO products (uid, item_code,item_name, brand_name,model_number,weight,dimension,description,category,quantity,price,imagename) 
VALUES (1, '01','Lenovo','Lenovo laptop','qwqeiu145','50kg','5x9','Lenovo is the best','Computers & Accessories','2','$250.0000','lenovo');

这是错误

1366 - Incorrect decimal value: '$250.0000' for column 'price' at row 1

Answer 1

你需要改变

$250.0000

到

250.0000

因为它是decimal 数据类型。里面只能插入数字，而$是字符串