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