Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: login to mysql database 
Sql :: rename field name in mysql 
Sql :: how to use rank function in sql 
Sql :: postgresql insert column 
Sql :: mysql on update current_timestamp 
Sql :: Get the Db column names from a SqlDataReader 
Sql :: mysql case when or 
Sql :: like in mysql 
Sql :: insert current date sql 
Sql :: Check user permissions on postgres database 
Sql :: sql server rtrim everything after character 
Sql :: clear screen command on mysql 
Sql :: string to sql timestamp 
Sql :: sql blank vs null 
Sql :: sequelize migration default value 
Sql :: java sql timestamp now 
Sql :: postgresql check privileges on schema 
Sql :: show all event schedular on mysql 
Sql :: oracle running queries sql 
Sql :: update and replace mysql 
Sql :: sql delete all values in a column 
Sql :: sql datetime format dd/mm/yyyy hh:mm am/pm 
Sql :: how to find the number of rows updated in oracle pl/sql 
Sql :: run postgresql dump to csv 
Sql :: brew start postgres 
Sql :: mysql backup database 
Sql :: postgresql get connection string 
Sql :: sql right join with where clause 
Sql :: sql format time 
Sql :: find usage of table in sql server 
ADD CONTENT
Topic
Content
Source link
Name
2+1 =