Hello Everyone,
How can I set current schema to a particular schema/database in phpmyAdmin to ensure I execute queries on tables within that schema only.
I tried with USE <Schema_Name> . This is not working.
Regards,
SG
Discussion posts and replies are publicly visible
If this is only about executing some statements manually, then just navigate to the desired schema/table in the left hand panel.
As stefan said, you can simply click on the schema name and also verify the same as in the image below.
Thanks Stefan,
Is it possible through query?
Surjit
What are you trying to do? If your current/desired schema is selected (which you can see at the top) then you can simply run any script without the need to define database name.
Still if you want to define database name in your query then just simply but it before the table name.
Example:
SELECT * FROM SCHEMA_NAME.TABLE_NAME WHERE 1;
Hi surjitg,You could try this if you want to be more efficient in your SQL code. (set once, call always):USE Appian;SELECT * FROM USER;SELECT * FROM COUNTRY;.....Hope it helps,Rómulo