Pular para o conteúdo principal

Always specify the columns in an INSERT statement

Specify the columns in an INSERT statement to guarantee that the code won't stop working when a new column is added.

Noncompliant Code Example

insert into tab values (1);

Compliant Solution

insert into tab (col) values (1);