31.03.2012, 17:08
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:
or ... where is needed to added ALTER TABLE syntax to work ok?
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`" );