Friday, May 24, 2013

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS


========SQL語法=====column number

SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'Workbook222'
  AND table_name = 'KDB_Excel3333';

========SQL語法===== row number
select count(*) from KDB_Excel3333;


Verfication: check log:
[24/05/2013 05:49:17.162][INFO]--+++main_002.1 debug---------------
[24/05/2013 05:49:17.162][INFO]--sql_get_rows:SELECT count(*) FROM KDB_Excel3333
[24/05/2013 05:49:17.162][INFO]--cols:27
[24/05/2013 05:49:17.162][INFO]--sql_get_rows:SELECT count(*) FROM KDB_Excel3333
[24/05/2013 05:49:17.162][INFO]--rows:353

No comments:

Post a Comment