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 |
Differentiate between FLOAT and DOUBLE?
What is general log in mysql?
How do you insert a table?
Describe mysql transaction properties.
Which statement is used in a select query for partial matching?
What is normalization and list the different types of normalization?
List data types in mysql? Explain
How can we get the number of rows affected by query?
What are HEAP tables in MySQL?
What is ibdata1?
How do I drop a database in mysql?
What is the difference between timestamp and datetime in mysql?
Oracle (3259)
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)