weight_parameters.sql 703 B

12345678910111213141516171819202122
  1. -- Adminer 4.8.1 MySQL 5.7.26 dump
  2. SET NAMES utf8;
  3. SET time_zone = '+00:00';
  4. SET foreign_key_checks = 0;
  5. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  6. USE `sonar_database_new`;
  7. CREATE TABLE `weight_parameters` (
  8. `para_num` int(11) NOT NULL COMMENT '参数序号',
  9. `range_s_fishsize` int(11) NOT NULL COMMENT '小范围鱼的大小',
  10. `range_b_fishsize` int(11) NOT NULL COMMENT '大范围鱼的大小',
  11. `standard_weight` float NOT NULL COMMENT '鱼的标准体重'
  12. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  13. INSERT INTO `weight_parameters` (`para_num`, `range_s_fishsize`, `range_b_fishsize`, `standard_weight`) VALUES
  14. (1, 400, 200, 3.1),
  15. (2, 400, 200, 3.1),
  16. (3, 400, 200, 3.1);
  17. -- 2023-11-04 05:52:31