how many table created when we create a table in mysql?
Answers were Sorted based on User's Feedback
Answer / bhas
3 tables
1.table structure(.frm)
2.table data(.myd)
3.table index(.myi)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / jyoti
At time only 1 table we have create.
if we open 2 command prompt than we create 2 tables at time
but 2 different cmd.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to create table show example
How we can copy one table data into another table whose name same as table but in differ database
What is the difference between a heap table and temporary table?
What is deterministic in mysql?
Is mysql still popular?
How do I change a procedure in mysql?
What is delimiter in mysql?
What is difference between mysql and mysql workbench?
How internally data stores in MyISAM and INNODB table types?
What are the 5 r's of managing behaviors?
What are procedures in mysql?
How to rename an existing table 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)