A simple insert query works as : INSERT INTO <table-name> VALUES(val1,val2,val3); and DONE.
Suppose I wanted to insert only into last two columns I will do as : INSERT INTO <table-name>(col2,col3) VALUES(val2,val3);
For less no of columns its not a big deal but what if i have 10 columns and i wanted to add data in only 5 of them.
Like : INSERT INTO <table-name>(col1,col3,col6,col9,col10) VALUES(val1,val3,val6,val9,val10);
Is there any logical or tricky way to reduce this trouble ? Am having a table with 15 columns and sometimes i just need to add data into 7 or 8 columns.