Query help
#1

I'm trying to make multiple query's because I don't want my line to be too long but when I do it this way it doesn't even work
Код:
new query[200];
  	db_query(Database, "CREATE TABLE IF NOT EXISTS Users (Userid INTEGER PRIMARY KEY AUTOINCREMENT, Username VARCHAR(24) COLLATE NOCASE, password VARCHAR(129)");
	strcat(query, "Admins INTEGER DEFAULT 0 NOT NULL, Premium INTEGER DEFAULT 0 NOT NULL, Money INTEGER DEFAULT 0 NOT NULL, Score INTEGER DEFAULT 0 NOT NULL");
	strcat(query,"Kills INTEGER DEFAULT 0 NOT NULL, Deaths INTEGER DEFAULT 0 NOT NULL, KD INTEGER DEFAULT 0 NOT NULL");
Any tips?
Reply
#2

Quote:
Originally Posted by Hybris
Посмотреть сообщение
Any tips?
Don't hardcode DDL statements.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)