-------------

INSERT INTO `gamebar`.`employees` (`first_name`, `last_name`)
     VALUES ('Test1', 'Test1');

--------------

DELETE FROM `gamebar`.`employees` WHERE (`id` = '8');

---------------

ALTER TABLE `gamebar`.`employees`
ADD COLUMN `midle_name` VARCHAR(45) NOT NULL AFTER `first_name`;

--------------

ALTER TABLE `minions`.`minions`
CHANGE COLUMN `town_id` `town_id` INT(11) NOT NULL ;

---------------------
Create the connection via foreign key between the “products” and “categories”
tables that you’ve created earlier. Make “category_id”
foreign key linked to “id” in the “categories” table.

ALTER TABLE `products`
ADD CONSTRAINT fk_products_categories FOREIGN KEY (`category_id`)
REFERENCES categories(id);

----------------------------

UPDATE `minions`.`minions` SET `town_id` = '2' WHERE (`id` = '3');

---------------------------

DELETE FROM `minions`.`minions` WHERE (`id` = '2');
UPDATE `minions`.`minions` SET `name` = NULL,
   `age` = NULL, `town_id` = NULL WHERE (`id` = '1');

--------------------------

TRUNCATE TABLE `minions`;

--------------

ALTER TABLE `users`
DROP COLUMN id, DROP PRIMARY KEY;

ALTER TABLE `users`
CHANGE COLUMN `username` `pk_users` INT NOT NULL AUTO_INCREMENT,
ADD PRIMARY KEY ( `pk_users`);

------------------------

SELECT * FROM `towns` ORDER BY towns.name ;

SELECT * FROM `towns` AS t ORDER BY t.name ;

SELECT * FROM `towns` AS t ORDER BY t.name DESC ;

SELECT t.name FROM `towns` AS t ORDER BY t.name DESC ;

-----------------

UPDATE `towns` SET `name` = "Sofiaaa" WHERE (`id` = '1');

--------------------------