MYSQL Console Tutorial #7 How to change default fields in a table schema

In the seventh part for the MYSQL console tutorial you will learn how to change the default values in a table schema using the MYSQL command line. In this example we add three new columns (is_active, gender and title) to the customer table and set their default values. Full MYSQL course with no adverts Skillshare: http://skl.sh/2zp5cnv Become a patron: 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 ^^ Above are affiliate links ======== 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 ======== Managed website hosting from Cloudways: http://bit.ly/2CKb79b Programming courses and books from Manning Publications: http://bit.ly/2BIrExp #mysql #learnToCode #howToCodeWell ## Become a channel member Join the How to code well YouTube channel to get access to premium programming courses, tutorials and member perks https://www.youtube.com/channel/UCjFs9wBGz4HlEJGUB6jzUmw/join