Sampuran programming

5 days Bootcamp.

Learn professional PHP training.

It cost 199/- rupees only.

Location: Mohali sector 74.

Only first 20 users get this benefit.

PHP Bootcamp for 1 month.

Sampuran programming Belief in Clean and Quality of code

Happy Holi frnds!

You can't a table that has FK constraints applied on it.

:
To truncate the table. You have to remove the constraints first then truncate it and then apply constraints on table.

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE_NAME;
SET FOREIGN_KEY_CHECKS = 1;

See unexcepted behaviour count function with order clause.

Suppose table t contains n record.
Id, last_call, last_call_duration
1, 2014-09-2014 14:24:41, 4 -08-14 07:24:29, 0
26, 2014-09-2014 14:24:41, 4

order by desc
Select id, last_call, last_call_duration from t order by last_call desc.

:
26, 2014-09-2014 14:24:41, 4
1, 2014-08-14 07:24:29, 0

order by desc with count function
Select count(last_call),id, last_call, last_call_duration from t order by last_call desc.

:
Count(last_call),id,....
2,1, 2014-08-14 07:24:29, 0

solve this :

Select count(last_call),id,last_call,last_call_duration from
(select last_call,last_call_duration from t)t1


Count(last_call),id,last_call,last_call_duration
2, 26, 2014-09-2014 14:24:41,4