MySQL, input line too long
#10

Quote:
Originally Posted by RyDeR`
View Post
If you're still interested there's another way. Just add '\' where you go to a new line:
pawn Code:
format(query, sizeof(query),
    "INSERT INTO playerdata (user, password, score, money, level, vip, kma, rank, kills, deaths, muted, jailed, \
    frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, cookies, warn1, warn2, warn3, \
    warn1reason, warn2reason, warn3reason, dateregisterd, kickedtimes, restorepos, slapedtimes, posx, posy, \
    posz, posa, IP) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', 017, 0, 0, 0, \
    0, 'No Warn', 'No Warn', 'No Warn', '%s', 0, 0, 0, 0, 0, 0, 0, '%s')"
,
pname, passwordstring, Bannedby, ReggedDate, IP);
mysql_query(query);
Wow thanks a lot that will speed up the query writing speed for sure.

+rep
Reply


Messages In This Thread
MySQL, input line too long - by Markx - 14.08.2011, 10:12
Re: MySQL, input line too long - by robanswe - 14.08.2011, 10:31
Re: MySQL, input line too long - by [HiC]TheKiller - 14.08.2011, 10:38
Re: MySQL, input line too long - by robanswe - 14.08.2011, 11:22
Re: MySQL, input line too long - by Grim_ - 14.08.2011, 11:24
Re: MySQL, input line too long - by Tigerkiller - 14.08.2011, 11:31
Re: MySQL, input line too long - by robanswe - 14.08.2011, 12:52
Re: MySQL, input line too long - by Markx - 15.08.2011, 21:14
Re: MySQL, input line too long - by RyDeR` - 15.08.2011, 22:07
Re: MySQL, input line too long - by robanswe - 16.08.2011, 10:18

Forum Jump:


Users browsing this thread: 2 Guest(s)