Why cannot my API access another schema?

Question

When I query

SELECT * FROM INFORMATION_SCHEMA.PARTITIONS;

it returns this error:

CODE[1146] MSG[Table 'EmailRecord.PARTITIONS' doesn't exist].

It works fine with the current schema, but I can't access any other schema.

I managed to access other schema in the workbench.

mysql_query(_conn, "SELECT * FROM INFORMATION_SCHEMA.PARTITIONS;"); and failed. as long as I access other schema with ".", it will actually access current schema. — wa56, May 30 '17 at 14:46
Try to remove the semicolon at the end of the query inside the query string and see if it works then — Ctx, May 30 '17 at 14:49
I think, the problem is out of scope what you show here, you will probably need to provide more context for a helpful answer. The message is exactly what you would expect when performing the query `SELECT * FROM PARTITIONS` while using the database EmailRecord. — Ctx, May 30 '17 at 14:56
GOT IT, Remove MYSQL_OPT_RECONNECT when mysql_real_connect(). thanks Ctx. — wa56, May 30 '17 at 15:04
I tried to show you how formatting and choosing proper title could enhance your question. — J. Chomel, Jun 02 '17 at 14:41

score 0 · Answer 1 · answered Jun 02 '17 at 14:49

0

This was solved and should be posted as an answer:

OP solution is :

Remove parameter MYSQL_OPT_RECONNECT when mysql_real_connect()

Too bad we don't have more source to chew on and help others, like e.g. here, there...

answered Jun 02 '17 at 14:49

J. Chomel

1 Answers1