which one to use and why?
Posted: Fri May 11, 2007 1:17 am
Hello forums !!
I had seen the Insert Query can be done in two ways like
1>
2>
I want to know
which one is more effective ??
Thanks in advance to all of you
I had seen the Insert Query can be done in two ways like
1>
Code: Select all
INSERT INTO table_name (field1,field2 etc) VALUES ('value1','value2' etc)Code: Select all
INSERT INTO table_name SET field1 = 'value1', field2 = 'value2' etcwhich one is more effective ??
Thanks in advance to all of you