Home >Database >Mysql Tutorial >mysql判断字段是否存在的方法_MySQL
mysql判断字段是否存在的方法_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:26:051204browse
bitsCN.com
1. desc 命令
格式: desc tablename columnname
例子:
desc `table` `mid`
desc `table` '%abc%'
2. show columns 命令
格式: show columns from tablename like columnname
例子:
show columns from `table` like 'mid'
show columns from `table` like '%abc%'
3. describe 命令
格式: describe tablename columnname
describe 相
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 查看语句的执行效率_MySQLNext article：Mysql创建 修改和删除表等操作_MySQL