[sql] hawk
Viewer
- ERCREATE TEMPORARY TABLE matrixX (
- x INT NOT NULL AUTO_INCREMENT,
- a INT DEFAULT 7, b INT DEFAULT 7, c INT DEFAULT 7,
- d INT DEFAULT 7, e INT DEFAULT 7,
- PRIMARY KEY ( x )
- ) ENGINE=MEMORY AUTO_INCREMENT=100;
- CREATE PROCEDURE drawerX( cursorX INT )
- BEGIN
- SET @strquery = ' SELECT * FROM matrixX ';
- SET @repeatX = 0;
- REPEAT
- SET @repeatX = @repeatX + 1;
- SET @sqlStr = ' ';
- SET @cloop = 0;
- internal: LOOP
- SET @cloop = @cloop + 1;
- IF ( @cloop + @repeatX ) MOD 2 = 0 THEN
- SET @sqlStr = CONCAT( @sqlStr, ' 1 , ' );
- ELSE
- SET @sqlStr = CONCAT( @sqlStr, ' 0 , ' );
- END IF;
- IF @cloop = 5 THEN
- SET @sqlStr = LEFT( @sqlStr , 9 );
- LEAVE internal;
- END IF;
- END LOOP internal;
- SET @stmtexc = CONCAT( 'INSERT INTO matrixX ( a, b, c, d, e ) VALUE ( ' , @sqlStr, ' );' );
- PREPARE stmtexc FROM @stmtexc;
- EXECUTE stmtexc;
- UNTIL @repeatX = cursorX END REPEAT;
- PREPARE stmt FROM @strquery;
- EXECUTE stmt;
- END;
- CALL drawerX( 6 );
Editor
You can edit this paste and save as new:
File Description
- hawk
- Paste Code
- 29 Oct-2020
- 1.97 Kb
You can Share it:
Latest Code Pastes