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 |
How can I connect mysql database?
What do ddl, dml, and dcl stand for?
i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table??
Can you shard mysql?
What can you do with mysql?
How many rows can mysql hold?
What is the difference between GROUP BY and ORDER BY in Sql?
12 Answers Creative, Renault Nissan, Trikon Networks,
Does insert statement lock the table?
What is difference between mysql and mysql workbench?
Can we use mysql and mysqli together?
What is the difference between a heap table and temporary table?
What are the functions used to encrypt and decrypt the data present 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)