1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

how many table created when we create a table in mysql?

Question Posted / ranjitbd

Answers were Sorted based on User's Feedback



how many table created when we create a table in mysql?..

Answer / bhas

3 tables

1.table structure(.frm)
2.table data(.myd)
3.table index(.myi)

Is This Answer Correct ?    5 Yes 0 No

how many table created when we create a table in mysql?..

Answer / asha

1

Is This Answer Correct ?    4 Yes 3 No

how many table created when we create a table in mysql?..

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

Post New Answer

More MySQL Interview Questions

What are the steps involved in query processing?

0 Answers  

What is max connection in mysql?

0 Answers  

Why do we use views instead of tables?

0 Answers  

maximum size of a database in mysql?

2 Answers  

What does innodb stand for?

0 Answers  




Explain the difference between FLOAT, DOUBLE and REAL.

14 Answers   Yahoo,

What is the role of a limit in a mysql query?

0 Answers  

What is mysql command line?

0 Answers  

How to rename an existing column in a table?

0 Answers  

Is mysql is a programming language?

0 Answers  

Why mysql is so popular?

0 Answers  

What are the drivers in MySQL?

1 Answers  

For more MySQL Interview Questions Click Here
Categories