The shell function can do this. I don't know if there could be a limit
to the length of the shell command though.
Working example:
on mouseUp
put shortfilepath("C:\Program Files\MySQL\MySQL Server
5.6\bin\mysql.exe") into myFilePath
-- the following line contains 2 insert commands
put "insert into testtable (name) values ('Anne'); insert into
testtable (name) values ('Belinda')" into mySql
put myFilePath && "-uUSERNAME -pPASSWORD test -e" && quote & mySql &
quote into myQuery
get shell(myQuery)
end mouseUp
Kind regards,
Mark Schonewille
http://economy-x-talk.com
https://www.facebook.com/marksch
Buy the most extensive book on the
LiveCode language:
http://livecodebeginner.economy-x-talk.com
Op 29-Dec-17 om 21:53 schreef Matthias Rebbe via use-livecode:
Hi,
i need to update regularly about 2000 rows/records of a MySQL table with
Livecode Server.
What is better?
Executing the 2000 update commands in one take using revexecuteSQL
or should i execute one update command after each other within a repeat loop?
What do you think?
Regards,
Matthias
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
