1.3(2)

如下代码不符合规范：

 

insert into t_tablename1

 

          ( column1, column2, column3, column4, column5,

 

            column6, column7 …

 

          )

 

     select column1_value, column2_value, column3_value,

 

            column4_value, column5_value, column6_value,

 

            column7_value …

 

       from t_tablename2;

 

应编写如下：

 

insert into t_tablename1

 

          ( column1, column2, column3, column4,

 

            column5, column6, column7 …

 

           )

 

     select column1_value, column2_value, column3_value, column4_value,

 

            column5_value, column6_value, column7_value …

 

       from t_tablename2;