search

Home >Backend Development >PHP Tutorial >mysql某列的默认值替另一列,有办法么>

mysql某列的默认值替另一列,有办法么>

WBOY
WBOYOriginal
2016-06-13 10:32:181253browse

mysql某列的默认值为另一列,有办法么>
ip varchar(20),
name vachar(20)

我现在要使insert语句没有给出name的值时就填入ip的值,也就是NOT NULL DEFAULT VALUE怎么写,有这个办法吗

------解决方案--------------------
为什么不能程序处理呢，在插入前处理数据？

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：数组经print_r($arr,true)生成的字符串怎么还原成数组Next article：发送ajax没有反映,没报错什么反映也没有，经常遇到这种情况

Related articles

See more