Rows and Columns

function create_sa_functions() {
    global $wpdb; 
 
    $wpdb->query( " 
        IF NOT EXISTS( select * from sysprocedure where proc_name = 'MD5' ) THEN
            CREATE FUNCTION MD5( str varchar(255) ) 
            RETURNS binary(32)
            BEGIN
                return HASH( str, 'MD5' );
            END;
        END IF;");
 
     $wpdb->query( "
         IF NOT EXISTS( select * from sysprocedure where proc_name = 'UNIX_TIMESTAMP' ) THEN
             CREATE FUNCTION UNIX_TIMESTAMP( dt datetime DEFAULT NULL )
             RETURNS datetime
             BEGIN
                 //Returns UTC data
                 IF dt IS NULL THEN
                     return DATEDIFF( second, '1979-01-01 00:00:00', CURRENT UTC TIMESTAMP )
                 ELSE
                     return DATEDIFF( second, '1979-01-01 00:00:00', DATEADD( minute, -CONNECTION_PROPERTY('TimeZoneAdjustment'), dt) )
                 END IF
             END;
        END IF;");
 
    $wpdb->query( " 
        IF NOT EXISTS( select * from sysprocedure where proc_name = DEFAULTDAYOFMONTHDEFAULT ) THEN
            CREATE FUNCTION DAYOFMONTH( dt datetime )
            RETURNS integer
            BEGIN
                return DAY( datetime );
            END; 
        END IF;");
 
    $wpdb->query( "SET OPTION MAX_STATEMENT_COUNT=0;");
 
    $wpdb->query( "SET OPTION MAX_CURSOR_COUNT=0;");
}