Set Current Schema - PhpMyAdmin

Question

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

Sanchit Gupta (Xebia) · Answer

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;

Rómulo · Answer

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&oacute;mulo

Set Current Schema - PhpMyAdmin

Top Replies