How can you find out the version of the installed mysql?
The version of the installed MySQL server can be found out easily by running the following command from the MySQL prompt. mysql> SHOW VARIABLES LIKE “%version%”;
| Is This Answer Correct ? | 0 Yes | 0 No |
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
How do I select a database in mysql workbench?
How do I install mysql on windows 7?
How do I check mysql version?
What is max_used_connections in mysql?
Is mysql a scripting language?
What is regex in mysql?
What is a text delimiter?
How you will Show unique records.
How to create a table index in mysql?
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
Write a query to display current date and time?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)