-- Query logging
--
--  Driver name: MySQL ODBC 3.51 Driver  Version: 03.51.25
-- Timestamp: 080423 10:27:53

SELECT ROUTINE_SCHEMA AS PROCEDURE_CAT,NULL AS PROCEDURE_SCHEM,ROUTINE_NAME AS PROCEDURE_NAME,NULL AS NUM_INPUT_PARAMS,NULL AS NUM_OUTPUT_PARAMS,NULL AS NUM_RESULT_SETS,ROUTINE_COMMENT AS REMARKS,IF(ROUTINE_TYPE = 'FUNCTION', 2,IF(ROUTINE_TYPE= 'PROCEDURE', 1, 0)) AS PROCEDURE_TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = DATABASE();
SHOW TABLE STATUS ;
SHOW TABLE STATUS FROM `palms` LIKE 'flat-rooms';
SHOW TABLE STATUS FROM `palms` LIKE 'flat-rooms';
SHOW COLUMNS FROM `palms`.`flat-rooms`;
SELECT `id`,`idtype`,`linen`,`location`,`text`,`clean`,`keys`,`isactive`,`people` FROM `palms`.`flat-rooms` LIMIT 0;
select * from palms.flat-rooms where 0=1;