test.sql 335 B

1234567891011121314
  1. CREATE TABLE `t1` (
  2. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  3. `c1` FLOAT NULL,
  4. `c2` FLOAT NULL,
  5. `c3` FLOAT NULL,
  6. PRIMARY KEY (`id`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='指标测试表';
  8. INSERT INTO test.t1
  9. (id, c1, c2, c3)
  10. VALUES(1, 1.0, 2.0, 3.0);
  11. INSERT INTO test.t1
  12. (id, c1, c2, c3)
  13. VALUES(2, 2.0, 3.0, 4.0);