How to specify a database

[zxuewu]

I checkout all the file, I did not find an example on how to specify database. So I try to use Sphinxql() function directly, like

cl := manticore.NewClient()
cl.SetServer("localhost", 9312)
cl.Open()
foo, err := cl.Sphinxql("select * from kgall; show meta;")
fmt.Println(foo, err)

But I got " [ERROR 1064 (42000): unknown local table(s) 'kgall' in search request] " for response.
What should I do to do a query job.

[zxuewu]

kgall is a table of the database that I want to specify.

[sanikolaev]

I did not find an example on how to specify database

Manticore doesn't support databases yet, all tables are just in the same database. You don't have to specify it.

But I got " [ERROR 1064 (42000): unknown local table(s) 'kgall' in search request] " for response.

Make sure table kgall exists: mysql -P9306 -h0 -e "show tables"