MySQL判断表是否存在_MySQL
- WBOYOriginal
- 2016-06-01 13:29:271208browse
bitsCN.com
MySQL判断表是否存在
有四种方式进行判断：
1. SHOW TABLES LIKE '%tb_bp_d_case%';2. select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='dbname' and TABLE_NAME='tablename' ;
3. 如果表不存在就建立这个表，那么可以直接用 create table if not exists tablename 这样的指令来建立，不需要先去查询表是否存在。
4. 从模板表创建表：
create table if not exists like old_table_name;
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MYSQL中利用select查询某字段中包含以逗号分隔的字符串的记录方_MySQLNext article：查询Mysql状态_MySQL