I'm wondering if it is possible to skip certain fields in the mysql table in a sql statement. Here is what I mean:
I have a table that has the following columns:
Suppose I write the following statement:
mysql_query=("insert db_table (firstname, lastname, phone) VALUES ('$firstname' ,'$lastname', '$phone')");
In the above scenario, I want the statement to insert the above values, and IGNORE the field in "dob" in the database.
Currently, left as is, the dob is check for value and produces the following:
Error: Field 'dob' doesn't have a default value
This may sound a bit unorthodox, but it addresses a critical need at the moment.
I appreciate any thoughts on this!