MySQL - Sample Data - sysdba.org

MySQL MySQL – Sample Data

MySQL – Sample Data

Sample Data

show databases ;
use sampledb

1 2	show databases ; use sampledb

CREATE TABLE sample_table (
`name` varchar(255) default NULL,
`surname` varchar(255) default NULL,
`city` varchar(50) default NULL,
`country` varchar(50) default NULL
) ;

CREATE TABLE sample_table (

`name` varchar(255) default NULL,

`surname` varchar(255) default NULL,

`city` varchar(50) default NULL,

`country` varchar(50) default NULL

) ;

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jin','Eaton','Clarksville','Mayotte');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Coby','Long','Ames','United States');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Phoebe','Gay','Cedarburg','Sweden');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Blair','Dickson','Carson City','Oman');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Yoshio','Hogan','Sacramento','Tonga');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Brent','Zamora','Oil City','Bouvet Island');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Xavier','Cooley','Sheridan','Barbados');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Keegan','Schneider','White Plains','Algeria');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Baker','Carlson','Monterey Park','France');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Myra','Mcintyre','Duarte','Japan');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Vaughan','Harding','Fitchburg','Antigua and Barbuda');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Maggie','Holloway','Plano','Namibia');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Solomon','Johns','Lock Haven','Western Sahara');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jeremy','Castro','Brea','Japan');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Gloria','Walls','Madison','Togo');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Price','Keller','Trenton','Swaziland');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Mara','Johnston','Cedar Falls','Georgia');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Aurelia','Hardin','Rome','Albania');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Quon','Bender','Augusta','Hungary');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jorden','Rasmussen','Aguadilla','Guam');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Dacey','Knox','Grand Island','Pitcairn');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Merrill','Hudson','Champaign','Anguilla');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Hayfa','Noble','Utica','Cambodia');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Carlos','Sanford','Aberdeen','Singapore');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Elton','Carlson','Burbank','Guinea-bissau');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Keely','Summers','Helena','French Guiana');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Wallace','Hodge','Pittsburgh','Jamaica');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Chaim','Patel','Sandy','Iceland');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Colt','Carney','Brockton','Togo');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Lila','Durham','Uniontown','Yemen');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Velma','Scott','Casper','Benin');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Maris','Cantu','Thousand Oaks','United Arab Emirates');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Edward','Alvarez','Fort Worth','Somalia');
INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Tatum','Oneil','Buena Park','Svalbard and Jan Mayen');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jin','Eaton','Clarksville','Mayotte');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Coby','Long','Ames','United States');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Phoebe','Gay','Cedarburg','Sweden');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Blair','Dickson','Carson City','Oman');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Yoshio','Hogan','Sacramento','Tonga');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Brent','Zamora','Oil City','Bouvet Island');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Xavier','Cooley','Sheridan','Barbados');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Keegan','Schneider','White Plains','Algeria');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Baker','Carlson','Monterey Park','France');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Myra','Mcintyre','Duarte','Japan');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Vaughan','Harding','Fitchburg','Antigua and Barbuda');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Maggie','Holloway','Plano','Namibia');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Solomon','Johns','Lock Haven','Western Sahara');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jeremy','Castro','Brea','Japan');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Gloria','Walls','Madison','Togo');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Price','Keller','Trenton','Swaziland');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Mara','Johnston','Cedar Falls','Georgia');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Aurelia','Hardin','Rome','Albania');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Quon','Bender','Augusta','Hungary');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Jorden','Rasmussen','Aguadilla','Guam');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Dacey','Knox','Grand Island','Pitcairn');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Merrill','Hudson','Champaign','Anguilla');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Hayfa','Noble','Utica','Cambodia');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Carlos','Sanford','Aberdeen','Singapore');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Elton','Carlson','Burbank','Guinea-bissau');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Keely','Summers','Helena','French Guiana');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Wallace','Hodge','Pittsburgh','Jamaica');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Chaim','Patel','Sandy','Iceland');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Colt','Carney','Brockton','Togo');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Lila','Durham','Uniontown','Yemen');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Velma','Scott','Casper','Benin');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Maris','Cantu','Thousand Oaks','United Arab Emirates');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Edward','Alvarez','Fort Worth','Somalia');

INSERT INTO `sample_table` (`name`,`surname`,`city`,`country`) VALUES ('Tatum','Oneil','Buena Park','Svalbard and Jan Mayen');

insert into tablo_deneme select * from sample_table ;

1	insert into tablo_deneme select * from sample_table ;

Written By

sysdba.org

MySQL – Sample Data

Mehmet Dervişoğlu

MySQL – Monitoring

MySQL – Backup

Categories

LATEST POSTS

Exploring the Oracle DBMS Architecture

Locked Objects

Connecting to Oracle

RECENT COMMENTS

Using RMAN for...

User and Group...

Joomla Backup Restore

ARCHIVES

MySQL – Sample Data

Categories

LATEST POSTS

RECENT COMMENTS

TAG CLOUD

ARCHIVES

Newsletter