Sql

Search

ADD COLOUNS CREATED AND UPDATED AT IN MYSQL

ALTER TABLE t1
ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql select last 15 minutes
Sql :: postgresql print sessions using the database
Sql :: mysql add days to date
Sql :: sql error 1175
Sql :: mysql allow remote connections
Sql :: postgres change owner of schema
Sql :: mysql check table exists
Sql :: sql between date range
Sql :: mysql connection with sqlalchecmy
Sql :: how to remove unique key constraint in mysql
Sql :: mysql cannot delete or update a parent row
Sql :: postgres select from last 3 months
Sql :: Check Table Exists
Sql :: select dba users oracle
Sql :: install mysql workbench ubuntu 20.04 terminal
Sql :: search column name sql
Sql :: mysql drop primary key
Sql :: mysql left join exists
Sql :: postgres drop column if exists
Sql :: mysql delete binlog
Sql :: sql server if exists update else insert
Sql :: installing mysql on fedora
Sql :: mysql subtract month from timestamp
Sql :: copy sql table to another table
Sql :: edate dax
Sql :: mysql user permission database
Sql :: What is the compatibility level of a SQL database
Sql :: truncate left characters mysql
Sql :: sql update from select
Sql :: how to delete table in mysql

Search

SQL

ADD COLOUNS CREATED AND UPDATED AT IN MYSQL

ADD CONTENT