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;

All pages on this site are copyright © 2013 John W. Purcell