数据库工作笔记/设计思路-通过增加索引表为某库中其他表添加索引（描述信息）

最新推荐文章于 2024-10-08 14:08:56 发布
最新推荐文章于 2024-10-08 14:08:56 发布
阅读量5.1k 收藏 16
点赞数 16
分类专栏： SQL 工作笔记 文章标签： 数据库 MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq78442761/article/details/89448116
版权

目录

 

 

基本概念

演示

 

基本概念

在设计数据库的时候，通常会增加一个索引表，提供了索引的作用，比如在某一个数据库中，通过一个索引表可以找到这个数据库中的所有表，可以通过外键关联，也可以不通过外键关联（如果只其描述作用）；

还有一直思路，这个索引表不仅仅保存了本数据库中所有表的信息，还保存了数据库中所有表中的列信息，用于添加描述，以及在应用程序中，方便查找的作用；

 

演示

这里用MySQL来演示下：

这里用一个索引表形式（没增加外键）对每一张表和列进行索引和描述

设计如下的数据库：

这里index就是索引表，折线图 每一列代码一条数据；

饼图，每一行，代码一个数据：

index表：

两个折线图：

两饼图：

 

 

数据库源码：

/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.5.47 : Database - dbdesigner
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`dbdesigner` /*!40100 DEFAULT CHARACTER SET gbk */;

USE `dbdesigner`;

/*Table structure for table `brokenline1sec` */

DROP TABLE IF EXISTS `brokenline1sec`;

