MySQL equivalent - Firdaus Aryana - com.mysql.lists.win32

3 messages in com.mysql.lists.win32MySQL equivalent

Subject:	MySQL equivalent
From:	Firdaus Aryana (vama...@yahoo.com)
Date:	10/17/2003 02:17:50 PM
List:	com.mysql.lists.win32

Can someone tell me the MySQL equivalent of the following MSSQL statement.

SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'mytable'

Thanks,