Skip to content

Instantly share code, notes, and snippets.

@drpventura
Last active February 1, 2017 06:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save drpventura/f53ead7141b2588039cca4341dba7a6f to your computer and use it in GitHub Desktop.
Save drpventura/f53ead7141b2588039cca4341dba7a6f to your computer and use it in GitHub Desktop.
MariaDB (MySQL) export file of our first database. See video at: https://youtu.be/smJFdYnphVk
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 01, 2017 at 05:45 AM
-- Server version: 10.1.19-MariaDB
-- PHP Version: 5.6.28
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `first`
--
CREATE DATABASE IF NOT EXISTS `first` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `first`;
-- --------------------------------------------------------
--
-- Table structure for table `parrots`
--
CREATE TABLE `parrots` (
`name` varchar(15) DEFAULT NULL,
`species` varchar(20) DEFAULT NULL,
`age` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `parrots`
--
INSERT INTO `parrots` (`name`, `species`, `age`) VALUES
('Penelope', 'Blue Crown Conure', 21),
('Chiki', 'Pineapple GC Conure', 3),
('Radar', 'Congo African Gray', 21),
(NULL, 'Umbrella Cockatoo', NULL);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment