mysql 查表列数 字段个数

	<select id="selectByKeyMoreInfo" parameterType="com.longshine.model.entity.Modeltable"
		resultMap="BaseResultMap">
		SELECT a.data_id, a.table_name, a.is_public,a.create_time,
		b.table_rows,count(1) col_count
		FROM model_table a LEFT JOIN
		information_schema.tables b
		ON a.table_name=b.TABLE_NAME
		LEFT JOIN
		information_schema.COLUMNS c
		ON a.table_name=c.TABLE_NAME
		<where>
			<if test="tableName != null and tableName != ''">
				and b.table_name like concat('%',#{tableName},'%')
			</if>
		</where>
		GROUP BY TABLE_NAME
		ORDER BY create_time DESC
	</select>

SELECT table_rows FROM information_schema.tables 
WHERE TABLE_NAME = 'car_24w'

SELECT COUNT(1) FROM information_schema.COLUMNS
     WHERE TABLE_SCHEMA='compute_model'
     AND TABLE_NAME='car_24w';