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

03/05/2016
344 views
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

Full MYSQL course with no adverts
Skillshare: http://skl.sh/2zp5cnv

Support the channel as a Patreon: https://www.patreon.com/howToCodeWell

MYSQL study Books
- MYSQL Cook Book
http://amzn.to/2sqJcVS

- Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5
http://amzn.to/2sq5Lu4

- MySQL (Developer's Library)
http://amzn.to/2sH9CqK

======== MY COURSES AND BOOKS ========

Docker in Motion: http://bit.ly/2vvz2sA
Skillshare courses: http://skl.sh/2gI33M5
Udemy courses: http://bit.ly/2iGhvIE

======== SUPPORT THE CHANNEL ========

Become a Patron: http://bit.ly/2hmVKwX
Donate: https://www.paypal.me/howToCodeWell
Support the stream: https://streamlabs.com/howtocodewell
Help translate the videos: http://bit.ly/2iEyxXB

======== SUBSCRIBE TO THE NEWSLETTER ========

http://bit.ly/2fPlG3v

======== FOLLOW ME ========

Blog: http://peterfisher.me.uk
Facebook: http://facebook.com/howtocodewell/
Instagram: http://instagram.com/howtocodewell/
Twitter: http://twitter.com/howToCodeWell
Pintrest: http://pinterest.co.uk/howtocodewell/
Twitch: http://twitch.tv/howtocodewell

======== MY TALKS ========

How to put your Docker image on a diet: http://bit.ly/2y5KMly

======== RECOMMENDED PROGRAMMING RESOURCES ========

Microservices in Action: http://bit.ly/2xIi4oh
Get Programming in Javascript: http://bit.ly/2gx2G6A
ES6 in Motion: http://bit.ly/2xJ3i0z
PHP Web Services: APIs for the Modern Web: http://amzn.to/2tqiyOl
Responsive Web Design with HTML5 and CSS3: http://amzn.to/2tSo6nH