14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→timer
(→timer) |
m (→timer) |
||
| Line 151: | Line 151: | ||
<pre> | <pre> | ||
SELECT @timer := CURRENT_TIMESTAMP(); | SELECT @timer := CURRENT_TIMESTAMP(); | ||
SELECT SLEEP(2); / | SELECT SLEEP(2); /* sleep 2 seconds for testing purpose */ | ||
SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS 'end time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed'; | SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS 'end time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed'; | ||
</pre> | </pre> | ||