mysql - 将数据插入 MySQL 表

Question

所以我有一个关于将数据插入表的问题，问题如下:

Assume a database table: customers

Assume these columns

name     varchar(10)

streetAddress     varchar)15)

stateAbbreviation     varchar(2)

balance     decimal(6,2)

Write the SQL that will insert a record to the customers table with these values:

name:     Jimmy

streetAddress:     10 Main St.

stateAbbreviation:     KS

balance:     17.56 

这是我想出的代码:

insert into customers (name,streetAddress,stateAbbreviation,balance) values ('Jimmy','10 Main St.','KS','17.56');

我收到一条错误消息，说这是不对的，我哪里做错了？谢谢

Answer 1

balance 列是一个十进制，但您尝试插入一个字符串值:

'17.56'

而是插入一个数值:

17.56