Interested to Buy Any Domain ? << Click Here >> for more details...
How many tables will create when we create table, what are
they?
- 2 Answers
- 5143 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anand
Three tables
1. .frm(containg structure of table)
2. .MYI(contains Index)
3. .MYD(For containing data values)
| Is This Answer Correct ? | 3 Yes | 3 No |
at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you
How do I edit a database in mysql workbench?
What is the return type of mysqli_query?
What is a transaction? Describe mysql transaction properties.
Is SET Command is SQL Statement..?
what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 Answers Infosys, Sierra Atlantica,
How do I download mysql?
How can you see all indexes defined for a table?
Is mysql a distributed database?
What are the features of Stored Procedures in MYSQL?
Do I need python for mysql?
how to declare unique key in creating a table..?
-
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)
