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

Question Posted / ranjitbd

3 Answers
5675 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 do I stop a mysql command?

0 Answers

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers

What are the disadvantages of stored procedures?

0 Answers

How can we repair a MySQL table?

2 Answers Infosys,

How do I exit mysql?

0 Answers

How many tables will create when we create table, what are they?

2 Answers

maximum size of a database in mysql?

2 Answers

What is mysql default port number?