TQMmqmga

1DROP TABLE IF EXISTS ServerLogs;
2CREATE TABLE ServerLogs (ID INT auto_increment PRIMARY KEY, ServerName VARCHAR(50) NOT NULL, DayOnline DATE NOT NULL);
3 
4INSERT INTO ServerLogs (ServerName, DayOnline) VALUES
5     ('MyServer','2018-05-01'),
6     ('MyServer','2018-05-02'),
7     ('MyServer','2018-05-03'),
8     ('MyServer','2018-05-04'),
9     ('MyServer','2018-05-05'),
10     ('MyServer','2018-05-07'),
11     ('MyServer','2018-05-08'),
12     ('MyServer','2018-05-09'),
13     ('MyServer','2018-05-15'),
14     ('MyServer','2018-05-16'),
15     ('MyServer','2018-05-17'),
16     ('MyServer','2018-05-19'),
17     ('MyServer','2018-05-20');
18SELECT * FROM ServerLogs;