How many tables will create when we create table, what are
they?
- 2 Answers
- 4636 Views
- I also Faced
- E-Mail Answers
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 language is mysql written in?
What is bigint in mysql?
Write a command with which mysql table can be repaired
Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.
write a command to view the content of the table
How many rows can a mysql table hold?
What is difference between mysqli and pdo?
How to delete the repeated records from a table?
How to store binary data in mysql?
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
What is mysql data directory? How to determine the location of the data directory?
What is default password for mysql?
-
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 (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
