Home  >  Article  >  Database  >  MySQL中对表操作的语法集锦

MySQL中对表操作的语法集锦

WBOY
WBOYOriginal
2016-06-07 17:12:13854browse

【添加字段命令】 ALTER TABLE tab_name ADD col_name col_default 添加一个字段 mysqlgt;ALT

  3、INSERT INTO tab_name (col_name) VALUES ('val')这是在表中的其他字段都可以为空的   情况下才可是使用,否侧将出现错误,如果mysqld定义的是非严格模式的话,虽然报错了但是   还可以插入,,如果定义的是严格模式就不能插入了。  

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