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 are the 3 main types of search queries?
How can you handle the –secure-file-priv in mysql?
What does innodb stand for?
Is number a datatype in mysql?
How do I install the latest mysql on ubuntu?
How do I setup a mysql database?
What is difference between pdo and mysqli?
What?s the difference between query_cache_type 1 and 2?
What is root password?
Is mysql running ubuntu?
What is the default password for mysql?
What is a trigger 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)