How Many Tables Will Create When We Create Table, What Are They? – InterviewSolution

InterviewSolution

1.

How Many Tables Will Create When We Create Table, What Are They?

Answer»

The ‘.frm’ file STORES the table DEFINITION.
The data file has a ‘.MYD’ (MYData) EXTENSION.
The INDEX file has a ‘.MYI’ (MYIndex) extension.

The ‘.frm’ file stores the table definition.
The data file has a ‘.MYD’ (MYData) extension.
The index file has a ‘.MYI’ (MYIndex) extension.

Discussion

No Comment Found

Related InterviewSolutions

How To Turn On The Session Support?
What Is The Difference Between Reply-to And Return-path In The Headers Of A Mail Function?
Please Give A Regular Expression (preferably Perl/preg Style), Which Can Be Used To Identify The Url From Within A Html Link Tag.
When You Want To Show Some Part Of A Text Displayed On An Html Page In Red Font Color? What Different Possibilities Are There To Do This? What Are The Advantages /disadvantages Of These Methods?
Tools Used For Drawing Er Diagrams.
How To Reset/destroy A Cookie?
How Can I Retrieve Values From One Database Server And Store Them In Other Database Server Using Php?
If We Login More Than One Browser Windows At The Same Time With Same User And After That We Close One Window, Then Is The Session Is Exist To Other Windows Or Not? And If Yes Then Why? If No Then Why?
What Are The Other Commands To Know The Structure Of A Table Using Mysql Commands Except Explain Command?
What Is The Maximum Length Of A Table Name, A Database Name, Or A Field Name In Mysql?