Would this cause any problem ?

[Rommeo]

Let's say my user_table has following fields;

 

username name surname country

 

but I'm just inserting to one field and skipping the rest:

 

$query = "insert into user_table ( username ) VALUES ( $username) ";

mysql_query($query);

 

Does inserting data like this cause any unwanted problems ?

[The Little Guy]

It shouldn't, but your table should have default values, such as null.

[Rommeo]

It shouldn't, but your table should have default values, such as null.

if my table does not have default or null values ? what kind of problem would I face ?

[fenway]

Depends if you're running in strict mode or not.