【MySQL】基本操作笔记

查找指定名称表项是否存在，并返回表项个数

SELECT
	count( * ) 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	table_schema = ( SELECT DATABASE ( ) ) 
	AND table_name = 'table_name' 
	AND table_type = 'BASE TABLE';
转载：https://blog.csdn.net/LXang723/article/details/124294196