maverick-farhan/dummy-data-sql

Dummy Data for table creation in mysql database

Dummy Data For SQL

Create Database

CREATE database dummy_db;

---

Switch to newly created Database

use dummy_db;

---

Create Table

CREATE TABLE dummy_table(
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
email VARCHAR(50) NOT NULL,
phone VARCHAR(12) NOT NULL UNIQUE,
address VARCHAR(100) NOT NULL
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;

---

Populate Table with Data

INSERT INTO dummy_table (
    name,email,phone,address
) VALUE 
('Fleta','[email protected]','701699851287','Oroville, California(CA), 95965'),
('Chaim','[email protected]','750505899489','Saint Clair, Michigan(MI), 48079'),
('Edwardo','[email protected]','647425551898','Huson, Montana(MT), 59846'),
('Crystal','[email protected]','977320203783','Advance, North Carolina(NC), 27006'),
('Volkman','[email protected]','300455467155','Bradley, South Carolina(SC), 29819'),
('Ratke','[email protected]','639250689901','North Las Vegas, Nevada(NV), 89032'),
('Milo','[email protected]','922477582831','La Crescent, Minnesota(MN), 55947'),
('Dennis','[email protected]','189908557298','District Heights, Maryland(MD), 20747'),
('Oberbrunner','[email protected]','418353671265','Barnum, Minnesota(MN), 55780'),
('Bernhard','[email protected] ','120805006252','Riverdale, Georgia(GA), 30296'),
('Prohaska','[email protected]','735731303813','Crocker, Missouri(MO), 65452'),
('Madelynn','[email protected]','108559524195','Trumann, Arkansas(AR), 72472'),
('Aaliyah','[email protected]','671469364061','Thibodaux, Louisiana(LA), 70301'),
('Vincenzo','[email protected]','564937057383','Norfolk, Massachusetts(MA), 02056'),
('Bertha','[email protected]','304717293689','Marcus Hook, Pennsylvania(PA), 19061'),
('Margie','[email protected]','437530444982','Klamath, California(CA), 95548'),
('Farrell','[email protected]','903776075565','Social Circle, Georgia(GA), 30025'),
('Adelia','[email protected]','255799550898','Alto, Texas(TX), 75925'),
('Haven','[email protected]','000152458990','Declo, Idaho(ID), 83323');

---

Show all Table's data

SELECT * FROM dummy_table;

OUTPUT

+----+-------------+-------------------------------+--------------+---------------------------------------+
| id | name        | email                         | phone        | address                               |
+----+-------------+-------------------------------+--------------+---------------------------------------+
| 1 | Fleta       | [e-mail]     | 701699851287 | Oroville, California(CA), 95965       |
| 2 | Chaim       | [e-mail]     | 750505899489 | Saint Clair, Michigan(MI), 48079      |
| 3 | Edwardo     | [e-mail]           | 647425551898 | Huson, Montana(MT), 59846             |
| 4 | Crystal     | [e-mail] | 977320203783 | Advance, North Carolina(NC), 27006    |
| 5 | Volkman     | [e-mail]     | 300455467155 | Bradley, South Carolina(SC), 29819    |
| 6 | Ratke       | [e-mail]    | 639250689901 | North Las Vegas, Nevada(NV), 89032    |
| 7 | Milo        | [e-mail]           | 922477582831 | La Crescent, Minnesota(MN), 55947     |
| 8 | Dennis      | [e-mail]     | 189908557298 | District Heights, Maryland(MD), 20747 |
| 9 | Oberbrunner | [e-mail]            | 418353671265 | Barnum, Minnesota(MN), 55780          |
| 10| Bernhard    | [e-mail]     | 120805006252 | Riverdale, Georgia(GA), 30296         |
| 11| Prohaska    | [e-mail]      | 735731303813 | Crocker, Missouri(MO), 65452          |
| 12| Madelynn    | [e-mail]     | 108559524195 | Trumann, Arkansas(AR), 72472          |
| 13| Aaliyah     | [e-mail]          | 671469364061 | Thibodaux, Louisiana(LA), 70301       |
| 14| Vincenzo    | [e-mail]      | 564937057383 | Norfolk, Massachusetts(MA), 02056     |
| 15| Bertha      | [e-mail]         | 304717293689 | Marcus Hook, Pennsylvania(PA), 19061  |
| 16| Margie      | [e-mail]           | 437530444982 | Klamath, California(CA), 95548        |
| 17| Farrell     | [e-mail]             | 903776075565 | Social Circle, Georgia(GA), 30025     |
| 18| Adelia      | [e-mail]      | 255799550898 | Alto, Texas(TX), 75925                |
| 19| Haven       | [e-mail]           | 000152458990 | Declo, Idaho(ID), 83323               |
+----+-------------+-------------------------------+--------------+---------------------------------------+
19 rows in set (0.001 sec)