Skip to content

Instantly share code, notes, and snippets.

@philsch

philsch/seed-test-data.sql

Created December 20, 2021 16:13
Show Gist options
  • Save philsch/498679f3b609b8ec5aa7ef46c07e74a2 to your computer and use it in GitHub Desktop.
Save philsch/498679f3b609b8ec5aa7ef46c07e74a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
seed-test-data.sql
-- MySQL dump 10.13 Distrib 8.0.25, for macos11 (x86_64)
--
-- Host: 127.0.0.1 Database: testdb
-- ------------------------------------------------------
-- Server version 8.0.27
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int unsigned NOT NULL,
`name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES (1,'Jon Doe'),(2,'Mr Anderson');
UNLOCK TABLES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment