MYSQL problem
#1

Hey, im pretty new to MYSQL and i have a small question, i hope someone could please help me out.
At the moment im using this code:
Код:
mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(40), score INT(20), money INT(20), level INT(20), vip INT(20), kma INT(20), rank INT(20), kills INT(20), deaths INT(20), muted INT(20), jailed INT(20), frozen INT(20), mutedtimes INT(20), jailedtimes INT(20), frozentimes INT(20), banned INT(20), bannedby VARCHAR(24), logins INT(20), posx INT(20), posy INT(20), posz INT(20), posa INT(20), IP VARCHAR(15) )");
Im wondering how to make it shorter, that it will look like this:
Код:
user VARCHAR(24),
password VARCHAT(40),
smthingelse INT(40),
So basically my question is, how to make each string on a diffrent line?
Reply
#2

Why use that ? If you create the table you don't have to recreate it when you open the server.. soo you could just use it once and save it somewhere if you really want to..
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)