SQL create column if not exists
 

What query to use if I want to create a column if it does not exist?

Re: SQL create column if not exists
 

Re: SQL create column if not exists
 

Table already exists so the new column is not added.

Re: SQL create column if not exists
 

This will just overwrite data, but if you want it like this, you have to do all the columns + the ones you want to add.

It's because 1 slot = 1 column, eg. FetchInt(column number). We don't want to switch places on the column numbers.

Re: SQL create column if not exists
 

You shouldn't dynamically create columns, that means your database design is wrong.

If you explain what kind of data you're trying to store, someone can probably give you the correct solution.

Re: SQL create column if not exists
 

@DJ Tsunami
My concern was to add columns to a database which is used by another plugin.

Re: SQL create column if not exists
 

It was wrong I wanted to fix it through code without wiping all data..

Re: SQL create column if not exists
 

Try this: CREATE TABLE tablename (column), of course you cann add more columns (column, column)

Re: SQL create column if not exists
 

@Ermert1992

That's what I said... >:[

Re: SQL create column if not exists
 

You can use ALTER TABLE to add new columns.

ALTER TABLE tablename ADD columname columntype

The more rows your table has, the longer ALTER TABLE will take.

Edit: Having said that, this is an operation you should be doing manually and as a one-off thing.