"Fossies" - the Fresh Open Source Software Archive

Member "dbdiff-0.2.0/test/modify_procedure/source.sql" (20 Sep 2006, 292 Bytes) of package /linux/privat/old/dbdiff-0.2.0.tgz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE TABLE authors (
    2   `id` int(11) NOT NULL auto_increment,
    3   `name` char(60) NOT NULL,
    4   `address` char(60) NULL,
    5   PRIMARY KEY  (`id`)
    6 ) ENGINE=innodb DEFAULT CHARSET=latin1;
    7 
    8 CREATE PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM authors WHERE id = 2; END;