SHOW FULL COLUMNS FROM

  • Petr Barták

    (@vtelenak)


    10 years, 9 months ago

    Hallo,

    insert into function translate_general($query) in file \wp-content\mu-plugins\wp-db-abstraction\translations\sqlsrv\translations.php this code:

    // SHOW FULL COLUMNS
if ( stripos($query, 'SHOW FULL COLUMNS FROM ') === 0 ) {
     $end_pos = strlen($query);
     $param = substr($query, 23, $end_pos - 23);
     $param = "'". trim($param, "'") . "'";
     $query = 'SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ' . $param;
}

    After WP can be update to last version (4.2.4) and work on IIS and MS SQL on Windows. I love It 🙂

    https://wordpress.org/plugins/wordpress-database-abstraction/

The topic ‘SHOW FULL COLUMNS FROM’ is closed to new replies.