How many tables will create when we create table, what are they?
Answers were Sorted based on User's Feedback
Answer / freeman
If you create one table , then only one table with be created.
But 3 files with be created namely tb_name.frm,tb_name.myi,
tb_name.myd,
| Is This Answer Correct ? | 26 Yes | 0 No |
Answer / bhas
dear chandu
.frm->from mysql
.myi->mysql index
.myd->mysql data
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / harsh
3 tables
But 3 files with be created namely tb_name.frm,tb_name.myi,
tb_name.myd,
extensions of
.frm
.myi
.myd
| Is This Answer Correct ? | 0 Yes | 0 No |
Is oracle better than mysql?
What is the data type for image?
How to insert html code into mysql database using php?
I have two sql database at different PC.how can link b/w database and database tables.
How you can create a trigger in mysql?
In mysql, what is the default storage engine?
Where is mysql data stored linux?
What are the benefits of mysql?
How do I delete a mysql user?
What is normalization and list the different types of normalization?
How do you login to MySql using Unix shell?
What is mvcc 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)