Wordpress database query inserting column

Asked Jan 22 '18 at 15:25

Active Jan 22 '18 at 15:27

Viewed 364 times

Trying to alter a database in Wordpress and adding new columns to it. Here is the code:

function new_columns_users(){

    global $wpdb;
    $charset_collate = $wpdb->get_charset_collate();
    $table_name = $wpdb->prefix . "users";

    $sql = "ALTER TABLE $table_name ADD (
        gender varchar(10),
        test varchar(10)
        ) $charset_collate;";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    dbDelta( $sql );
}

This doesn't add the new columns in the database. I feel like I tried everything, what is wrong with this query?

edited Jan 22 '18 at 15:27

Julien Rousé

1,115
1
15
30

asked Jan 22 '18 at 15:25

Willem van der Veen

33,665
16
190
155

do you execute the query somewhere in your code? – Lelio Faieta Jan 22 '18 at 15:31
Possible duplicate of [alter table add MULTIPLE columns AFTER column1](https://stackoverflow.com/questions/17541312/alter-table-add-multiple-columns-after-column1) – aynber Jan 22 '18 at 15:32
yes this gets executed already checked with an error log – Willem van der Veen Jan 22 '18 at 15:32
Your syntax is wrong. – aynber Jan 22 '18 at 15:32
checked out the other answer but still not sure how to place $charset_collate in the answer they gave. – Willem van der Veen Jan 22 '18 at 15:39
You shouldn't need it. That's only really used for creating new tables. – aynber Jan 22 '18 at 15:52

Wordpress database query inserting column

0 Answers0