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 ;