1234567891011121314 |
- CREATE TABLE `t1` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `c1` FLOAT NULL,
- `c2` FLOAT NULL,
- `c3` FLOAT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='指标测试表';
- INSERT INTO test.t1
- (id, c1, c2, c3)
- VALUES(1, 1.0, 2.0, 3.0);
- INSERT INTO test.t1
- (id, c1, c2, c3)
- VALUES(2, 2.0, 3.0, 4.0);
|