Coding Tips - SQL

 

Show mySQL Information Schema

		SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ax'
		
Display BLOB Values

		SELECT CAST(`Fieldname` AS CHAR)
		
Function for Random Values

		DELIMITER $$
CREATE DEFINER=`root`@`localhost` FUNCTION `new_digits`(iMinDigits SMALLINT,iMaxDigits SMALLINT) RETURNS varchar(255) CHARSET utf8
    NO SQL
BEGIN

	DECLARE sRetVal VARCHAR(255) DEFAULT '';
	DECLARE iCount INT DEFAULT 0;
	DECLARE iDigits INT DEFAULT 0;
	
	SET iDigits := FLOOR(iMinDigits + (RAND() * (iMaxDigits-iMinDigits)));

	WHILE iCount < iDigits DO
		set sRetVal := CONCAT(sRetVal,ELT(FLOOR(1 + (RAND() * (10-1))), "0","1","2","3","4","5","6","7","8","9"));
		set iCount := iCount + 1;
	END WHILE;

	RETURN sRetVal;
END$$
DELIMITER ;