mysql添加值,MySQL表添加双值

我正在尝试在mySQL控制台上创建表.

CREATE TABLE TRY (Essn int(10), Pno int(2), Hours DOUBLE(40,0));

当我尝试向表中添加内容时：

INSERT INTO TRY ('123456789','1','32,5');

我有一个关于语法的错误.我找不到问题.有人可以帮忙吗？

解决方法:

删除引号,将32.5替换为32.5,然后添加VALUES关键字即可：

INSERT INTO TRY VALUES (123456789,1,32.5);

您可能还想更改双字段定义,以便在“小时”字段中允许更多的十进制数字：

CREATE TABLE TRY (Essn int(10), Pno int(2), Hours DOUBLE(40,2));

有关更多详细信息,请参阅MySQL的approximate value部分

“(M,D)” means than values can be stored with up to M digits in total,

of which D digits may be after the decimal point. For example, a

column defined as FLOAT(7,4) will look like -999.9999 when displayed.

MySQL performs rounding when storing values, so if you insert

999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001.

标签：mysql

来源： https://codeday.me/bug/20191028/1953713.html