/SQL/Mysql update column default value CURRENT_TIMESTAMP error

Mysql update column default value CURRENT_TIMESTAMP error

# Best case you can do is drop the column and recreate it with the set timestamp;
ALTER TABLE `TABLE_NAME` DROP COLUMN `COLUMN_NAME`;
ALTER TABLE `TABLE_NAME` ADD COLUMN `COLUMN_NAME` TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

Similar codes

10 votes180 views2 answers
Select nextval from sequence oracle
SQL
0 vote152 views1 answer
Oracle procedure chain step
SQL
0 vote146 views1 answer
List column names of multiple tables psql
SQL
0 vote165 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
24 votes146 views4 answers
How to add column sql
SQL
0 vote154 views1 answer
Get the previous column of a table in mysql
SQL
1 vote156 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote174 views1 answer
Unique element in sql
SQL
1 vote162 views3 answers
Rows, INSERT INTO
SQL
0 vote159 views1 answer
Datagrip exec
SQL