SQL : Insert a large number of records using SQL

Learning Use the below mentioned query to insert multiple records this is the fastest way available. -- don't add "UNION ALL" statement on the last line INSERT INTO mytable(companyid, category, sub, catalogueref) SELECT '10197', 'cat', 'sub', '123' U...