How to Use Views and Stored Procedures in MySQL

• Introduction
• Prerequisites
• Create a Sample Database
• Implement SQL Views
  • Create a SQL View
  • Update a SQL View
  • Delete a SQL View
• Implement SQL Stored Procedures
• Create a SQL Stored Procedure

MySQL Tutorial

• Keys, Constraints and Indexes
  • Primary Keys
  • Unique Constraints
  • Indexes
• Privileges and Passwords
  • Grant/Revoke Privileges
• Database Administration

• Git Cheat Sheet
  • Commands
    • Getting Started
    • Configuration
    • Working with Local Branch
      • Branching
      • Updating Current Branch
    • Working with Remote Branch

bold text

Help with SQL commands to interact with a MySQL database

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

goto chrome://flags/ the press f12 and paste code then run backup() or restore()

function saveFile(filename, data) {
  return new Promise(resolve => {
    const blob = new Blob([data], { type: 'octet/stream' });
    const url = window.URL.createObjectURL(blob);
    const dom = document.createElement('a');

Install Xampp from https://www.apachefriends.org/index.html

• Run the Xampp installer and open the Xampp control panel
• Make sure that you enable the Apache and MySQL services
• On mac you need to click "Start" on the Home tab, "Enable" on the Network tab and "Mount" on the Location Tab. Click "Explore" on the location tab to open your Xampp/Lampp folder