mysql values - Printable Version

mysql values - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql values (/showthread.php?tid=126518)

mysql values - JOliver - 08.02.2010

Hello Here,

Im trying i add mysql values to the mysql DB.

when i add

Code:

 mysql_query("CREATE TABLE IF NOT EXISTS `"TABLENAME"`(`id` int(11) NOT NULL auto_increment PRIMARY KEY,`Username` varchar(30) NOT NULL,`Password` varchar(50) NOT NULL,`Money` int(10) NOT NULL default '0',`Level` int(10) NOT NULL default '1',`Hours` int(10) NOT NULL default '0',`Respect` int(10) NOT NULL default '0',`Skin` int(10) NOT NULL default '175',`Member` int(10) NOT NULL default '0',`Leader` int(10) NOT NULL default '0',`Job` int(10) NOT NULL default '0')",CREATE_THREAD_ID,5);

its all works ok

but when i add one more value i get an error

Code:

error 075: input line too long (after substitutions)

Thanks for helping

JOliver

Re: mysql values - Faraday - 08.02.2010

Do it in phpmyadmin, alot easier. or delete some stuff like auto_increment, or primary key, and set those in phpmyadmin