SQLite Question
#3

Quote:
Originally Posted by cessil
Посмотреть сообщение
ALTER TABLE `<table name>` ADD COLUMN `<column name>` <type INTEGER/TEXT> <optional DEFAULT(value)>

example:
ALTER TABLE `users` ADD COLUMN `kills` INTEGER DEFAULT(0)

I recommend using slice's BUD for sqlite, it makes it a lot easier to use without having to worry about so much things.
In BUD you could just do BUD::VerifyColumn("kills", BUD::TYPE_NUMBER );
Thanks! Pretty good advice. I'll look into it!
Reply


Messages In This Thread
SQLite Question - by iTzZh - 25.11.2012, 05:48
Re: SQLite Question - by cessil - 25.11.2012, 07:20
Re: SQLite Question - by iTzZh - 25.11.2012, 07:51

Forum Jump:


Users browsing this thread: 3 Guest(s)