Tutorials and web chats for the How To Code Well Youtube channel
How To Code Well Tutorials and Web Chats
MYSQL Console Tutorial #8 How to change the extra value in a table schema
2 liked this
In the eighth part for the MYSQL console tutorial you will leanr how to change the extra value in a table schema using the MYSQL command line.
In this example we two new columns (created_date and updated_date) to the customer table.
We trigger the value of the created_date to be changed when a record is inserted.
We also trigger the value of the updated_date to be changed each time a record is updated using a ON UPDATE trigger set it the columns extra definition