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 |
What is a mysql view?
What does mysqli_fetch_assoc do?
How is data stored in mysql?
How to delete a trigger in mysql?
How many threads can mysql handle?
What are the disadvantages of mysql?
How to delete an existing column in a table?
What is the use of mysql workbench?
What is deterministic in mysql?
How to get last inserted id after insert data from a table in mysql?
What is the datatype of image in mysql?
What is the default password for 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)