Skip to main content

MySQL: This stored procedure inserts 'empty' rows into a specified table

This stored procedure accepts two arguments: a table name and a row count. It inserts the specified number of rows into the specified table. Of course, all columns in the table must either have default values or allow NULL.




DROP PROCEDURE InsertDimension;
DELIMITER $$
CREATE PROCEDURE InsertDimension(IN TableName VARCHAR(50), IN NumRows INT)
    BEGIN
        DECLARE i INT;
        SET i = 1;
        SET @sql_text = concat('INSERT INTO ', TableName, ' VALUES ()' );
        PREPARE stmt FROM @sql_text;
        START TRANSACTION;
        WHILE i <= NumRows DO
            EXECUTE stmt;
            SET i = i + 1;
        END WHILE;
        COMMIT;
        DEALLOCATE PREPARE stmt;
    END$$
DELIMITER ;

Comments

Popular posts from this blog

Running 2560x1080 on LG 29UM57-P on an old MacBook Pro OSX El Capitan

Yes. A mid-2011 MacBook Pro running OSX El Capitan can drive a 2560x1080 monitor via HDMI. I was not able to get 60 Hz working. I am settling with 53 Hz. I tried many settings before finding something that works. The refresh rate seems fine to me. Maybe the text could be clearer but for a $200 monitor running this resolution, I'll take it. Apple MacBook 2015 retina resolution is 2560 x 1800. Consider buying a better monitor that may literally give you fewer headaches. Install  SwitchResX Follow the instructions for disabling SIP After rebooting, run SwitchResX via System Preferences Select your LG monitor Click Custom Resolutions Click the + icon  Enter these settings  ( source ) Exit SwitchResX and save Reboot Run SwitchResX via System Preferences Select your LG monitor Click Current Resolutions Select the 2560x1080, 53 Hz setting Enable SIP If you discover better settings, please leave a comment.