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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.