InDev

Thank you subenji99 Thnk you very much guys my problem it's to the past now

Where is the database please ?

Because i made infos of players in a table, then i created a command for add columns, who works perfectly now, but in the beginning i had a bug, the command must set a default valor (a valor that i choose ( 0 ) ) but the command did'nt set this valor that's why i want to delete it it takes place for just a test columns... I repaired the create command, but you can see that the delete does'nt work ^^ So if i can use anything else except recreate the table, i'll try it.

No it send me the same Error message I think the MTA'SQL does not recognize the DROP COLUMN and he think it is an syntax error so if there is any other way to delete a Column i'll try it...

Hi, I'm new in MTA Scripting i learned some things and i have a problem with an SQL Query : Here is the script: function SQLDelColumnInTable( thePlayer, commandName, tabletarget, column ) local query = executeSQLQuery( "ALTER TABLE ? DROP COLUMN ? ", tabletarget, column ) if(query)then outputChatBox( "Column: " ..column.. " in table "..tabletarget.." has been deleted !", thePlayer ) else outputChatBox( "The column can't be deleted, an error has occured", thePlayer ) end end addCommandHandler( "deletecolumn", SQLDelColumnInTable ) And When i test my command the Server send me this error message: ERROR: Database query failed: near "DROP": syntax error Can someone help me ?