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