Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql create timestamp column

ALTER TABLE `table1` ADD `lastUpdated` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql select all from table 
Sql :: How to reset forgotten postgresql password 
Sql :: real world example of nosql 
Sql :: sql like 
Sql :: oracle limit rows 
Sql :: ora-02391 
Sql :: sql select data from last week 
Sql :: cast to float with .2 sql 
Sql :: date_trunc postgres 
Sql :: sql problems 
Sql :: get row affected mysql 
Sql :: start postgres server 
Sql :: How to convert Varchar to Double in sql? 
Sql :: postgresql default value boolean 
Sql :: oracle add auto_increment column to existing table 
Sql :: sql count having 
Sql :: select table column name in sql 
Sql :: postgres change column type to uuid 
Sql :: select index table oracle 
Sql :: mysql date time string format python 
Sql :: sql server query all database objects 
Sql :: postgresql cast 
Sql :: sql duplicate rows 
Sql :: pluck in query builder 
Sql :: mysql select multiple rows into one column 
Sql :: postgres cast as decimal 
Sql :: find lowest number in sql 
Sql :: How do I modify a MySQL column to allow NULL? 
Sql :: datediff 
Sql :: spring where to put the data sql 
ADD CONTENT
Topic
Content
Source link
Name
2+2 =