Question

when a column value is skipped in and insert command, which value is inserted in the table..

IP.... ​

Answer 1

Using INSERT (col1, col2) VALUES (1, 2) is not an option, because I can not know the amount of columns during runtime. It's all calculated from user input.

Thus, I need to skip the first column (id, PRIMARY KEY auto_increment) when inserting.

Answer 2

The Inserted column value is inserted in the table if it is not already there.

Explanation:

• The default value is 1. When a column value is skipped in and insert command, which value is inserted in the table.
• If there is no default value, the current value of the column is inserted.
• The value 2 is inserted in the table if the value is not there.
• In this case, the value "2" is inserted into the table with the value "1"'.
• This text is inserted in the table within default column value.
• A string of "one thousand" characters or more will be truncated.
• The value 2 is inserted in the table if the value is not there.
• The value "value1" is inserted into the table when the value "value2" is not found.