Sign Up Login


  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

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

0 Answers  

How do you create a table in mysql workbench?

0 Answers  

How you can create a trigger in mysql?

0 Answers  

How to use mysqldump to create a copy of the database?

0 Answers  

Is mysql a programming language?

0 Answers  

How to create trigger in mysql workbench?

0 Answers  

What is orm in mysql?

0 Answers  

What are the differences between char and nchar?

0 Answers  

How do you stop an access query?

0 Answers  

How do you start MySQL on Linux?

5 Answers   Cybernet,

What is the difference Delete and Drop ?

6 Answers  

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

0 Answers  

For more MySQL Interview Questions Click Here
Categories