How many tables will create when we create table, what are
they?
- 2 Answers
- 4569 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
How many tables will create when we create table, what are
they?..
How many tables will create when we create table, what are
they?..
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 |
More MySQL Interview Questions
What is the innodb in mysql?
What are mysql queries?
How to increment dates by 1 in mysql?
What is the different between NOW() and CURRENT_DATE()?
How do I stop a mysql service?
What are all the Common SQL Function?
What is the use of mysqli_num_rows?
How do I install mysql on windows 10?
How we can get the current date in mysql?
How do I stop a mysql command?
When to use order by in delete statement?
What is difference between mysql and mariadb?
Categories
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
