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 |
How you will Show unique records.
What is meant by sharding?
What is meant by mysql database?
How to dump one database for backup.
How many sql dml commands are supported by 'mysql'?
Can't connect mysql server on localhost?
What are date and time data types in mysql?
What language is used in mysql?
What does mysql flush hosts do?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
What is blob in mysql?
How to filter data from a mysql database table with php?
Oracle (3253)
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)