search

mazinsw / nsMySQL

NSIS MySQL execute SQL command from NSIS installer with unicode and x64 support
MIT License
3 stars 0 forks source link

It's missing an example script #2

Closed almendieta closed 4 years ago

almendieta commented 4 years ago

Hi. It's missing a usage example of this plugin, ideally a script detailing how to use it. Have an example of issue I've found trying to use it: SELECT ID FROM CLIENTS WHERE ID='" $R3 "'" This query won't work!

mazinsw commented 4 years ago

Try using single quotes around or escape double quotes

almendieta commented 4 years ago

Thanks a lot for your answer Francimar! I'm double quoted a simple query (and each parameter in the call) and it seems work correctly, because the logfile throws a message: No database selected. How can I select the DB please? And how can I retrieve the data so can use it in NSIS? Obrigado in advance for your answer! :)

Al.

Si vas a reenviar este mensaje, ten en cuenta lo siguiente: 1..- Borra la dirección del remitente así como cualquier otra dirección que aparezca en el cuerpo del mensaje. 2.- Protege las direcciones de los destinatarios colocando las mismas en la línea CCO (COPIA OCULTA), de esta forma evitamos los mensajes SPAM.

El dom., 22 mar. 2020 a las 8:24, Francimar Alves (notifications@github.com) escribió:

Try using single quotes around or escape double quotes

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mazinsw/nsMySQL/issues/2#issuecomment-602200064, or unsubscribe https://github.com/notifications/unsubscribe-auth/AC2HQEVBAA5MJVLO3B64MFDRIYGP3ANCNFSM4LRFYZPQ .

mazinsw commented 4 years ago

Append USE my_db; at beginning of your script to select my_db database

You cannot retrieve data using this plugin, it was made for database creation and seeds