Adding new SQLite column to an existen database, help! - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Adding new SQLite column to an existen database, help! (
/showthread.php?tid=330169)
Adding new SQLite column to an existen database, help! -
Edvin - 31.03.2012
Hi.
I try to adding a new column in a SQLite database, withou removin the database. I try with ALTER TABLE method, but it don't work, or myself was do something wrong. I do this:
Code:
db_query( PDB, "ALTER TABLE `Accounts` ADD `TestingLine` TEXT AFTER `Password`" );
or ... where is needed to added ALTER TABLE syntax to work ok?