Getting values from the database
Type: expression
Syntax:
[sqlsk] mysql %database object% query %query% and get [string] %string%Examples:
Table Kings
kingid
name
1
Noob
2
Notch
3
Jeb_
4
ProGamer
 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
Was this helpful?