Labels

Apache Hadoop (3) ASP.NET (2) AWS S3 (2) Batch Script (3) BigQuery (21) BlobStorage (1) C# (3) Cloudera (1) Command (2) Data Model (3) Data Science (1) Django (1) Docker (1) ETL (7) Google Cloud (5) GPG (2) Hadoop (2) Hive (3) Luigi (1) MDX (21) Mongo (3) MYSQL (3) Pandas (1) Pentaho Data Integration (5) PentahoAdmin (13) Polybase (1) Postgres (1) PPS 2007 (2) Python (13) R Program (1) Redshift (3) SQL 2016 (2) SQL Error Fix (18) SQL Performance (1) SQL2012 (7) SQOOP (1) SSAS (20) SSH (1) SSIS (42) SSRS (17) T-SQL (75) Talend (3) Vagrant (1) Virtual Machine (2) WinSCP (1)

Friday, November 19, 2010

MYSQL Stored Procedure to insert data into table

MYSQL Stored Procedure to insert data into table:

DELIMITER $$

DROP PROCEDURE IF EXISTS `sp_InsertTelecount` $$
CREATE PROCEDURE `sp_InsertTelecount`()
BEGIN
          DECLARE x  INT;
            SET x = 1;
            WHILE x  <= 10 DO
             insert into sms_detail(sumID
                    ,StatusFlag
                    ,DC
                    ,Product
                    ,TNAME
                    ,MSGTYPE
                    ,SENDDATE
                    ,OPERATOR
                    ,DELDATE
                    ,DURATION)
             VALUES(1, 'Success', 'VSNL', 'SMPPBOX', 'MBS_143', 'PM',CurDate(), 'AIRNET', Curdate(), '00:01:00');
                       SET  x = x + 1;
                   END WHILE;
           END $$

DELIMITER ;

No comments:

Post a Comment