PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

593 bytes removed , 8 December 2016

14,983

edits

@@ Line 150: / Line 150: @@
 ==== timer ====
-PHP: [http://stackoverflow.com/questions/8310487/start-and-stop-a-timer-php Start and stop a timer PHP - Stack Overflow]
+[[Timer]]
-MySQL: Recording the time elapsed after the sql query was executed.
-<pre>
-SELECT @timer := CURRENT_TIMESTAMP();
-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';
-</pre>
-Python: [http://stackoverflow.com/questions/7370801/measure-time-elapsed-in-python performance - Measure time elapsed in Python? - Stack Overflow]
 === date interval ===