Creating Databases and Tables: MySQL for Beginners, Part 1

The first part of a tutorial series on the popular free MySQL database. In this video I show you how to create databases and add some data.



Commands demonstrated in this video (these commands create a database called shop and add one very small table to it called 'customers'):

 
create database shop;
show databases;
use shop;
show tables;
create table customers (surname varchar(50), firstname varchar(30));
show tables;
desc customers    ;
insert into customers (firstname, surname) values ("Joe", "Smith");
select * from customers;