Home >Database >Mysql Tutorial >mysql给字段添加default_MySQL
mysql给字段添加default_MySQL
- WBOYOriginal
- 2016-06-01 13:28:241112browse
bitsCN.com
mysql给字段添加default
Sql代码 alter table t_incoming_records modify incomingtime datetime default C URRENT_TIMESTAMP;
注意：修改字段用关键字modify.
modify后的column可以省略。
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备份与恢复之冷备_MySQLNext article：mysql表之间数据转移_MySQL