Getting values from the database

Type: expression

Syntax:

[sqlsk] mysql %database object% query %query% and get [string] %string%

Examples:

Table Kings

 set {_db} to mysql conn for "localhost;minecraft;admin;secretpass"
 set {_q::*} to mysql {_db} query "SELECT * FROM `kings`" and get "name"
 send "All kings: %{_q::*}%" to all players
 // It send: All kings: Noob, Notch, Jeb_ and ProGamer 

Last updated