mySQL "INSERT statement" split inte several lines possible?

jari_stockholm
05-23-2010, 02:25 PM
Hi.

(This is just a example of an longer insert statement)
Can i split it like this example below?
or is there some complicationt that might occur when doing like this?

INSERT INTO Cars (manufacturer, model
top_speed, acceleration)
VALUES ('Bmw', 'M3',
'250', '4,8 ',)

gibra
05-23-2010, 02:52 PM
No problems.

Dim sSql As String
sSQL = "INSERT INTO Cars (manufacturer, model "
sSQL = sSQL & " top_speed, acceleration) "
sSQL = sSQL & " VALUES ('Bmw', 'M3', "
sSQL = sSQL & " '250', '4,8 ',) "

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum