<?php // call export function exportMysqlToCsv ( 'export_csv.csv' ); // export csv function exportMysq…

For the record SELECT * FROM mytable WHERE id IN ( 1 , 2 , 3 , 4 ) ORDER BY FIELD ( id , 3 , 2 , 1 , 4 );   sh…

Determine what datatypes you want.   INT   won't work so hot with your 1.16 idea. You lose to rounding to an INT.…

CREATE FUNCTION ucfirst (x varchar ( 255 )) returns varchar ( 255 ) return concat( upper ( subst…

MySQL does not have a function that returns the first day of a date. However, you can use the  LAST_DAY()  function t…