The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
CURRENT_TIMESTAMP on UPDATE CURRENT_TIMESTAMP in the table definition
Hi, I am trying to migrate from mysql to vertica.
In mysql, the db provides the functionality to update the table timestamps automatically by using 'ON UPDATE' construct
For eg: In Mysql
create <table.name>(
<column_name> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Does a similar functionality exists in Vertica?
Else do I need to include(Insert/Update) CURRENT_TIMESTAMP in each of the update statement
Thanks in advance
In mysql, the db provides the functionality to update the table timestamps automatically by using 'ON UPDATE' construct
For eg: In Mysql
create <table.name>(
<column_name> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Does a similar functionality exists in Vertica?
Else do I need to include(Insert/Update) CURRENT_TIMESTAMP in each of the update statement
Thanks in advance
0
Comments