How to determine which database is selected

by

Just use mysql_query (or mysqli_query, even better, or use PDO, best of all) with:

SELECT DATABASE();

Addendum:

There is much discussion over whether or not FROM DUAL should be included in this or not. On a technical level, it is a holdover from Oracle and can safely be removed. If you are inclined, you can use it as follows:

SELECT DATABASE() FROM DUAL;

That said, it is perhaps important to note, that while FROM DUAL does not actually do anything, it is valid MySQL syntax. From a strict perspective, including braces in a single line conditional in JavaScript also does not do anything, but it is still a valid practice.

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. Why can’t this entry be added because of Foreign Key error?
  3. How to do a regular expression replace in MySQL?
  4. How to solve “Error: MySQL shutdown unexpectedly”?
  5. Count the number of occurrences of a string in a VARCHAR field?
  6. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  7. MySQL AUTO_INCREMENT does not ROLLBACK
  8. How to import a CSV file into a MySQL table
  9. Create new user in MySQL and give it full access to one database
  10. MySQL high CPU usage [closed]
  11. Most efficient way to get table row count
  12. How do I select between the 1st day of the current month and current day in MySQL?
  13. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  14. MySQL Cross Server Select Query
  15. How do I generate nested json objects using mysql native json functions?
  16. Import CSV to MySQL
  17. MySQL TEXT vs BLOB vs CLOB
  18. Getting data for histogram plot
  19. How accurately should I store latitude and longitude?
  20. MySQL: LAST_INSERT_ID() returns 0
  21. Defining Composite Key with Auto Increment in MySQL
  22. mysql Failed to read auto-increment value from storage engine
  23. Alter table if exists or create if doesn’t
  24. How to use Table output from stored MYSQL Procedure
  25. MySQL Alter table causes Error: Invalid use of NULL value
  26. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  27. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  28. Migrating data into Firebase from MySQL
  29. Inventory management with stock options
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment