How many tables will create when we create table, what are
they?
Answers were Sorted based on User's Feedback
Answer / anand
Three tables
1. .frm(containg structure of table)
2. .MYI(contains Index)
3. .MYD(For containing data values)
| Is This Answer Correct ? | 3 Yes | 3 No |
What are the differences between char and nchar?
What are aggregate functions in mysql?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
How do I check mysql version?
How can we store binary data in mysql?
What are the three types of queries?
What is the difference between the primary and unique key in mysql?
What is the difference between char and varchar in mysql?
How can you find out the version of the installed mysql?
What?s the difference between query_cache_type 1 and 2?
Write a command to list all databases in mysql?
How to get last inserted id after insert data from a table 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)