Friday, March 25, 2011

SQL Insert command using set option to add records to MySQL table

SQL Insert command using set option to add records to MySQL table

using

Insert into library set book_name='Learning MySQL', author='plus2net group'

is better than

Insert into library(book_name, author) VALUES('Learning MySQL', 'plus2net group')