· 9 years ago · Nov 08, 2016, 08:36 PM
1create database if not exists test_list;
2use test_list;
3
4drop table if exists readers;
5drop table if exists writers;
6
7CREATE TABLE IF NOT EXISTS readers
8(
9 EGN BIGINT(10) UNSIGNED PRIMARY KEY UNIQUE NOT NULL,
10 FirstName VARCHAR(30) NOT NULL,
11 MiddlName VARCHAR(30),
12 SureName VARCHAR(30) NOT NULL,
13 Address VARCHAR(100),
14 PhoneNumber VARCHAR(15)
15);
16
17insert into readers values (1010101010, "First1", "Middle1", "Sure1", "Address1", "*881");
18insert into readers values (1010101011, "First2", "Middle2", "Sure2", "Address2", "*882");
19insert into readers values (1010101012, "First3", "Middle3", "Sure3", "Address3", "*883");
20insert into readers values (1010101013, "First4", NULL , "Sure4", "Address4", "*884");
21
22CREATE TABLE IF NOT EXISTS writers
23(
24 EGN BIGINT(10) UNSIGNED PRIMARY KEY UNIQUE NOT NULL,
25 FirstName VARCHAR(30) NOT NULL,
26 MiddlName VARCHAR(30),
27 SureName VARCHAR(30) NOT NULL,
28 Address VARCHAR(100),
29 PhoneNumber VARCHAR(15)
30);
31
32insert into writers values (1010101010, "First1", "Middle1", "Sure1", "Address1", "*881");
33insert into writers values (1010101011, "First2", "Middle2", "Sure2", "Address2", "*882");
34insert into writers values (1010101012, "First3", "Middle3", "Sure3", "Address3", "*883");
35insert into writers values (1010101013, "First4", NULL , "Sure4", "Address4", "*884");
36
37select * from readers;
38select * from writers;
39
40select *
41from readers
42inner join writers
43on readers.MiddlName = writers.MiddlName;