Multiple Row Insert : VistaDB Support Center

B

Ben Gehring

started a topic almost 4 years ago

I'm trying to write a query to insert multiple rows. I saw this thead (http://support.vistadb.com/support/discussions/topics/4000336627) which says the SQL server syntax isn't supported, but using unions work. I've tried this with 5.7 and 6 beta. Am I doing something wrong?

INSERT INTO States ([Name], [Abbreviation])
SELECT 'Alabama', 'AL' UNION
SELECT 'Alaska', 'AK' UNION
SELECT 'Arizona', 'AZ' UNION
SELECT 'Arkansas', 'AR' UNION
SELECT 'California', 'CA' UNION
SELECT 'Colorado', 'CO' UNION
SELECT 'Connecticut', 'CT' UNION
SELECT 'Delaware', 'DE' UNION
SELECT 'Florida', 'FL' UNION
SELECT 'Georgia', 'GA' UNION
SELECT 'Hawaii', 'HI' UNION
SELECT 'Idaho', 'ID' UNION
SELECT 'Illinois', 'IL' UNION
SELECT 'Indiana', 'IN' UNION
SELECT 'Iowa', 'AI' UNION
SELECT 'Kansas', 'KS' UNION
SELECT 'Kentucky', 'KY' UNION
SELECT 'Lousiana', 'LA' UNION
SELECT 'Maine', 'ME' UNION
SELECT 'Maryland', 'MD' UNION
SELECT 'Massachusetts', 'MA' UNION
SELECT 'Michigan', 'MI' UNION
SELECT 'Mississippi', 'MS' UNION
SELECT 'Montana', 'MT' UNION
SELECT 'Nebraska', 'NE' UNION
SELECT 'Nevada', 'NV' UNION
SELECT 'New Hampshire', 'NH' UNION
SELECT 'New Jersey', 'NJ' UNION
SELECT 'New Mexico', 'NM' UNION
SELECT 'New York', 'NY' UNION
SELECT 'North Carolina', 'NC' UNION
SELECT 'North Dakota', 'ND' UNION
SELECT 'Ohio', 'OH' UNION
SELECT 'Oklahoma', 'OK' UNION
SELECT 'Oregon', 'OR' UNION
SELECT 'Pennsylvania', 'PA' UNION
SELECT 'Rhode Island', 'RI' UNION
SELECT 'South Carolina', 'SC' UNION
SELECT 'South Dakota', 'SD' UNION
SELECT 'Tennessee', 'TN' UNION
SELECT 'Texas', 'TX' UNION
SELECT 'Utah', 'UT' UNION
SELECT 'Vermont', 'VT' UNION
SELECT 'Virginia', 'VA' UNION
SELECT 'Washington', 'WA' UNION
SELECT 'West Virginia', 'WV' UNION
SELECT 'Wisconsin', 'WI' UNION
SELECT 'Wyoming', 'WY' UNION

The error I get is:

Line #: 11; Column #: 1