float类型设置位数例如 float(9,2)9是总位数2是小数点后位数。如果不设置小数点后位数则默认没有小数点位数自动4舍5入。关联更新UPDATE stock_vary_table as s JOIN bill_table b ON s.billIdb.id set s.shopIdb.shopId WHERE s.shopId1 AND s.billId0 and s.shopid!b.shopId迁移数据库文件后有的表报错误mysql table is marked as crashed and last (automatic?) repair failed解决办法pre#停止mysql服务service mysqld stop#进入数据目录修复myisamchk -r -v -f 表名service mysql start/pre
