Hi All,
I'm struggling to understand the best way to access a mySQL database. I would like to execute SQL commands but just cant seem to get it to work. I use the following approach via entitystore;
connectionMYSQL =
DatabaseReference[{"Backend" -> "mysql", "Port" -> 3306,
"Host" -> "localhost", "Username" -> "root", "Password" -> "",
"Name" -> "socialdata"}]
rdb = RelationalDatabase@connectionMYSQL
es = EntityStore@rdb
I can see the tables in EntityStore but trying to get data via EntityValue doesn't seem to work. The following fails:
EntityValue["table1", {"col1", "col2....
The other way of doing this is:
conn = DatabaseReference[
URL["mysql://root@localhost:3306/socialdata"]]
SQLExecute[conn, "SELECT * FROM ....
which does not work!
Ideally I would like to execute SQL commands. are there any good examples showing this working (especially for a local database)?