Inserting Data ...

[perlone]

Hello,

I have a table and I want to insert data to it but the only problem is that it's too long. The fields that is. Here's an example:

table: user;

id|name|pass|uname|blah|blah|blah|...

Currently, I need to insert data like the following:

$sql = "insert into user (id,name,pass,...)values('blah')"

Is there anyway I can insert it whithout writing all the fields? Maybe something like insert into user (*)vlaues.

Thanks for your help. There is no Knowledge that is not power.
E-mail: projectnet01@yahoo.com
Companynot done yet)
Status: Currently working with C++ for game developing. And making a musical band.
-Aaron

 

[KarveR]

$sql = "insert into user (id,name,pass,...)values('blah')"
yes .. do it but only add fieds and data for what you want to enter.
$sql = "insert into user (id,name) values ('','me'); ***************************************
Party on, dudes!