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

Question Posted / ranjitbd

3 Answers
5488 Views
I also Faced
E-Mail Answers

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

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

How many entries can mysql handle?

0 Answers

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers

What is orm in mysql?

0 Answers

How do I find mysql version in mysql workbench?

0 Answers

What is mysql in dbms?

0 Answers

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers

What is int mysql?

0 Answers

What are the differences between drop a table and truncate a table?

10 Answers

How do I show users in mysql?

0 Answers

What is text in mysql?

0 Answers

all the queries used in sql

0 Answers TCS,

For more MySQL Interview Questions Click Here