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