大家好,又见面了,我是你们的朋友全栈君。/*修改表obj_Device,把字段类型channelNum改为TINYINT(3),默认值为8*/
alter table obj_Device change column channelNum channelNum TINYINT(3) NOT NULL DEFAULT 8;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/133603.html原文链接:https://javaforall.net
mysql 修改字段类型并设置默认值[通俗易懂]/*修改表obj_Device,把字段类型channelNum改为TINYINT(3),默认值为8*/altertable obj_DevicechangecolumnchannelNumchannelNumTINYINT(3)NOTNULLDEFAULT8;
大家好,又见面了,我是你们的朋友全栈君。/*修改表obj_Device,把字段类型channelNum改为TINYINT(3),默认值为8*/
alter table obj_Device change column channelNum channelNum TINYINT(3) NOT NULL DEFAULT 8;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/133603.html原文链接:https://javaforall.net