check if column exists

[evilpuncker]

I'm not that good regarding SQL queries so I'm here to ask something like:

if column xxxx exists on login table { execute sql query to add that column } end; (pseudocode)

PS: I know how to check if table exists but I'm kinda confused to do the same with columns

 

[Mumbles]

You could use something with query_sql/query_logsql like:

query_sql("IF COL_LENGTH('table_name','column_name') IS NOT NULL BEGIN /*insert update query here*/ END");

 

[evilpuncker]

not worked

 

[Angelmelody]

if(query_sql("select count(name) from syscolumns where id=(select id from sysobjects where name='table name')and name='column name'")){


}else{


}
 

 

[evilpuncker]

what if my user doesn't have access to syscolumns and sysobjects?

I've seen several examples at google search but none worked :/ always syntax error

I've seen a npc at old eA forum that did the same thing that I'm trying to do but sadly can't find it anymore :/

 

[Angelmelody]

what if my user doesn't have access to syscolumns and sysobjects?

I've seen several examples at google search but none worked :/ always syntax error

I've seen a npc at old eA forum that did the same thing that I'm trying to do but sadly can't find it anymore :/

you are right  , there is  a more simple  way to check

if(query_sql ("select column from `table`"))

 dispbottom "exist";

else

 dispbottom "not exist";

}

 

[evilpuncker]

thanks my dear <3 but after creating the table it always throw an warning at map server

if(query_sql("select `stats` from `login`"))

[Warning]: script:query_sql: Too many columns, discarding last 1 columns.

 

[Emistry]

if(query_sql("select `stats` from `login`",.@stats))
try

 

[evilpuncker]

thank you all, issue solved!

 

[Angelmelody]

thanks my dear <3 but after creating the table it always throw an warning at map server

if(query_sql("select `stats` from `login`"))

[Warning]: script:query_sql: Too many columns, discarding last 1 columns.

Haha ~

,  forgot to put array variable to save the select output