|
1 2 3 |
<span class="sql1-reservedword">alter</span> <span class="sql1-reservedword">table</span> <span class="sql1-tablename">bonus_click</span> <span class="sql1-reservedword">alter</span> <span class="sql1-reservedword">column</span> <span class="sql1-identifier">GrantDate</span> <span class="sql1-reservedword">drop</span> <span class="sql1-reservedword">default</span><span class="sql1-symbol">;--有则删除默认值 </span><span class="sql1-reservedword">alter</span> <span class="sql1-reservedword">table</span> <span class="sql1-tablename">bonus_click</span> <span class="sql1-reservedword">alter</span> <span class="sql1-reservedword">column</span> <span class="sql1-identifier">GrantDate</span> <span class="sql1-reservedword">set</span> <span class="sql1-reservedword">default</span> <span class="sql1-function">CURRENT_TIMESTAMP</span><span class="sql1-symbol">; --添加默认值 </span> |