CREATE TABLE `brokenline1sec` (
  `position` int(11) NOT NULL,
  `Line1` float DEFAULT NULL,
  `Line2` float DEFAULT NULL,
  `Line3` float DEFAULT NULL,
  `Lin4` float DEFAULT NULL,
  PRIMARY KEY (`position`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

/*Data for the table `brokenline1sec` */

insert  into `brokenline1sec`(`position`,`Line1`,`Line2`,`Line3`,`Lin4`) values (0,1000000,1000000,1000000,1000000),(1,1000000,1000000,1000000,1000000),(2,1000000,1000000,1000000,1000000),(3,1000000,1000000,1000000,1000000),(4,1000000,1000000,1000000,1000000),(5,1000000,1000000,1000000,1000000),(6,1000000,1000000,1000000,1000000),(7,1000000,1000000,1000000,1000000),(8,1000000,1000000,1000000,1000000),(9,1000000,1000000,1000000,1000000),(10,1000000,1000000,1000000,1000000),(11,1000000,1000000,1000000,1000000),(12,1000000,1000000,1000000,1000000),(13,1000000,1000000,1000000,1000000),(14,1000000,1000000,1000000,1000000),(15,1000000,1000000,1000000,1000000),(16,1000000,1000000,1000000,1000000),(17,1000000,1000000,1000000,1000000),(18,1000000,1000000,1000000,1000000),(19,1000000,1000000,1000000,1000000),(20,1000000,1000000,1000000,1000000),(21,1000000,1000000,1000000,1000000),(22,1000000,1000000,1000000,1000000),(23,1000000,1000000,1000000,1000000),(24,1000000,1000000,1000000,1000000),(25,1000000,1000000,1000000,1000000),(26,1000000,1000000,1000000,1000000),(27,1000000,1000000,1000000,1000000),(28,1000000,1000000,1000000,1000000),(29,1000000,1000000,1000000,1000000),(30,1000000,1000000,1000000,1000000),(31,1000000,1000000,1000000,1000000),(32,1000000,1000000,1000000,1000000),(33,1000000,1000000,1000000,1000000),(34,1000000,1000000,1000000,1000000),(35,1000000,1000000,1000000,1000000),(36,1000000,1000000,1000000,1000000),(37,1000000,1000000,1000000,1000000),(38,1000000,1000000,1000000,1000000),(39,1000000,1000000,1000000,1000000),(40,1000000,1000000,1000000,1000000),(41,1000000,1000000,1000000,1000000),(42,1000000,1000000,1000000,1000000),(43,1000000,1000000,1000000,1000000),(44,1000000,1000000,1000000,1000000),(45,1000000,1000000,1000000,1000000),(46,1000000,1000000,1000000,1000000),(47,1000000,1000000,1000000,1000000),(48,1000000,1000000,1000000,1000000),(49,1000000,1000000,1000000,1000000),(50,1000000,1000000,1000000,1000000),(51,1000000,1000000,1000000,1000000),(52,1000000,1000000,1000000,1000000),(53,1000000,1000000,1000000,1000000),(54,1000000,1000000,1000000,1000000),(55,1000000,1000000,1000000,1000000),(56,1000000,1000000,1000000,1000000),(57,1000000,1000000,1000000,1000000),(58,1000000,1000000,1000000,1000000),(59,1000000,1000000,1000000,1000000),(60,1000000,1000000,1000000,1000000),(61,1000000,1000000,1000000,1000000),(62,1000000,1000000,1000000,1000000),(63,1000000,1000000,1000000,1000000),(64,1000000,1000000,1000000,1000000),(65,1000000,1000000,1000000,1000000),(66,1000000,1000000,1000000,1000000),(67,1000000,1000000,1000000,1000000),(68,1000000,1000000,1000000,1000000),(69,1000000,1000000,1000000,1000000),(70,1000000,1000000,1000000,1000000),(71,1000000,1000000,1000000,1000000),(72,1000000,1000000,1000000,1000000),(73,1000000,1000000,1000000,1000000),(74,1000000,1000000,1000000,1000000),(75,1000000,1000000,1000000,1000000),(76,1000000,1000000,1000000,1000000),(77,1000000,1000000,1000000,1000000),(78,1000000,1000000,1000000,1000000),(79,1000000,1000000,1000000,1000000),(80,1000000,1000000,1000000,1000000),(81,1000000,1000000,1000000,1000000),(82,1000000,1000000,1000000,1000000),(83,1000000,1000000,1000000,1000000),(84,1000000,1000000,1000000,1000000),(85,1000000,1000000,1000000,1000000),(86,1000000,1000000,1000000,1000000),(87,1000000,1000000,1000000,1000000),(88,1000000,1000000,1000000,1000000),(89,1000000,1000000,1000000,1000000),(90,1000000,1000000,1000000,1000000),(91,1000000,1000000,1000000,1000000),(92,1000000,1000000,1000000,1000000),(93,1000000,1000000,1000000,1000000),(94,1000000,1000000,1000000,1000000),(95,1000000,1000000,1000000,1000000),(96,1000000,1000000,1000000,1000000),(97,1000000,1000000,1000000,1000000),(98,1000000,1000000,1000000,1000000),(99,1000000,1000000,1000000,1000000),(100,1000000,1000000,1000000,1000000),(101,1000000,1000000,1000000,1000000),(102,1000000,1000000,1000000,1000000),(103,1000000,1000000,1000000,1000000),(104,1000000,1000000,1000000,1000000),(105,1000000,1000000,1000000,1000000),(106,1000000,1000000,1000000,1000000),(107,1000000,1000000,1000000,1000000),(108,1000000,1000000,1000000,1000000),(109,1000000,1000000,1000000,1000000),(110,1000000,1000000,1000000,1000000),(111,1000000,1000000,1000000,1000000),(112,1000000,1000000,1000000,1000000),(113,1000000,1000000,1000000,1000000),(114,1000000,1000000,1000000,1000000),(115,1000000,1000000,1000000,1000000),(116,1000000,1000000,1000000,1000000),(117,1000000,1000000,1000000,1000000),(118,1000000,1000000,1000000,1000000),(119,1000000,1000000,1000000,1000000),(120,1000000,1000000,1000000,1000000),(121,1000000,1000000,1000000,1000000),(122,1000000,1000000,1000000,1000000),(123,1000000,1000000,1000000,1000000),(124,1000000,1000000,1000000,1000000),(125,1000000,1000000,1000000,1000000),(126,1000000,1000000,1000000,1000000),(127,1000000,1000000,1000000,1000000),(128,1000000,1000000,1000000,1000000),(129,1000000,1000000,1000000,1000000),(130,1000000,1000000,1000000,1000000),(131,1000000,1000000,1000000,1000000),(132,1000000,1000000,1000000,1000000),(133,1000000,1000000,1000000,1000000),(134,1000000,1000000,1000000,1000000),(135,1000000,1000000,1000000,1000000),(136,1000000,1000000,1000000,1000000),(137,1000000,1000000,1000000,1000000),(138,1000000,1000000,1000000,1000000),(139,1000000,1000000,1000000,1000000),(140,1000000,1000000,1000000,1000000),(141,1000000,1000000,1000000,1000000),(142,1000000,1000000,1000000,1000000),(143,1000000,1000000,1000000,1000000),(144,1000000,1000000,1000000,1000000),(145,1000000,1000000,1000000,1000000),(146,1000000,1000000,1000000,1000000),(147,1000000,1000000,1000000,1000000),(148,1000000,1000000,1000000,1000000),(149,1000000,1000000,1000000,1000000),(150,1000000,1000000,1000000,1000000),(151,1000000,1000000,1000000,1000000),(152,1000000,1000000,1000000,1000000),(153,1000000,1000000,1000000,1000000),(154,1000000,1000000,1000000,1000000),(155,1000000,1000000,1000000,1000000),(156,1000000,1000000,1000000,1000000),(157,1000000,1000000,1000000,1000000),(158,1000000,1000000,1000000,1000000),(159,1000000,1000000,1000000,1000000),(160,1000000,1000000,1000000,1000000),(161,1000000,1000000,1000000,1000000),(162,1000000,1000000,1000000,1000000),(163,1000000,1000000,1000000,1000000),(164,1000000,1000000,1000000,1000000),(165,1000000,1000000,1000000,1000000),(166,1000000,1000000,1000000,1000000),(167,1000000,1000000,1000000,1000000),(168,1000000,1000000,1000000,1000000),(169,1000000,1000000,1000000,1000000),(170,1000000,1000000,1000000,1000000),(171,1000000,1000000,1000000,1000000),(172,1000000,1000000,1000000,1000000),(173,1000000,1000000,1000000,1000000),(174,1000000,1000000,1000000,1000000),(175,1000000,1000000,1000000,1000000),(176,1000000,1000000,1000000,1000000),(177,1000000,1000000,1000000,1000000),(178,1000000,1000000,1000000,1000000),(179,1000000,1000000,1000000,1000000),(180,1000000,1000000,1000000,1000000),(181,1000000,1000000,1000000,1000000),(182,1000000,1000000,1000000,1000000),(183,1000000,1000000,1000000,1000000),(184,1000000,1000000,1000000,1000000),(185,1000000,1000000,1000000,1000000),(186,1000000,1000000,1000000,1000000),(187,1000000,1000000,1000000,1000000),(188,1000000,1000000,1000000,1000000),(189,1000000,1000000,1000000,1000000),(190,1000000,1000000,1000000,1000000),(191,1000000,1000000,1000000,1000000),(192,1000000,1000000,1000000,1000000),(193,1000000,1000000,1000000,1000000),(194,1000000,1000000,1000000,1000000),(195,1000000,1000000,1000000,1000000),(196,1000000,1000000,1000000,1000000),(197,1000000,1000000,1000000,1000000),(198,1000000,1000000,1000000,1000000),(199,1000000,1000000,1000000,1000000),(200,1000000,1000000,1000000,1000000),(201,1000000,1000000,1000000,1000000),(202,1000000,1000000,1000000,1000000),(203,1000000,1000000,1000000,1000000),(204,1000000,1000000,1000000,1000000),(205,1000000,1000000,1000000,1000000),(206,1000000,1000000,1000000,1000000),(207,1000000,1000000,1000000,1000000),(208,1000000,1000000,1000000,1000000),(209,1000000,1000000,1000000,1000000),(210,1000000,1000000,1000000,1000000),(211,1000000,1000000,1000000,1000000),(212,1000000,1000000,1000000,1000000),(213,1000000,1000000,1000000,1000000),(214,1000000,1000000,1000000,1000000),(215,1000000,1000000,1000000,1000000),(216,1000000,1000000,1000000,1000000),(217,1000000,1000000,1000000,1000000),(218,1000000,1000000,1000000,1000000),(219,1000000,1000000,1000000,1000000),(220,1000000,1000000,1000000,1000000),(221,1000000,1000000,1000000,1000000),(222,1000000,1000000,1000000,1000000),(223,1000000,1000000,1000000,1000000),(224,1000000,1000000,1000000,1000000),(225,1000000,1000000,1000000,1000000),(226,1000000,1000000,1000000,1000000),(227,1000000,1000000,1000000,1000000),(228,1000000,1000000,1000000,1000000),(229,1000000,1000000,1000000,1000000),(230,1000000,1000000,1000000,1000000),(231,1000000,1000000,1000000,1000000),(232,1000000,1000000,1000000,1000000),(233,1000000,1000000,1000000,1000000),(234,1000000,1000000,1000000,1000000),(235,1000000,1000000,1000000,1000000),(236,1000000,1000000,1000000,1000000),(237,1000000,1000000,1000000,1000000),(238,1000000,1000000,1000000,1000000),(239,1000000,1000000,1000000,1000000),(240,1000000,1000000,1000000,1000000),(241,1000000,1000000,1000000,1000000),(242,1000000,1000000,1000000,1000000),(243,1000000,1000000,1000000,1000000),(244,1000000,1000000,1000000,1000000),(245,1000000,1000000,1000000,1000000),(246,1000000,1000000,1000000,1000000),(247,1000000,1000000,1000000,1000000),(248,1000000,1000000,1000000,1000000),(249,1000000,1000000,1000000,1000000),(250,1000000,1000000,1000000,1000000),(251,1000000,1000000,1000000,1000000),(252,1000000,1000000,1000000,1000000),(253,1000000,1000000,1000000,1000000),(254,1000000,1000000,1000000,1000000),(255,1000000,1000000,1000000,1000000),(256,1000000,1000000,1000000,1000000),(257,1000000,1000000,1000000,1000000),(258,1000000,1000000,1000000,1000000),(259,1000000,1000000,1000000,1000000),(260,1000000,1000000,1000000,1000000),(261,1000000,1000000,1000000,1000000),(262,1000000,1000000,1000000,1000000),(263,1000000,1000000,1000000,1000000),(264,1000000,1000000,1000000,1000000),(265,1000000,1000000,1000000,1000000),(266,1000000,1000000,1000000,1000000),(267,1000000,1000000,1000000,1000000),(268,1000000,1000000,1000000,1000000),(269,1000000,1000000,1000000,1000000),(270,1000000,1000000,1000000,1000000),(271,1000000,1000000,1000000,1000000),(272,1000000,1000000,1000000,1000000),(273,1000000,1000000,1000000,1000000),(274,1000000,1000000,1000000,1000000),(275,1000000,1000000,1000000,1000000),(276,1000000,1000000,1000000,1000000),(277,1000000,1000000,1000000,1000000),(278,1000000,1000000,1000000,1000000),(279,1000000,1000000,1000000,1000000),(280,1000000,1000000,1000000,1000000),(281,1000000,1000000,1000000,1000000),(282,1000000,1000000,1000000,1000000),(283,1000000,1000000,1000000,1000000),(284,1000000,1000000,1000000,1000000),(285,1000000,1000000,1000000,1000000),(286,1000000,1000000,1000000,1000000),(287,1000000,1000000,1000000,1000000),(288,1000000,1000000,1000000,1000000),(289,1000000,1000000,1000000,1000000),(290,1000000,1000000,1000000,1000000),(291,1000000,1000000,1000000,1000000),(292,1000000,1000000,1000000,1000000),(293,1000000,1000000,1000000,1000000),(294,1000000,1000000,1000000,1000000),(295,1000000,1000000,1000000,1000000),(296,1000000,1000000,1000000,1000000),(297,1000000,1000000,1000000,1000000),(298,1000000,1000000,1000000,1000000),(299,1000000,1000000,1000000,1000000),(300,1000000,1000000,1000000,1000000),(301,1000000,1000000,1000000,1000000),(302,1000000,1000000,1000000,1000000),(303,1000000,1000000,1000000,1000000),(304,1000000,1000000,1000000,1000000),(305,1000000,1000000,1000000,1000000),(306,1000000,1000000,1000000,1000000),(307,1000000,1000000,1000000,1000000),(308,1000000,1000000,1000000,1000000),(309,1000000,1000000,1000000,1000000),(310,1000000,1000000,1000000,1000000),(311,1000000,1000000,1000000,1000000),(312,1000000,1000000,1000000,1000000),(313,1000000,1000000,1000000,1000000),(314,1000000,1000000,1000000,1000000),(315,1000000,1000000,1000000,1000000),(316,1000000,1000000,1000000,1000000),(317,1000000,1000000,1000000,1000000),(318,1000000,1000000,1000000,1000000),(319,1000000,1000000,1000000,1000000),(320,1000000,1000000,1000000,1000000),(321,1000000,1000000,1000000,1000000),(322,1000000,1000000,1000000,1000000),(323,1000000,1000000,1000000,1000000),(324,1000000,1000000,1000000,1000000),(325,1000000,1000000,1000000,1000000),(326,1000000,1000000,1000000,1000000),(327,1000000,1000000,1000000,1000000),(328,1000000,1000000,1000000,1000000),(329,1000000,1000000,1000000,1000000),(330,1000000,1000000,1000000,1000000),(331,1000000,1000000,1000000,1000000),(332,1000000,1000000,1000000,1000000),(333,1000000,1000000,1000000,1000000),(334,1000000,1000000,1000000,1000000),(335,1000000,1000000,1000000,1000000),(336,1000000,1000000,1000000,1000000),(337,1000000,1000000,1000000,1000000),(338,1000000,1000000,1000000,1000000),(339,1000000,1000000,1000000,1000000),(340,1000000,1000000,1000000,1000000),(341,1000000,1000000,1000000,1000000),(342,1000000,1000000,1000000,1000000),(343,1000000,1000000,1000000,1000000),(344,1000000,1000000,1000000,1000000),(345,1000000,1000000,1000000,1000000),(346,1000000,1000000,1000000,1000000),(347,1000000,1000000,1000000,1000000),(348,1000000,1000000,1000000,1000000),(349,1000000,1000000,1000000,1000000),(350,1000000,1000000,1000000,1000000),(351,1000000,1000000,1000000,1000000),(352,1000000,1000000,1000000,1000000),(353,1000000,1000000,1000000,1000000),(354,1000000,1000000,1000000,1000000),(355,1000000,1000000,1000000,1000000),(356,1000000,1000000,1000000,1000000),(357,1000000,1000000,1000000,1000000),(358,1000000,1000000,1000000,1000000),(359,1000000,1000000,1000000,1000000),(360,1000000,1000000,1000000,1000000),(361,1000000,1000000,1000000,1000000),(362,1000000,1000000,1000000,1000000),(363,1000000,1000000,1000000,1000000),(364,1000000,1000000,1000000,1000000),(365,1000000,1000000,1000000,1000000),(366,1000000,1000000,1000000,1000000),(367,1000000,1000000,1000000,1000000),(368,1000000,1000000,1000000,1000000),(369,1000000,1000000,1000000,1000000),(370,1000000,1000000,1000000,1000000),(371,1000000,1000000,1000000,1000000),(372,1000000,1000000,1000000,1000000),(373,1000000,1000000,1000000,1000000),(374,1000000,1000000,1000000,1000000),(375,1000000,1000000,1000000,1000000),(376,1000000,1000000,1000000,1000000),(377,1000000,1000000,1000000,1000000),(378,1000000,1000000,1000000,1000000),(379,1000000,1000000,1000000,1000000),(380,1000000,1000000,1000000,1000000),(381,1000000,1000000,1000000,1000000),(382,1000000,1000000,1000000,1000000),(383,1000000,1000000,1000000,1000000),(384,1000000,1000000,1000000,1000000),(385,1000000,1000000,1000000,1000000),(386,1000000,1000000,1000000,1000000),(387,1000000,1000000,1000000,1000000),(388,1000000,1000000,1000000,1000000),(389,1000000,1000000,1000000,1000000),(390,1000000,1000000,1000000,1000000),(391,1000000,1000000,1000000,1000000),(392,1000000,1000000,1000000,1000000),(393,1000000,1000000,1000000,1000000),(394,1000000,1000000,1000000,1000000),(395,1000000,1000000,1000000,1000000),(396,1000000,1000000,1000000,1000000),(397,1000000,1000000,1000000,1000000),(398,1000000,1000000,1000000,1000000),(399,1000000,1000000,1000000,1000000),(400,1000000,1000000,1000000,1000000),(401,1000000,1000000,1000000,1000000),(402,1000000,1000000,1000000,1000000),(403,1000000,1000000,1000000,1000000),(404,1000000,1000000,1000000,1000000),(405,1000000,1000000,1000000,1000000),(406,1000000,1000000,1000000,1000000),(407,1000000,1000000,1000000,1000000),(408,1000000,1000000,1000000,1000000),(409,1000000,1000000,1000000,1000000),(410,1000000,1000000,1000000,1000000),(411,1000000,1000000,1000000,1000000),(412,1000000,1000000,1000000,1000000),(413,1000000,1000000,1000000,1000000),(414,1000000,1000000,1000000,1000000),(415,1000000,1000000,1000000,1000000),(416,1000000,1000000,1000000,1000000),(417,1000000,1000000,1000000,1000000),(418,1000000,1000000,1000000,1000000),(419,1000000,1000000,1000000,1000000),(420,1000000,1000000,1000000,1000000),(421,1000000,1000000,1000000,1000000),(422,1000000,1000000,1000000,1000000),(423,1000000,1000000,1000000,1000000),(424,1000000,1000000,1000000,1000000),(425,1000000,1000000,1000000,1000000),(426,1000000,1000000,1000000,1000000),(427,1000000,1000000,1000000,1000000),(428,1000000,1000000,1000000,1000000),(429,1000000,1000000,1000000,1000000),(430,1000000,1000000,1000000,1000000),(431,1000000,1000000,1000000,1000000),(432,1000000,1000000,1000000,1000000),(433,1000000,1000000,1000000,1000000),(434,1000000,1000000,1000000,1000000),(435,1000000,1000000,1000000,1000000),(436,1000000,1000000,1000000,1000000),(437,1000000,1000000,1000000,1000000),(438,1000000,1000000,1000000,1000000),(439,1000000,1000000,1000000,1000000),(440,1000000,1000000,1000000,1000000),(441,1000000,1000000,1000000,1000000),(442,1000000,1000000,1000000,1000000),(443,1000000,1000000,1000000,1000000),(444,1000000,1000000,1000000,1000000),(445,1000000,1000000,1000000,1000000),(446,1000000,1000000,1000000,1000000),(447,1000000,1000000,1000000,1000000),(448,1000000,1000000,1000000,1000000),(449,1000000,1000000,1000000,1000000),(450,1000000,1000000,1000000,1000000),(451,1000000,1000000,1000000,1000000),(452,1000000,1000000,1000000,1000000),(453,1000000,1000000,1000000,1000000),(454,1000000,1000000,1000000,1000000),(455,1000000,1000000,1000000,1000000),(456,1000000,1000000,1000000,1000000),(457,1000000,1000000,1000000,1000000),(458,1000000,1000000,1000000,1000000),(459,1000000,1000000,1000000,1000000),(460,1000000,1000000,1000000,1000000),(461,1000000,1000000,1000000,1000000),(462,1000000,1000000,1000000,1000000),(463,1000000,1000000,1000000,1000000),(464,1000000,1000000,1000000,1000000),(465,1000000,1000000,1000000,1000000),(466,1000000,1000000,1000000,1000000),(467,1000000,1000000,1000000,1000000),(468,1000000,1000000,1000000,1000000),(469,1000000,1000000,1000000,1000000),(470,1000000,1000000,1000000,1000000),(471,1000000,1000000,1000000,1000000),(472,1000000,1000000,1000000,1000000),(473,1000000,1000000,1000000,1000000),(474,1000000,1000000,1000000,1000000),(475,1000000,1000000,1000000,1000000),(476,1000000,1000000,1000000,1000000),(477,1000000,1000000,1000000,1000000),(478,1000000,1000000,1000000,1000000),(479,1000000,1000000,1000000,1000000),(480,1000000,1000000,1000000,1000000),(481,1000000,1000000,1000000,1000000),(482,1000000,1000000,1000000,1000000),(483,1000000,1000000,1000000,1000000),(484,1000000,1000000,1000000,1000000),(485,1000000,1000000,1000000,1000000),(486,1000000,1000000,1000000,1000000),(487,1000000,1000000,1000000,1000000),(488,1000000,1000000,1000000,1000000),(489,1000000,1000000,1000000,1000000),(490,1000000,1000000,1000000,1000000),(491,1000000,1000000,1000000,1000000),(492,1000000,1000000,1000000,1000000),(493,1000000,1000000,1000000,1000000),(494,1000000,1000000,1000000,1000000),(495,1000000,1000000,1000000,1000000),(496,1000000,1000000,1000000,1000000),(497,1000000,1000000,1000000,1000000),(498,1000000,1000000,1000000,1000000),(499,1000000,1000000,1000000,1000000),(500,1000000,1000000,1000000,1000000),(501,1000000,1000000,1000000,1000000),(502,1000000,1000000,1000000,1000000),(503,1000000,1000000,1000000,1000000),(504,1000000,1000000,1000000,1000000),(505,1000000,1000000,1000000,1000000),(506,1000000,1000000,1000000,1000000),(507,1000000,1000000,1000000,1000000),(508,1000000,1000000,1000000,1000000),(509,1000000,1000000,1000000,1000000),(510,1000000,1000000,1000000,1000000),(511,1000000,1000000,1000000,1000000),(512,1000000,1000000,1000000,1000000),(513,1000000,1000000,1000000,1000000),(514,1000000,1000000,1000000,1000000),(515,1000000,1000000,1000000,1000000),(516,1000000,1000000,1000000,1000000),(517,1000000,1000000,1000000,1000000),(518,1000000,1000000,1000000,1000000),(519,1000000,1000000,1000000,1000000),(520,1000000,1000000,1000000,1000000),(521,1000000,1000000,1000000,1000000),(522,1000000,1000000,1000000,1000000),(523,1000000,1000000,1000000,1000000),(524,1000000,1000000,1000000,1000000),(525,1000000,1000000,1000000,1000000),(526,1000000,1000000,1000000,1000000),(527,1000000,1000000,1000000,1000000),(528,1000000,1000000,1000000,1000000),(529,1000000,1000000,1000000,1000000),(530,1000000,1000000,1000000,1000000),(531,1000000,1000000,1000000,1000000),(532,1000000,1000000,1000000,1000000),(533,1000000,1000000,1000000,1000000),(534,1000000,1000000,1000000,1000000),(535,1000000,1000000,1000000,1000000),(536,1000000,1000000,1000000,1000000),(537,1000000,1000000,1000000,1000000),(538,1000000,1000000,1000000,1000000),(539,1000000,1000000,1000000,1000000),(540,1000000,1000000,1000000,1000000),(541,1000000,1000000,1000000,1000000),(542,1000000,1000000,1000000,1000000),(543,1000000,1000000,1000000,1000000),(544,1000000,1000000,1000000,1000000),(545,1000000,1000000,1000000,1000000),(546,1000000,1000000,1000000,1000000),(547,1000000,1000000,1000000,1000000),(548,1000000,1000000,1000000,1000000),(549,1000000,1000000,1000000,1000000),(550,1000000,1000000,1000000,1000000),(551,1000000,1000000,1000000,1000000),(552,1000000,1000000,1000000,1000000),(553,1000000,1000000,1000000,1000000),(554,1000000,1000000,1000000,1000000),(555,1000000,1000000,1000000,1000000),(556,1000000,1000000,1000000,1000000),(557,1000000,1000000,1000000,1000000),(558,1000000,1000000,1000000,1000000),(559,1000000,1000000,1000000,1000000),(560,1000000,1000000,1000000,1000000),(561,1000000,1000000,1000000,1000000),(562,1000000,1000000,1000000,1000000),(563,1000000,1000000,1000000,1000000),(564,1000000,1000000,1000000,1000000),(565,1000000,1000000,1000000,1000000),(566,1000000,1000000,1000000,1000000),(567,1000000,1000000,1000000,1000000),(568,1000000,1000000,1000000,1000000),(569,1000000,1000000,1000000,1000000),(570,1000000,1000000,1000000,1000000),(571,1000000,1000000,1000000,1000000),(572,1000000,1000000,1000000,1000000),(573,1000000,1000000,1000000,1000000),(574,1000000,1000000,1000000,1000000),(575,1000000,1000000,1000000,1000000),(576,1000000,1000000,1000000,1000000),(577,1000000,1000000,1000000,1000000),(578,1000000,1000000,1000000,1000000),(579,1000000,1000000,1000000,1000000),(580,1000000,1000000,1000000,1000000),(581,1000000,1000000,1000000,1000000),(582,1000000,1000000,1000000,1000000),(583,1000000,1000000,1000000,1000000),(584,1000000,1000000,1000000,1000000),(585,1000000,1000000,1000000,1000000),(586,1000000,1000000,1000000,1000000),(587,1000000,1000000,1000000,1000000),(588,1000000,1000000,1000000,1000000),(589,1000000,1000000,1000000,1000000),(590,1000000,1000000,1000000,1000000),(591,1000000,1000000,1000000,1000000),(592,1000000,1000000,1000000,1000000),(593,1000000,1000000,1000000,1000000),(594,1000000,1000000,1000000,1000000),(595,1000000,1000000,1000000,1000000),(596,1000000,1000000,1000000,1000000),(597,1000000,1000000,1000000,1000000),(598,1000000,1000000,1000000,1000000),(599,1000000,1000000,1000000,1000000),(600,1000000,1000000,1000000,1000000),(601,1000000,1000000,1000000,1000000),(602,1000000,1000000,1000000,1000000),(603,1000000,1000000,1000000,1000000),(604,1000000,1000000,1000000,1000000),(605,1000000,1000000,1000000,1000000),(606,1000000,1000000,1000000,1000000),(607,1000000,1000000,1000000,1000000),(608,1000000,1000000,1000000,1000000),(609,1000000,1000000,1000000,1000000),(610,1000000,1000000,1000000,1000000),(611,1000000,1000000,1000000,1000000),(612,1000000,1000000,1000000,1000000),(613,1000000,1000000,1000000,1000000),(614,1000000,1000000,1000000,1000000),(615,1000000,1000000,1000000,1000000),(616,1000000,1000000,1000000,1000000),(617,1000000,1000000,1000000,1000000),(618,1000000,1000000,1000000,1000000),(619,1000000,1000000,1000000,1000000),(620,1000000,1000000,1000000,1000000),(621,1000000,1000000,1000000,1000000),(622,1000000,1000000,1000000,1000000),(623,1000000,1000000,1000000,1000000),(624,1000000,1000000,1000000,1000000),(625,1000000,1000000,1000000,1000000),(626,1000000,1000000,1000000,1000000),(627,1000000,1000000,1000000,1000000),(628,1000000,1000000,1000000,1000000),(629,1000000,1000000,1000000,1000000),(630,1000000,1000000,1000000,1000000),(631,1000000,1000000,1000000,1000000),(632,1000000,1000000,1000000,1000000),(633,1000000,1000000,1000000,1000000),(634,1000000,1000000,1000000,1000000),(635,1000000,1000000,1000000,1000000),(636,1000000,1000000,1000000,1000000),(637,1000000,1000000,1000000,1000000),(638,1000000,1000000,1000000,1000000),(639,1000000,1000000,1000000,1000000),(640,1000000,1000000,1000000,1000000),(641,1000000,1000000,1000000,1000000),(642,1000000,1000000,1000000,1000000),(643,1000000,1000000,1000000,1000000),(644,1000000,1000000,1000000,1000000),(645,1000000,1000000,1000000,1000000),(646,1000000,1000000,1000000,1000000),(647,1000000,1000000,1000000,1000000),(648,1000000,1000000,1000000,1000000),(649,1000000,1000000,1000000,1000000),(650,1000000,1000000,1000000,1000000),(651,1000000,1000000,1000000,1000000),(652,1000000,1000000,1000000,1000000),(653,1000000,1000000,1000000,1000000),(654,1000000,1000000,1000000,1000000),(655,1000000,1000000,1000000,1000000),(656,1000000,1000000,1000000,1000000),(657,1000000,1000000,1000000,1000000),(658,1000000,1000000,1000000,1000000),(659,1000000,1000000,1000000,1000000),(660,1000000,1000000,1000000,1000000),(661,1000000,1000000,1000000,1000000),(662,1000000,1000000,1000000,1000000),(663,1000000,1000000,1000000,1000000),(664,1000000,1000000,1000000,1000000),(665,1000000,1000000,1000000,1000000),(666,1000000,1000000,1000000,1000000),(667,1000000,1000000,1000000,1000000),(668,1000000,1000000,1000000,1000000),(669,1000000,1000000,1000000,1000000),(670,1000000,1000000,1000000,1000000),(671,1000000,1000000,1000000,1000000),(672,1000000,1000000,1000000,1000000),(673,1000000,1000000,1000000,1000000),(674,1000000,1000000,1000000,1000000),(675,1000000,1000000,1000000,1000000),(676,1000000,1000000,1000000,1000000),(677,1000000,1000000,1000000,1000000),(678,1000000,1000000,1000000,1000000),(679,1000000,1000000,1000000,1000000),(680,1000000,1000000,1000000,1000000),(681,1000000,1000000,1000000,1000000),(682,1000000,1000000,1000000,1000000),(683,1000000,1000000,1000000,1000000),(684,1000000,1000000,1000000,1000000),(685,1000000,1000000,1000000,1000000),(686,1000000,1000000,1000000,1000000),(687,1000000,1000000,1000000,1000000),(688,1000000,1000000,1000000,1000000),(689,1000000,1000000,1000000,1000000),(690,1000000,1000000,1000000,1000000),(691,1000000,1000000,1000000,1000000),(692,1000000,1000000,1000000,1000000),(693,1000000,1000000,1000000,1000000),(694,1000000,1000000,1000000,1000000),(695,1000000,1000000,1000000,1000000),(696,1000000,1000000,1000000,1000000),(697,1000000,1000000,1000000,1000000),(698,1000000,1000000,1000000,1000000),(699,1000000,1000000,1000000,1000000),(700,1000000,1000000,1000000,1000000),(701,1000000,1000000,1000000,1000000),(702,1000000,1000000,1000000,1000000),(703,1000000,1000000,1000000,1000000),(704,1000000,1000000,1000000,1000000),(705,1000000,1000000,1000000,1000000),(706,1000000,1000000,1000000,1000000),(707,1000000,1000000,1000000,1000000),(708,1000000,1000000,1000000,1000000),(709,1000000,1000000,1000000,1000000),(710,1000000,1000000,1000000,1000000),(711,1000000,1000000,1000000,1000000),(712,1000000,1000000,1000000,1000000),(713,1000000,1000000,1000000,1000000),(714,1000000,1000000,1000000,1000000),(715,1000000,1000000,1000000,1000000),(716,1000000,1000000,1000000,1000000),(717,1000000,1000000,1000000,1000000),(718,1000000,1000000,1000000,1000000),(719,1000000,1000000,1000000,1000000),(720,1000000,1000000,1000000,1000000),(721,1000000,1000000,1000000,1000000),(722,1000000,1000000,1000000,1000000),(723,1000000,1000000,1000000,1000000),(724,1000000,1000000,1000000,1000000),(725,1000000,1000000,1000000,1000000),(726,1000000,1000000,1000000,1000000),(727,1000000,1000000,1000000,1000000),(728,1000000,1000000,1000000,1000000),(729,1000000,1000000,1000000,1000000),(730,1000000,1000000,1000000,1000000),(731,1000000,1000000,1000000,1000000),(732,1000000,1000000,1000000,1000000),(733,1000000,1000000,1000000,1000000),(734,1000000,1000000,1000000,1000000),(735,1000000,1000000,1000000,1000000),(736,1000000,1000000,1000000,1000000),(737,1000000,1000000,1000000,1000000),(738,1000000,1000000,1000000,1000000),(739,1000000,1000000,1000000,1000000),(740,1000000,1000000,1000000,1000000),(741,1000000,1000000,1000000,1000000),(742,1000000,1000000,1000000,1000000),(743,1000000,1000000,1000000,1000000),(744,1000000,1000000,1000000,1000000),(745,1000000,1000000,1000000,1000000),(746,1000000,1000000,1000000,1000000),(747,1000000,1000000,1000000,1000000),(748,1000000,1000000,1000000,1000000),(749,1000000,1000000,1000000,1000000),(750,1000000,1000000,1000000,1000000),(751,1000000,1000000,1000000,1000000),(752,1000000,1000000,1000000,1000000),(753,1000000,1000000,1000000,1000000),(754,1000000,1000000,1000000,1000000),(755,1000000,1000000,1000000,1000000),(756,1000000,1000000,1000000,1000000),(757,1000000,1000000,1000000,1000000),(758,1000000,1000000,1000000,1000000),(759,1000000,1000000,1000000,1000000),(760,1000000,1000000,1000000,1000000),(761,1000000,1000000,1000000,1000000),(762,1000000,1000000,1000000,1000000),(763,1000000,1000000,1000000,1000000),(764,1000000,1000000,1000000,1000000),(765,1000000,1000000,1000000,1000000),(766,1000000,1000000,1000000,1000000),(767,1000000,1000000,1000000,1000000),(768,1000000,1000000,1000000,1000000),(769,1000000,1000000,1000000,1000000),(770,1000000,1000000,1000000,1000000),(771,1000000,1000000,1000000,1000000),(772,1000000,1000000,1000000,1000000),(773,1000000,1000000,1000000,1000000),(774,1000000,1000000,1000000,1000000),(775,1000000,1000000,1000000,1000000),(776,1000000,1000000,1000000,1000000),(777,1000000,1000000,1000000,1000000),(778,1000000,1000000,1000000,1000000),(779,1000000,1000000,1000000,1000000),(780,1000000,1000000,1000000,1000000),(781,1000000,1000000,1000000,1000000),(782,1000000,1000000,1000000,1000000),(783,1000000,1000000,1000000,1000000),(784,1000000,1000000,1000000,1000000),(785,1000000,1000000,1000000,1000000),(786,1000000,1000000,1000000,1000000),(787,1000000,1000000,1000000,1000000),(788,1000000,1000000,1000000,1000000),(789,1000000,1000000,1000000,1000000),(790,1000000,1000000,1000000,1000000),(791,1000000,1000000,1000000,1000000),(792,1000000,1000000,1000000,1000000),(793,1000000,1000000,1000000,1000000),(794,1000000,1000000,1000000,1000000),(795,1000000,1000000,1000000,1000000),(796,1000000,1000000,1000000,1000000),(797,1000000,1000000,1000000,1000000),(798,1000000,1000000,1000000,1000000),(799,1000000,1000000,1000000,1000000),(800,1000000,1000000,1000000,1000000),(801,1000000,1000000,1000000,1000000),(802,1000000,1000000,1000000,1000000),(803,1000000,1000000,1000000,1000000),(804,1000000,1000000,1000000,1000000),(805,1000000,1000000,1000000,1000000),(806,1000000,1000000,1000000,1000000),(807,1000000,1000000,1000000,1000000),(808,1000000,1000000,1000000,1000000),(809,1000000,1000000,1000000,1000000),(810,1000000,1000000,1000000,1000000),(811,1000000,1000000,1000000,1000000),(812,1000000,1000000,1000000,1000000),(813,1000000,1000000,1000000,1000000),(814,1000000,1000000,1000000,1000000),(815,1000000,1000000,1000000,1000000),(816,1000000,1000000,1000000,1000000),(817,1000000,1000000,1000000,1000000),(818,1000000,1000000,1000000,1000000),(819,1000000,1000000,1000000,1000000),(820,1000000,1000000,1000000,1000000),(821,1000000,1000000,1000000,1000000),(822,1000000,1000000,1000000,1000000),(823,1000000,1000000,1000000,1000000),(824,1000000,1000000,1000000,1000000),(825,1000000,1000000,1000000,1000000),(826,1000000,1000000,1000000,1000000),(827,1000000,1000000,1000000,1000000),(828,1000000,1000000,1000000,1000000),(829,1000000,1000000,1000000,1000000),(830,1000000,1000000,1000000,1000000),(831,1000000,1000000,1000000,1000000),(832,1000000,1000000,1000000,1000000),(833,1000000,1000000,1000000,1000000),(834,1000000,1000000,1000000,1000000),(835,1000000,1000000,1000000,1000000),(836,1000000,1000000,1000000,1000000),(837,1000000,1000000,1000000,1000000),(838,1000000,1000000,1000000,1000000),(839,1000000,1000000,1000000,1000000),(840,1000000,1000000,1000000,1000000),(841,1000000,1000000,1000000,1000000),(842,1000000,1000000,1000000,1000000),(843,1000000,1000000,1000000,1000000),(844,1000000,1000000,1000000,1000000),(845,1000000,1000000,1000000,1000000),(846,1000000,1000000,1000000,1000000),(847,1000000,1000000,1000000,1000000),(848,1000000,1000000,1000000,1000000),(849,1000000,1000000,1000000,1000000),(850,1000000,1000000,1000000,1000000),(851,1000000,1000000,1000000,1000000),(852,1000000,1000000,1000000,1000000),(853,1000000,1000000,1000000,1000000),(854,1000000,1000000,1000000,1000000),(855,1000000,1000000,1000000,1000000),(856,1000000,1000000,1000000,1000000),(857,1000000,1000000,1000000,1000000),(858,1000000,1000000,1000000,1000000),(859,1000000,1000000,1000000,1000000),(860,1000000,1000000,1000000,1000000),(861,1000000,1000000,1000000,1000000),(862,1000000,1000000,1000000,1000000),(863,1000000,1000000,1000000,1000000),(864,1000000,1000000,1000000,1000000),(865,1000000,1000000,1000000,1000000),(866,1000000,1000000,1000000,1000000),(867,1000000,1000000,1000000,1000000),(868,1000000,1000000,1000000,1000000),(869,1000000,1000000,1000000,1000000),(870,1000000,1000000,1000000,1000000),(871,1000000,1000000,1000000,1000000),(872,1000000,1000000,1000000,1000000),(873,1000000,1000000,1000000,1000000),(874,1000000,1000000,1000000,1000000),(875,1000000,1000000,1000000,1000000),(876,1000000,1000000,1000000,1000000),(877,1000000,1000000,1000000,1000000),(878,1000000,1000000,1000000,1000000),(879,1000000,1000000,1000000,1000000),(880,1000000,1000000,1000000,1000000),(881,1000000,1000000,1000000,1000000),(882,1000000,1000000,1000000,1000000),(883,1000000,1000000,1000000,1000000),(884,1000000,1000000,1000000,1000000),(885,1000000,1000000,1000000,1000000),(886,1000000,1000000,1000000,1000000),(887,1000000,1000000,1000000,1000000),(888,1000000,1000000,1000000,1000000),(889,1000000,1000000,1000000,1000000),(890,1000000,1000000,1000000,1000000),(891,1000000,1000000,1000000,1000000),(892,1000000,1000000,1000000,1000000),(893,1000000,1000000,1000000,1000000),(894,1000000,1000000,1000000,1000000),(895,1000000,1000000,1000000,1000000),(896,1000000,1000000,1000000,1000000),(897,1000000,1000000,1000000,1000000),(898,1000000,1000000,1000000,1000000),(899,1000000,1000000,1000000,1000000),(900,1000000,1000000,1000000,1000000),(901,1000000,1000000,1000000,1000000),(902,1000000,1000000,1000000,1000000),(903,1000000,1000000,1000000,1000000),(904,1000000,1000000,1000000,1000000),(905,1000000,1000000,1000000,1000000),(906,1000000,1000000,1000000,1000000),(907,1000000,1000000,1000000,1000000),(908,1000000,1000000,1000000,1000000),(909,1000000,1000000,1000000,1000000),(910,1000000,1000000,1000000,1000000),(911,1000000,1000000,1000000,1000000),(912,1000000,1000000,1000000,1000000),(913,1000000,1000000,1000000,1000000),(914,1000000,1000000,1000000,1000000),(915,1000000,1000000,1000000,1000000),(916,1000000,1000000,1000000,1000000),(917,1000000,1000000,1000000,1000000),(918,1000000,1000000,1000000,1000000),(919,1000000,1000000,1000000,1000000),(920,1000000,1000000,1000000,1000000),(921,1000000,1000000,1000000,1000000),(922,1000000,1000000,1000000,1000000),(923,1000000,1000000,1000000,1000000),(924,1000000,1000000,1000000,1000000),(925,1000000,1000000,1000000,1000000),(926,1000000,1000000,1000000,1000000),(927,1000000,1000000,1000000,1000000),(928,1000000,1000000,1000000,1000000),(929,1000000,1000000,1000000,1000000),(930,1000000,1000000,1000000,1000000),(931,1000000,1000000,1000000,1000000),(932,1000000,1000000,1000000,1000000),(933,1000000,1000000,1000000,1000000),(934,1000000,1000000,1000000,1000000),(935,1000000,1000000,1000000,1000000),(936,1000000,1000000,1000000,1000000),(937,1000000,1000000,1000000,1000000),(938,1000000,1000000,1000000,1000000),(939,1000000,1000000,1000000,1000000),(940,1000000,1000000,1000000,1000000),(941,1000000,1000000,1000000,1000000),(942,1000000,1000000,1000000,1000000),(943,1000000,1000000,1000000,1000000),(944,1000000,1000000,1000000,1000000),(945,1000000,1000000,1000000,1000000),(946,1000000,1000000,1000000,1000000),(947,1000000,1000000,1000000,1000000),(948,1000000,1000000,1000000,1000000),(949,1000000,1000000,1000000,1000000),(950,1000000,1000000,1000000,1000000),(951,1000000,1000000,1000000,1000000),(952,1000000,1000000,1000000,1000000),(953,1000000,1000000,1000000,1000000),(954,1000000,1000000,1000000,1000000),(955,1000000,1000000,1000000,1000000),(956,1000000,1000000,1000000,1000000),(957,1000000,1000000,1000000,1000000),(958,1000000,1000000,1000000,1000000),(959,1000000,1000000,1000000,1000000),(960,1000000,1000000,1000000,1000000),(961,1000000,1000000,1000000,1000000),(962,1000000,1000000,1000000,1000000),(963,1000000,1000000,1000000,1000000),(964,1000000,1000000,1000000,1000000),(965,1000000,1000000,1000000,1000000),(966,1000000,1000000,1000000,1000000),(967,1000000,1000000,1000000,1000000),(968,1000000,1000000,1000000,1000000),(969,1000000,1000000,1000000,1000000),(970,1000000,1000000,1000000,1000000),(971,1000000,1000000,1000000,1000000),(972,1000000,1000000,1000000,1000000),(973,1000000,1000000,1000000,1000000),(974,1000000,1000000,1000000,1000000),(975,1000000,1000000,1000000,1000000),(976,1000000,1000000,1000000,1000000),(977,1000000,1000000,1000000,1000000),(978,1000000,1000000,1000000,1000000),(979,1000000,1000000,1000000,1000000),(980,1000000,1000000,1000000,1000000),(981,1000000,1000000,1000000,1000000),(982,1000000,1000000,1000000,1000000),(983,1000000,1000000,1000000,1000000),(984,1000000,1000000,1000000,1000000),(985,1000000,1000000,1000000,1000000),(986,1000000,1000000,1000000,1000000),(987,1000000,1000000,1000000,1000000),(988,1000000,1000000,1000000,1000000),(989,1000000,1000000,1000000,1000000),(990,1000000,1000000,1000000,1000000),(991,1000000,1000000,1000000,1000000),(992,1000000,1000000,1000000,1000000),(993,1000000,1000000,1000000,1000000),(994,1000000,1000000,1000000,1000000),(995,1000000,1000000,1000000,1000000),(996,1000000,1000000,1000000,1000000),(997,1000000,1000000,1000000,1000000),(998,1000000,1000000,1000000,1000000),(999,1000000,1000000,1000000,1000000),(1000,1000000,1000000,1000000,1000000),(1001,1000000,1000000,1000000,1000000),(1002,1000000,1000000,1000000,1000000),(1003,1000000,1000000,1000000,1000000),(1004,1000000,1000000,1000000,1000000),(1005,1000000,1000000,1000000,1000000),(1006,1000000,1000000,1000000,1000000),(1007,1000000,1000000,1000000,1000000),(1008,1000000,1000000,1000000,1000000),(1009,1000000,1000000,1000000,1000000),(1010,1000000,1000000,1000000,1000000),(1011,1000000,1000000,1000000,1000000),(1012,1000000,1000000,1000000,1000000),(1013,1000000,1000000,1000000,1000000),(1014,1000000,1000000,1000000,1000000),(1015,1000000,1000000,1000000,1000000),(1016,1000000,1000000,1000000,1000000),(1017,1000000,1000000,1000000,1000000),(1018,1000000,1000000,1000000,1000000),(1019,1000000,1000000,1000000,1000000),(1020,1000000,1000000,1000000,1000000),(1021,1000000,1000000,1000000,1000000),(1022,1000000,1000000,1000000,1000000),(1023,1000000,1000000,1000000,1000000),(1024,1000000,1000000,1000000,1000000),(1025,1000000,1000000,1000000,1000000),(1026,1000000,1000000,1000000,1000000),(1027,1000000,1000000,1000000,1000000),(1028,1000000,1000000,1000000,1000000),(1029,1000000,1000000,1000000,1000000),(1030,1000000,1000000,1000000,1000000),(1031,1000000,1000000,1000000,1000000),(1032,1000000,1000000,1000000,1000000),(1033,1000000,1000000,1000000,1000000),(1034,1000000,1000000,1000000,1000000),(1035,1000000,1000000,1000000,1000000),(1036,1000000,1000000,1000000,1000000),(1037,1000000,1000000,1000000,1000000),(1038,1000000,1000000,1000000,1000000),(1039,1000000,1000000,1000000,1000000),(1040,1000000,1000000,1000000,1000000),(1041,1000000,1000000,1000000,1000000),(1042,1000000,1000000,1000000,1000000),(1043,1000000,1000000,1000000,1000000),(1044,1000000,1000000,1000000,1000000),(1045,1000000,1000000,1000000,1000000),(1046,1000000,1000000,1000000,1000000),(1047,1000000,1000000,1000000,1000000),(1048,1000000,1000000,1000000,1000000),(1049,1000000,1000000,1000000,1000000),(1050,1000000,1000000,1000000,1000000),(1051,1000000,1000000,1000000,1000000),(1052,1000000,1000000,1000000,1000000),(1053,1000000,1000000,1000000,1000000),(1054,1000000,1000000,1000000,1000000),(1055,1000000,1000000,1000000,1000000),(1056,1000000,1000000,1000000,1000000),(1057,1000000,1000000,1000000,1000000),(1058,1000000,1000000,1000000,1000000),(1059,1000000,1000000,1000000,1000000),(1060,1000000,1000000,1000000,1000000),(1061,1000000,1000000,1000000,1000000),(1062,1000000,1000000,1000000,1000000),(1063,1000000,1000000,1000000,1000000),(1064,1000000,1000000,1000000,1000000),(1065,1000000,1000000,1000000,1000000),(1066,1000000,1000000,1000000,1000000),(1067,1000000,1000000,1000000,1000000),(1068,1000000,1000000,1000000,1000000),(1069,1000000,1000000,1000000,1000000),(1070,1000000,1000000,1000000,1000000),(1071,1000000,1000000,1000000,1000000),(1072,1000000,1000000,1000000,1000000),(1073,1000000,1000000,1000000,1000000),(1074,1000000,1000000,1000000,1000000),(1075,1000000,1000000,1000000,1000000),(1076,1000000,1000000,1000000,1000000),(1077,1000000,1000000,1000000,1000000),(1078,1000000,1000000,1000000,1000000),(1079,1000000,1000000,1000000,1000000),(1080,1000000,1000000,1000000,1000000),(1081,1000000,1000000,1000000,1000000),(1082,1000000,1000000,1000000,1000000),(1083,1000000,1000000,1000000,1000000),(1084,1000000,1000000,1000000,1000000),(1085,1000000,1000000,1000000,1000000),(1086,1000000,1000000,1000000,1000000),(1087,1000000,1000000,1000000,1000000),(1088,1000000,1000000,1000000,1000000),(1089,1000000,1000000,1000000,1000000),(1090,1000000,1000000,1000000,1000000),(1091,1000000,1000000,1000000,1000000),(1092,1000000,1000000,1000000,1000000),(1093,1000000,1000000,1000000,1000000),(1094,1000000,1000000,1000000,1000000),(1095,1000000,1000000,1000000,1000000),(1096,1000000,1000000,1000000,1000000),(1097,1000000,1000000,1000000,1000000),(1098,1000000,1000000,1000000,1000000),(1099,1000000,1000000,1000000,1000000),(1100,1000000,1000000,1000000,1000000),(1101,1000000,1000000,1000000,1000000),(1102,1000000,1000000,1000000,1000000),(1103,1000000,1000000,1000000,1000000),(1104,1000000,1000000,1000000,1000000),(1105,1000000,1000000,1000000,1000000),(1106,1000000,1000000,1000000,1000000),(1107,1000000,1000000,1000000,1000000),(1108,1000000,1000000,1000000,1000000),(1109,1000000,1000000,1000000,1000000),(1110,1000000,1000000,1000000,1000000),(1111,1000000,1000000,1000000,1000000),(1112,1000000,1000000,1000000,1000000),(1113,1000000,1000000,1000000,1000000),(1114,1000000,1000000,1000000,1000000),(1115,1000000,1000000,1000000,1000000),(1116,1000000,1000000,1000000,1000000),(1117,1000000,1000000,1000000,1000000),(1118,1000000,1000000,1000000,1000000),(1119,1000000,1000000,1000000,1000000),(1120,1000000,1000000,1000000,1000000),(1121,1000000,1000000,1000000,1000000),(1122,1000000,1000000,1000000,1000000),(1123,1000000,1000000,1000000,1000000),(1124,1000000,1000000,1000000,1000000),(1125,1000000,1000000,1000000,1000000),(1126,1000000,1000000,1000000,1000000),(1127,1000000,1000000,1000000,1000000),(1128,1000000,1000000,1000000,1000000),(1129,1000000,1000000,1000000,1000000),(1130,1000000,1000000,1000000,1000000),(1131,1000000,1000000,1000000,1000000),(1132,1000000,1000000,1000000,1000000),(1133,1000000,1000000,1000000,1000000),(1134,1000000,1000000,1000000,1000000),(1135,1000000,1000000,1000000,1000000),(1136,1000000,1000000,1000000,1000000),(1137,1000000,1000000,1000000,1000000),(1138,1000000,1000000,1000000,1000000),(1139,1000000,1000000,1000000,1000000),(1140,1000000,1000000,1000000,1000000),(1141,1000000,1000000,1000000,1000000),(1142,1000000,1000000,1000000,1000000),(1143,1000000,1000000,1000000,1000000),(1144,1000000,1000000,1000000,1000000),(1145,1000000,1000000,1000000,1000000),(1146,1000000,1000000,1000000,1000000),(1147,1000000,1000000,1000000,1000000),(1148,1000000,1000000,1000000,1000000),(1149,1000000,1000000,1000000,1000000),(1150,1000000,1000000,1000000,1000000),(1151,1000000,1000000,1000000,1000000),(1152,1000000,1000000,1000000,1000000),(1153,1000000,1000000,1000000,1000000),(1154,1000000,1000000,1000000,1000000),(1155,1000000,1000000,1000000,1000000),(1156,1000000,1000000,1000000,1000000),(1157,1000000,1000000,1000000,1000000),(1158,1000000,1000000,1000000,1000000),(1159,1000000,1000000,1000000,1000000),(1160,1000000,1000000,1000000,1000000),(1161,1000000,1000000,1000000,1000000),(1162,1000000,1000000,1000000,1000000),(1163,1000000,1000000,1000000,1000000),(1164,1000000,1000000,1000000,1000000),(1165,1000000,1000000,1000000,1000000),(1166,1000000,1000000,1000000,1000000),(1167,1000000,1000000,1000000,1000000),(1168,1000000,1000000,1000000,1000000),(1169,1000000,1000000,1000000,1000000),(1170,1000000,1000000,1000000,1000000),(1171,1000000,1000000,1000000,1000000),(1172,1000000,1000000,1000000,1000000),(1173,1000000,1000000,1000000,1000000),(1174,1000000,1000000,1000000,1000000),(1175,1000000,1000000,1000000,1000000),(1176,1000000,1000000,1000000,1000000),(1177,1000000,1000000,1000000,1000000),(1178,1000000,1000000,1000000,1000000),(1179,1000000,1000000,1000000,1000000),(1180,1000000,1000000,1000000,1000000),(1181,1000000,1000000,1000000,1000000),(1182,1000000,1000000,1000000,1000000),(1183,1000000,1000000,1000000,1000000),(1184,1000000,1000000,1000000,1000000),(1185,1000000,1000000,1000000,1000000),(1186,1000000,1000000,1000000,1000000),(1187,1000000,1000000,1000000,1000000),(1188,1000000,1000000,1000000,1000000),(1189,1000000,1000000,1000000,1000000),(1190,1000000,1000000,1000000,1000000),(1191,1000000,1000000,1000000,1000000),(1192,1000000,1000000,1000000,1000000),(1193,1000000,1000000,1000000,1000000),(1194,1000000,1000000,1000000,1000000),(1195,1000000,1000000,1000000,1000000),(1196,1000000,1000000,1000000,1000000),(1197,1000000,1000000,1000000,1000000),(1198,1000000,1000000,1000000,1000000),(1199,1000000,1000000,1000000,1000000),(1200,1000000,1000000,1000000,1000000),(1201,1000000,1000000,1000000,1000000),(1202,1000000,1000000,1000000,1000000),(1203,1000000,1000000,1000000,1000000),(1204,1000000,1000000,1000000,1000000),(1205,1000000,1000000,1000000,1000000),(1206,1000000,1000000,1000000,1000000),(1207,1000000,1000000,1000000,1000000),(1208,1000000,1000000,1000000,1000000),(1209,1000000,1000000,1000000,1000000),(1210,1000000,1000000,1000000,1000000),(1211,1000000,1000000,1000000,1000000),(1212,1000000,1000000,1000000,1000000),(1213,1000000,1000000,1000000,1000000),(1214,1000000,1000000,1000000,1000000),(1215,1000000,1000000,1000000,1000000),(1216,1000000,1000000,1000000,1000000),(1217,1000000,1000000,1000000,1000000),(1218,1000000,1000000,1000000,1000000),(1219,1000000,1000000,1000000,1000000),(1220,1000000,1000000,1000000,1000000),(1221,1000000,1000000,1000000,1000000),(1222,1000000,1000000,1000000,1000000),(1223,1000000,1000000,1000000,1000000),(1224,1000000,1000000,1000000,1000000),(1225,1000000,1000000,1000000,1000000),(1226,1000000,1000000,1000000,1000000),(1227,1000000,1000000,1000000,1000000),(1228,1000000,1000000,1000000,1000000),(1229,1000000,1000000,1000000,1000000),(1230,1000000,1000000,1000000,1000000),(1231,1000000,1000000,1000000,1000000),(1232,1000000,1000000,1000000,1000000),(1233,1000000,1000000,1000000,1000000),(1234,1000000,1000000,1000000,1000000),(1235,1000000,1000000,1000000,1000000),(1236,1000000,1000000,1000000,1000000),(1237,1000000,1000000,1000000,1000000),(1238,1000000,1000000,1000000,1000000),(1239,1000000,1000000,1000000,1000000),(1240,1000000,1000000,1000000,1000000),(1241,1000000,1000000,1000000,1000000),(1242,1000000,1000000,1000000,1000000),(1243,1000000,1000000,1000000,1000000),(1244,1000000,1000000,1000000,1000000),(1245,1000000,1000000,1000000,1000000),(1246,1000000,1000000,1000000,1000000),(1247,1000000,1000000,1000000,1000000),(1248,1000000,1000000,1000000,1000000),(1249,1000000,1000000,1000000,1000000),(1250,1000000,1000000,1000000,1000000),(1251,1000000,1000000,1000000,1000000),(1252,1000000,1000000,1000000,1000000),(1253,1000000,1000000,1000000,1000000),(1254,1000000,1000000,1000000,1000000),(1255,1000000,1000000,1000000,1000000),(1256,1000000,1000000,1000000,1000000),(1257,1000000,1000000,1000000,1000000),(1258,1000000,1000000,1000000,1000000),(1259,1000000,1000000,1000000,1000000),(1260,1000000,1000000,1000000,1000000),(1261,1000000,1000000,1000000,1000000),(1262,1000000,1000000,1000000,1000000),(1263,1000000,1000000,1000000,1000000),(1264,1000000,1000000,1000000,1000000),(1265,1000000,1000000,1000000,1000000),(1266,1000000,1000000,1000000,1000000),(1267,1000000,1000000,1000000,1000000),(1268,1000000,1000000,1000000,1000000),(1269,1000000,1000000,1000000,1000000),(1270,1000000,1000000,1000000,1000000),(1271,1000000,1000000,1000000,1000000),(1272,1000000,1000000,1000000,1000000),(1273,1000000,1000000,1000000,1000000),(1274,1000000,1000000,1000000,1000000),(1275,1000000,1000000,1000000,1000000),(1276,1000000,1000000,1000000,1000000),(1277,1000000,1000000,1000000,1000000),(1278,1000000,1000000,1000000,1000000),(1279,1000000,1000000,1000000,1000000),(1280,1000000,1000000,1000000,1000000),(1281,1000000,1000000,1000000,1000000),(1282,1000000,1000000,1000000,1000000),(1283,1000000,1000000,1000000,1000000),(1284,1000000,1000000,1000000,1000000),(1285,1000000,1000000,1000000,1000000),(1286,1000000,1000000,1000000,1000000),(1287,1000000,1000000,1000000,1000000),(1288,1000000,1000000,1000000,1000000),(1289,1000000,1000000,1000000,1000000),(1290,1000000,1000000,1000000,1000000),(1291,1000000,1000000,1000000,1000000),(1292,1000000,1000000,1000000,1000000),(1293,1000000,1000000,1000000,1000000),(1294,1000000,1000000,1000000,1000000),(1295,1000000,1000000,1000000,1000000),(1296,1000000,1000000,1000000,1000000),(1297,1000000,1000000,1000000,1000000),(1298,1000000,1000000,1000000,1000000),(1299,1000000,1000000,1000000,1000000),(1300,1000000,1000000,1000000,1000000),(1301,1000000,1000000,1000000,1000000),(1302,1000000,1000000,1000000,1000000),(1303,1000000,1000000,1000000,1000000),(1304,1000000,1000000,1000000,1000000),(1305,1000000,1000000,1000000,1000000),(1306,1000000,1000000,1000000,1000000),(1307,1000000,1000000,1000000,1000000),(1308,1000000,1000000,1000000,1000000),(1309,1000000,1000000,1000000,1000000),(1310,1000000,1000000,1000000,1000000),(1311,1000000,1000000,1000000,1000000),(1312,1000000,1000000,1000000,1000000),(1313,1000000,1000000,1000000,1000000),(1314,1000000,1000000,1000000,1000000),(1315,1000000,1000000,1000000,1000000),(1316,1000000,1000000,1000000,1000000),(1317,1000000,1000000,1000000,1000000),(1318,1000000,1000000,1000000,1000000),(1319,1000000,1000000,1000000,1000000),(1320,1000000,1000000,1000000,1000000),(1321,1000000,1000000,1000000,1000000),(1322,1000000,1000000,1000000,1000000),(1323,1000000,1000000,1000000,1000000),(1324,1000000,1000000,1000000,1000000),(1325,1000000,1000000,1000000,1000000),(1326,1000000,1000000,1000000,1000000),(1327,1000000,1000000,1000000,1000000),(1328,1000000,1000000,1000000,1000000),(1329,1000000,1000000,1000000,1000000),(1330,1000000,1000000,1000000,1000000),(1331,1000000,1000000,1000000,1000000),(1332,1000000,1000000,1000000,1000000),(1333,1000000,1000000,1000000,1000000),(1334,1000000,1000000,1000000,1000000),(1335,1000000,1000000,1000000,1000000),(1336,1000000,1000000,1000000,1000000),(1337,1000000,1000000,1000000,1000000),(1338,1000000,1000000,1000000,1000000),(1339,1000000,1000000,1000000,1000000),(1340,1000000,1000000,1000000,1000000),(1341,1000000,1000000,1000000,1000000),(1342,1000000,1000000,1000000,1000000),(1343,1000000,1000000,1000000,1000000),(1344,1000000,1000000,1000000,1000000),(1345,1000000,1000000,1000000,1000000),(1346,1000000,1000000,1000000,1000000),(1347,1000000,1000000,1000000,1000000),(1348,1000000,1000000,1000000,1000000),(1349,1000000,1000000,1000000,1000000),(1350,1000000,1000000,1000000,1000000),(1351,1000000,1000000,1000000,1000000),(1352,1000000,1000000,1000000,1000000),(1353,1000000,1000000,1000000,1000000),(1354,1000000,1000000,1000000,1000000),(1355,1000000,1000000,1000000,1000000),(1356,1000000,1000000,1000000,1000000),(1357,1000000,1000000,1000000,1000000),(1358,1000000,1000000,1000000,1000000),(1359,1000000,1000000,1000000,1000000),(1360,1000000,1000000,1000000,1000000),(1361,1000000,1000000,1000000,1000000),(1362,1000000,1000000,1000000,1000000),(1363,1000000,1000000,1000000,1000000),(1364,1000000,1000000,1000000,1000000),(1365,1000000,1000000,1000000,1000000),(1366,1000000,1000000,1000000,1000000),(1367,1000000,1000000,1000000,1000000),(1368,1000000,1000000,1000000,1000000),(1369,1000000,1000000,1000000,1000000),(1370,1000000,1000000,1000000,1000000),(1371,1000000,1000000,1000000,1000000),(1372,1000000,1000000,1000000,1000000),(1373,1000000,1000000,1000000,1000000),(1374,1000000,1000000,1000000,1000000),(1375,1000000,1000000,1000000,1000000),(1376,1000000,1000000,1000000,1000000),(1377,1000000,1000000,1000000,1000000),(1378,1000000,1000000,1000000,1000000),(1379,1000000,1000000,1000000,1000000),(1380,1000000,1000000,1000000,1000000),(1381,1000000,1000000,1000000,1000000),(1382,1000000,1000000,1000000,1000000),(1383,1000000,1000000,1000000,1000000),(1384,1000000,1000000,1000000,1000000),(1385,1000000,1000000,1000000,1000000),(1386,1000000,1000000,1000000,1000000),(1387,1000000,1000000,1000000,1000000),(1388,1000000,1000000,1000000,1000000),(1389,1000000,1000000,1000000,1000000),(1390,1000000,1000000,1000000,1000000),(1391,1000000,1000000,1000000,1000000),(1392,1000000,1000000,1000000,1000000),(1393,1000000,1000000,1000000,1000000),(1394,1000000,1000000,1000000,1000000),(1395,1000000,1000000,1000000,1000000),(1396,1000000,1000000,1000000,1000000),(1397,1000000,1000000,1000000,1000000),(1398,1000000,1000000,1000000,1000000),(1399,1000000,1000000,1000000,1000000),(1400,1000000,1000000,1000000,1000000),(1401,1000000,1000000,1000000,1000000),(1402,1000000,1000000,1000000,1000000),(1403,1000000,1000000,1000000,1000000),(1404,1000000,1000000,1000000,1000000),(1405,1000000,1000000,1000000,1000000),(1406,1000000,1000000,1000000,1000000),(1407,1000000,1000000,1000000,1000000),(1408,1000000,1000000,1000000,1000000),(1409,1000000,1000000,1000000,1000000),(1410,1000000,1000000,1000000,1000000),(1411,1000000,1000000,1000000,1000000),(1412,1000000,1000000,1000000,1000000),(1413,1000000,1000000,1000000,1000000),(1414,1000000,1000000,1000000,1000000),(1415,1000000,1000000,1000000,1000000),(1416,1000000,1000000,1000000,1000000),(1417,1000000,1000000,1000000,1000000),(1418,1000000,1000000,1000000,1000000),(1419,1000000,1000000,1000000,1000000),(1420,1000000,1000000,1000000,1000000),(1421,1000000,1000000,1000000,1000000),(1422,1000000,1000000,1000000,1000000),(1423,1000000,1000000,1000000,1000000),(1424,1000000,1000000,1000000,1000000),(1425,1000000,1000000,1000000,1000000),(1426,1000000,1000000,1000000,1000000),(1427,1000000,1000000,1000000,1000000),(1428,1000000,1000000,1000000,1000000),(1429,1000000,1000000,1000000,1000000),(1430,1000000,1000000,1000000,1000000),(1431,1000000,1000000,1000000,1000000),(1432,1000000,1000000,1000000,1000000),(1433,1000000,1000000,1000000,1000000),(1434,1000000,1000000,1000000,1000000),(1435,1000000,1000000,1000000,1000000),(1436,1000000,1000000,1000000,1000000),(1437,1000000,1000000,1000000,1000000),(1438,1000000,1000000,1000000,1000000),(1439,1000000,1000000,1000000,1000000);

/*Table structure for table `brokenline5min` */

DROP TABLE IF EXISTS `brokenline5min`;

CREATE TABLE `brokenline5min` (
  `position` int(11) NOT NULL,
  `Line1` float DEFAULT NULL,
  `Line2` float DEFAULT NULL,
  `Line3` float DEFAULT NULL,
  `Line4` float DEFAULT NULL,
  `Line5` float DEFAULT NULL,
  `Line6` float DEFAULT NULL,
  `Line7` float DEFAULT NULL,
  PRIMARY KEY (`position`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

/*Data for the table `brokenline5min` */

insert  into `brokenline5min`(`position`,`Line1`,`Line2`,`Line3`,`Line4`,`Line5`,`Line6`,`Line7`) values (0,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(1,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(2,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(3,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(4,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(5,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(6,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(7,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(8,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(9,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(10,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(11,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(12,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(13,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(14,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(15,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(16,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(17,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(18,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(19,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(20,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(21,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(22,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(23,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(24,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(25,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(26,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(27,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(28,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(29,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(30,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(31,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(32,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(33,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(34,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(35,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(36,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(37,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(38,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(39,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(40,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(41,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(42,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(43,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(44,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(45,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(46,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(47,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(48,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(49,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(50,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(51,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(52,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(53,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(54,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(55,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(56,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(57,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(58,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(59,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(60,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(61,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(62,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(63,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(64,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(65,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(66,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(67,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(68,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(69,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(70,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(71,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(72,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(73,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(74,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(75,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(76,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(77,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(78,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(79,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(80,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(81,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(82,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(83,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(84,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(85,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(86,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(87,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(88,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(89,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(90,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(91,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(92,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(93,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(94,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(95,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(96,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(97,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(98,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(99,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(100,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(101,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(102,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(103,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(104,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(105,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(106,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(107,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(108,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(109,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(110,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(111,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(112,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(113,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(114,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(115,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(116,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(117,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(118,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(119,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(120,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(121,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(122,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(123,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(124,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(125,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(126,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(127,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(128,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(129,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(130,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(131,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(132,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(133,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(134,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(135,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(136,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(137,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(138,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(139,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(140,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(141,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(142,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(143,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(144,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(145,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(146,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(147,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(148,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(149,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(150,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(151,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(152,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(153,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(154,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(155,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(156,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(157,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(158,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(159,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(160,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(161,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(162,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(163,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(164,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(165,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(166,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(167,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(168,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(169,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(170,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(171,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(172,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(173,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(174,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(175,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(176,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(177,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(178,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(179,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(180,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(181,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(182,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(183,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(184,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(185,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(186,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(187,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(188,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(189,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(190,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(191,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(192,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(193,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(194,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(195,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(196,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(197,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(198,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(199,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(200,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(201,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(202,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(203,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(204,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(205,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(206,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(207,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(208,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(209,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(210,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(211,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(212,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(213,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(214,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(215,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(216,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(217,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(218,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(219,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(220,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(221,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(222,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(223,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(224,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(225,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(226,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(227,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(228,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(229,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(230,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(231,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(232,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(233,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(234,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(235,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(236,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(237,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(238,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(239,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(240,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(241,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(242,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(243,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(244,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(245,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(246,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(247,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(248,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(249,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(250,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(251,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(252,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(253,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(254,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(255,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(256,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(257,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(258,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(259,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(260,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(261,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(262,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(263,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(264,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(265,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(266,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(267,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(268,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(269,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(270,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(271,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(272,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(273,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(274,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(275,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(276,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(277,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(278,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(279,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(280,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(281,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(282,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(283,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(284,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(285,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(286,1000000,1000000,1000000,1000000,1000000,1000000,1000000),(287,1000000,1000000,1000000,1000000,1000000,1000000,1000000);

/*Table structure for table `index` */

DROP TABLE IF EXISTS `index`;

CREATE TABLE `index` (
  `id` int(11) NOT NULL,
  `tableName` varchar(50) NOT NULL,
  `columnName` varchar(50) NOT NULL,
  `described` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

/*Data for the table `index` */

insert  into `index`(`id`,`tableName`,`columnName`,`described`) values (1000,'brokenline1sec','position','1秒 坐标点标记'),(1001,'brokenline1sec','line1','1秒 第1条折线'),(1002,'brokenline1sec','line2','1秒 第2条折线'),(1003,'brokenline1sec','line3','1秒 第3条折线'),(1004,'brokenline1sec','line4','1秒 第4条折线'),(2000,'brokenline5min','position','5分钟 坐标点标记'),(2001,'brokenline5min','line1','5分钟 第1条折线'),(2002,'brokenline5min','line2','5分钟 第2条折线'),(2003,'brokenline5min','line3','5分钟 第3条折线'),(2004,'brokenline5min','line4','5分钟 第4条折线'),(2005,'brokenline5min','line5','5分钟 第5条折线'),(2006,'brokenline5min','line6','5分钟 第6条折线'),(2007,'brokenline5min','line7','5分钟 第7条折线'),(3000,'piegraph3part','id','3部分 饼图序号'),(3001,'piegraph3part','pie1','3部分饼图 第1部分'),(3002,'piegraph3part','pie2','3部分饼图 第2部分'),(3003,'piegraph3part','pie3','3部分饼图 第3部分'),(4000,'piegraph5part','id','5部分 饼图序号'),(4001,'piegraph5part','pie1','5部分饼图 第1部分'),(4002,'piegraph5part','pie2','5部分饼图 第2部分'),(4003,'piegraph5part','pie3','5部分饼图 第3部分'),(4004,'piegraph5part','pie4','5部分饼图 第4部分'),(4005,'piegraph5part','pie5','5部分饼图 第5部分');

/*Table structure for table `piegraph3part` */

DROP TABLE IF EXISTS `piegraph3part`;

CREATE TABLE `piegraph3part` (
  `id` int(11) NOT NULL,
  `pie1` float DEFAULT NULL,
  `pie2` float DEFAULT NULL,
  `pie3` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

/*Data for the table `piegraph3part` */

insert  into `piegraph3part`(`id`,`pie1`,`pie2`,`pie3`) values (1000,100,200,300),(1001,152,215,254);

/*Table structure for table `piegraph5part` */

DROP TABLE IF EXISTS `piegraph5part`;

CREATE TABLE `piegraph5part` (
  `id` int(11) NOT NULL,
  `pie1` float DEFAULT NULL,
  `pie2` float DEFAULT NULL,
  `pie3` float DEFAULT NULL,
  `pie4` float DEFAULT NULL,
  `pie5` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

/*Data for the table `piegraph5part` */

insert  into `piegraph5part`(`id`,`pie1`,`pie2`,`pie3`,`pie4`,`pie5`) values (2000,100,200,300,400,500),(2001,125,245,243,452,542);

/* Procedure structure for procedure `autoBrokenLineInsert1sec` */

/*!50003 DROP PROCEDURE IF EXISTS  `autoBrokenLineInsert1sec` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `autoBrokenLineInsert1sec`()
begin
declare i int;
set i = 0;
while i < 60 * 24 do
insert into brokenline1sec values(i, 999999.9, 999999.9, 999999.9, 999999.9);
set i = i + 1;
end while; 
end */$$
DELIMITER ;

/* Procedure structure for procedure `autoBrokenLineInsert5min` */

/*!50003 DROP PROCEDURE IF EXISTS  `autoBrokenLineInsert5min` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `autoBrokenLineInsert5min`()
begin
declare i int;
set i = 0;
while i < 12 * 24 do
insert into brokenline5min values(i, 1000000, 1000000, 1000000, 1000000, 1000000, 1000000, 1000000);
set i = i + 1;
end while; 
end */$$
DELIMITER ;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

存储过程源码：

delimiter $$
create procedure autoBrokenLineInsert1sec()
begin
declare i int;
set i = 0;
while i < 60 * 24 do
insert into brokenline1sec values(i, 1000000, 1000000, 1000000, 1000000);
set i = i + 1;
end while; 
end $$
delimiter ;

call autoBrokenLineInsert1sec;

delimiter $$
create procedure autoBrokenLineInsert5min()
begin
declare i int;
set i = 0;
while i < 12 * 24 do
insert into brokenline5min values(i, 1000000, 1000000, 1000000, 1000000, 1000000, 1000000, 1000000);
set i = i + 1;
end while; 
end $$
delimiter ;

call autoBrokenLineInsert5min;

 

C/C++学习路线总结与分享
dvlinker的技术专栏
10-07 10万+
C/C++学习路线总结与分享
零基础入门 全角度解读企业主流数据库MySQL8.0 --- 复习笔记
争当做一个有趣的人
03-09 1690
〖课程介绍〗: 本课程遵循“用户体验至上”的原则，不敢说设计精良，尽善尽美，却也竭尽全力去锻造良好的学习体验。包含三方面，（1）设计之初：遵循“有教无类，教学相长”的原则；（2）学习路线：采用循序渐进的教学模式，带你从了解到熟悉，到掌握，到精通，最后到深谙；（3）学习内容：课程遵循前沿性，以当前最新企业主流的MySQL8.0版本为内容。以“实用”为课程最高宗旨，带你搞定工作中SQL优化 痛点问题，最终的目的是：助力个人能力的快速提升，最终服务工作所需，助你占据不可替代的一席之地 第1章 【蓦然回首】开篇..
数据库设计思路
君莫笑
10-31 7539
数据库设计追求逐渐完善，不求一下子完美
数据库表设计 基本思路
大鹏
01-27 6336
好的数据结构会影响速度。好的数据库表设计会影响数据库操作效率。特别是数据多的时候，如果表的结构不好的话操作的时候条件（where后的内容）会变的非常复杂。 SQL是关系数据库中用到的一种语言。所以，为了简化SQL，表的关系（内部和外部）要尽量设计的合理。 下面有几个可以参照的步骤： 1）找出那个表要描述的东西； 2）列出你想通过这个表得到的相关信息的列表； 3）通过上面的信息列表，将信息
数据库的设计思路
weixin_47257428的博客
10-28 1477
一，数据库的设计原则遵循数据库设计的三个范式的要求，可以允许有少量的数据冗余。一即对属性的原子性约束，要求属性具有原子性，不可再分解。 二即对记录的惟一性约束，要求记录有惟一标识，即实体的惟一性。 三即对字段冗余性的约束，即任何字段不能由其他字段派生出来，它要求字段没有冗余。但是如果设计的数据库完全满足这三个范式的话，又未必是最好的数据库，为了提高数据库的运行效率，我们必须降低范式要求，允许数据库有少量冗余数据。 主键与外键的设置 为了确保数据在数据库中的唯一性和关联性以及完整性，有必要对数据库进行主键
数据库课程设计你应该有的思路
02-16
在进行课程设计时，可以参考“数据库课程设计思路.pdf”文档，它可能提供了详细的设计步骤和指导。而“注意.pdf”、“注意下.pdf”和“说明.pdf”可能包含了设计过程中的注意事项和具体实施细节。务必仔细阅读这些...
MySQL数据库进阶知识大全-InnoDB存储引擎-索引B+Tree数据结构-sql调优-InnoDB底层原理深入-锁-MVCC机制-事务CAID底层实现
最新发布
2301_77557950的博客
10-08 2261
MySQL数据库进阶学习笔记分享-内容超级齐全-简单易懂！！
MySQL索引为什么使用B+树，而不用二叉树、红黑树、哈希表、B树？
折叠伞的博客
12-26 2347
索引是帮助MySQL高效获取数据的排好序的数据结构。 索引数据结构： 1.二叉树2.红黑树3.Hash表4.B-Tree。
数据库设计流程和思路
06-09
该文档为自己所做，由于见识短浅，水平有限，如有不足，请另寻贵资！
关于数据库的设计的一点思路
weixin_30920597的博客
04-20 182
2.5 年前，就学过php,不过当时并没有学好，导致对数据库的设计是一知半解的；一直都知道php 在设计时，使用的是 MVC 模式，但是什么是MVC ,却没有搞懂过。前两天重新翻看了以前的笔记，才明白MVC 的思路 现在自己设计一个 关于汽车保险的详情数据库,先来分析一下：数据库中需要有id,有保险公司，保险公司是可以选择的，再一个是保险分类，主要有三种质保类别，1是综合质保方案，2是...
数据库设计好的设计思路
somdip的博客
06-21 808
1、用户 --- 用户角色 ---- 角色 ---- 角色菜单 ------ 菜单 ---------------- 经典五张表 加入系统后 用户 - 用户角色- 角色 - 角色菜单 - 菜单 （系统标识） - 系统 用户可登陆多个系统 2 、标签表 不在分属那个表关联 做统一的对外标识 如用户表 用户表中生成 存入 uuid， 标...
（三）数据库设计 思路
zang1206的博客
02-22 365
数据库设计流程 需求分析 - 设计ER图 - 转换成 数据库模型图 和 数据表 开发流程模型 瀑布模型 -数据库设计 螺旋模型 - 网站开发 E-R图 也称实体-联系图(Entity Relationship Diagram)， 提供了表示实体类型、属性和联系的方法，用来描述现实世界的概念模型 实体 属性 主键属性用下划线标 允许有空值 复合属性 多值...
mysql的数据库设计思路
zhangerfeng333的博客
09-09 505
数据库设计 注意事项 为了查询效率，可以做冗余字段设计（空间换时间的思想，属于一种反范式设计） 字段类型的选择 整型的存储大小与显示大小 mysql的字段，unsigned int(3), 和unsinged int(6), 能存储的数值范围是否相同。如果不同，分别是多大？ 我们建立下面这张表： CREATE TABLE `test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `i1` int(3) unsigned z
谈谈微服务的数据库设计思路吧
bishe_teacher的博客
07-23 475
谈谈微服务的数据库设计思路吧 单独的数据库 微服务设计的一个关键是数据库设计，基本原则是每个服务都有自己单独的数据库，而且只有微服务本身可以访问这个数据库。它是基于下面三个原因。 优化服务接口：微服务之间的接口越小越好，最好只有服务调用接口（RPC或消息），没有其他接口。如果微服务不能独享自己的数据库，那么数据库也变成了接口的一部分，这大大拓展了接口范围。 错误诊断：生产环境中的错误大部分都是和数据库有关的，要么是数据出了问题，要么是数据库的使用方式出了问题。当你不能完全控制数据库的访问时，会有各种各样的错
数据库架构设计思路、表结构设计方面思路
xtc_liu的博客
07-18 890
数据库架构设计说明--表结构设计说明--数据库访问设计说明、数据库物理存储设计说明。
数据库设计
qq_58055172的博客
07-25 483
数据库
一文彻底解析数据库设计思路
苏州程序大白的博客
11-26 2572
一文彻底解析数据库设计思路目录????博主介绍实体关系(Entity-Relationship, E-R)概念E-R 模型实体 (Entity)属性 (Attribute)联系(Relationships)将实体和属性转换为关系规则一规则二规则三: N-N Relationships规则四: N-1 Relationships规则五&六: 1-1 RelationshipsE-R 图更多的细节基数 (Cardinality of Entities Participation in a Relatio
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

IT1995

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值