[Mysql]Too Long Query (Idea Please)
#10

And if this is the registration query, you could set the default values for some columns(ID=autoincrement, HP, starting money, level, etc) and only insert that ones that are particular as: playername, password, etc.

And you'll only have to do

Код:
format(Query, sizeof(Query), "INSERT INTO `members` (`playername`, `password`, `email`) VALUES ( '%s', '%s', '%s'",name,pass, email);
This way, the colomns that you don't specify, are automatically filled with the default values.
Reply


Messages In This Thread
[Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:34
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 21:36
Re: [Mysql]Too Long Query (Idea Please) - by DVDK - 28.12.2010, 21:41
Re: [Mysql]Too Long Query (Idea Please) - by _rAped - 28.12.2010, 21:41
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:43
Re: [Mysql]Too Long Query (Idea Please) - by _rAped - 28.12.2010, 21:46
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:46
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 21:48
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:55
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 22:01

Forum Jump:


Users browsing this thread: 3 Guest(s)