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 many entries can mysql handle?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is orm in mysql?
How do I find mysql version in mysql workbench?
What is mysql in dbms?
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?
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?.
What is int mysql?
What are the differences between drop a table and truncate a table?
How do I show users in mysql?
What is text in mysql?
all the queries used in sql
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)