mikha
asked on
sql workbench
I'm working with sql workbench and still figuring things out.
How to set up a , created and updated column , with datetime value and have created date automatically set , when row is created and update the updated column everytime the row updates.
also , how to set up a default value for a column
I am trying to do this using GUI of sql workbench .
How to set up a , created and updated column , with datetime value and have created date automatically set , when row is created and update the updated column everytime the row updates.
also , how to set up a default value for a column
I am trying to do this using GUI of sql workbench .
so workbench is the tool you are using to access what database (which makes all the difference), e.g.postfix. oracle. firebird, sqllite, .....
ASKER
MySQL version 5.7
Are you referring to SQL Workbench/J or MySQL Workbench or other tool?
Note: you can do this from SQL syntax typically to set the initial default then you can use a Trigger on updates to update the column if your application doesn't send this automatically.
Note: you can do this from SQL syntax typically to set the initial default then you can use a Trigger on updates to update the column if your application doesn't send this automatically.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.