假设我已经在MySQL中创建了一个表,如下所示 `id` smallint(5) unsigned NOT NULL auto_incrementorder_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `shipping_cost` decimal(8,2) NOT NUL
我尝试在MySQL中转换为小数,如下所示:我尝试将表中的行数(乘以1.5)转换为点后两位数的浮点数。它会产生一个错误:corresponds to your MySQLserver version for the right syntax to use
near 'CAST((COUNT(*) * 1.5) AS <