UnitedForums.co.uk - View Single Post - stored procedure

jc297 · 7th June 2008, 10:57 PM

For ref: finally found out what I was doing wrong. The syntax of INTO for multiple columns is

SELECT siteURL, siteRef INTO ositeURL, ositeRef FROM ...

Which is clearly stated in MySQL documentation (MySQL :: MySQL 5.1 Reference Manual :: 21.2.7.3 SELECT ... INTO Statement)

Feel soooo foolish

.

7th June 2008, 10:57 PM	#4 (permalink)
jc297 Registered User Join Date: Feb 2004 Location: London Posts: 27	For ref: finally found out what I was doing wrong. The syntax of INTO for multiple columns is SELECT siteURL, siteRef INTO ositeURL, ositeRef FROM ... Which is clearly stated in MySQL documentation (MySQL :: MySQL 5.1 Reference Manual :: 21.2.7.3 SELECT ... INTO Statement) Feel soooo foolish .