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 |
What is maximum size of a database in MySQL?
13 Answers Bastioncoup, CIS, NM, V2 Solutions, Wipro,
How many mysql connections can handle?
How do I kill a mysql connection?
How to get help information from the server?
What is mysql command line?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?
How are mysql timestamps seen to a user?
Is mysql good for big data?
What is mysql and why it is used?
What is a table schema?
How to delete a table.
Oracle (3253)
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)