# 大转盘测试

**Repository Path**: symok/large_turntable_test

## Basic Information

- **Project Name**: 大转盘测试
- **Description**: No description available
- **Primary Language**: PHP
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 1
- **Created**: 2018-04-01
- **Last Updated**: 2021-01-02

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 大转盘测试

## MYSQL数据

CREATE TABLE `dazhuanpan_jiangpin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jiangpin` varchar(255) NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  `shuliang` int(11) unsigned zerofill NOT NULL,
  `zhuangtai` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;



CREATE TABLE `dazhuanpan_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) NOT NULL,
  `jiangpin_id` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;

##添加数据
DELIMITER //
CREATE PROCEDURE text2()
BEGIN
declare p decimal (10)  default 0 ;
dd:loop
INSERT INTO dazhuanpan_user(id,phone,jiangpin_id)VALUE
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5'),
('','18710733333','5');
set p = p+10;
if p = 10000 then leave dd;
END if;
END loop dd;
END
//