Answer / sergii

DATEDIFF(expr1,expr2)

DATEDIFF() returns expr1 – expr2 expressed as a value in
days from one date to the other. expr1 and expr2 are date
or date-and-time expressions. Only the date parts of the
values are used in the calculation.

mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31

Answer / shwetha

There is a operator {not} BETWEEN ,we can use this in where
clause to get in between dates.
ex:
select count(column name)
from table1
where dates BETWEEN '01-jul-04' and '01-jul-05';

What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine

1 Answers  

---

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?

4 Answers   Afixi, GE,

---

Explain advantages of MyISAM over InnoDB?

1 Answers  

---

What are the non-standard sql commands supported by 'mysql'?

0 Answers  

---

How do I export mysql query results to excel?

0 Answers  

---

How to get the current date in mysql?

0 Answers  

---

In which language it is written?

0 Answers  

---

What are numeric data types?

0 Answers  

---

how we connect the data base in any programme

2 Answers  

---

How do I backup mysql database on linux?

0 Answers  

---

How does mysql store dates?

0 Answers  

---

What is the difference between GROUP BY and ORDER BY in Sql?

12 Answers   Creative, Renault Nissan, Trikon Networks,

---