Try Adsterra Earnings, it’s 100% Authentic to make money more and more.

I also did a new installation, without success. The version of the Mosh’s Youtube video is not available anymore.

I found a workaround though: the last table ‘products’ of sql_inventory was actually generated – despite the error code above. So I extracted the generation of tables hand by hand and let them run in their own SQL tab. That worked : )

e.g.:

DROP DATABASE IF EXISTS `sql_hr`; CREATE DATABASE `sql_hr`; USE `sql_hr`; CREATE TABLE `offices` ( `office_id` int(11) NOT NULL, `address` varchar(50) NOT NULL, `city` varchar(50) NOT NULL, `state` varchar(50) NOT NULL, PRIMARY KEY (`office_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO `offices` VALUES (1,’03 Reinke Trail’,’Cincinnati’,’OH’); INSERT INTO `offices` VALUES (2,’5507 Becker Terrace’,’New York City’,’NY’); INSERT INTO `offices` VALUES (3,’54 Northland Court’,’Richmond’,’VA’); INSERT INTO `offices` VALUES (4,’08 South Crossing’,’Cincinnati’,’OH’); INSERT INTO `offices` VALUES (5,’553 Maple Drive’,’Minneapolis’,’MN’); INSERT INTO `offices` VALUES (6,’23 North Plaza’,’Aurora’,’CO’); INSERT INTO `offices` VALUES (7,’9658 Wayridge Court’,’Boise’,’ID’); INSERT INTO `offices` VALUES (8,’9 Grayhawk Trail’,’New York City’,’NY’); INSERT INTO `offices` VALUES (9,’16862 Westend Hill’,’Knoxville’,’TN’); INSERT INTO `offices` VALUES (10,’4 Bluestem Parkway’,’Savannah’,’GA’);

now the ‘offices’ table in ‘sql_hr’ is generated. If you want to generate the ’employees’ table, delete the first to rows and start with use ‘sql_hr’

— DROP DATABASE IF EXISTS `sql_hr`; — CREATE DATABASE `sql_hr`; USE ‘sql_hr’; CREATE TABLE `employees` ( `employee_id` int(11) NOT NULL, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `job_title` varchar(50) NOT NULL, `salary` int(11) NOT NULL, `reports_to` int(11) DEFAULT NULL, `office_id` int(11) NOT NULL, PRIMARY KEY (`employee_id`), KEY `fk_employees_offices_idx` (`office_id`), KEY `fk_employees_employees_idx` (`reports_to`), CONSTRAINT `fk_employees_managers` FOREIGN KEY (`reports_to`) REFERENCES `employees` (`employee_id`), CONSTRAINT `fk_employees_offices` FOREIGN KEY (`office_id`) REFERENCES `offices` (`office_id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO `employees` VALUES (37270,’Yovonnda’,’Magrannell’,’Executive Secretary’,63996,NULL,10); INSERT INTO `employees` VALUES (33391,’D’arcy’,’Nortunen’,’Account Executive’,62871,37270,1); INSERT INTO `employees` VALUES (37851,’Sayer’,’Matterson’,’Statistician III’,98926,37270,1); INSERT INTO `employees` VALUES (40448,’Mindy’,’Crissil’,’Staff Scientist’,94860,37270,1); INSERT INTO `employees` VALUES (56274,’Keriann’,’Alloisi’,’VP Marketing’,110150,37270,1); INSERT INTO `employees` VALUES (63196,’Alaster’,’Scutchin’,’Assistant Professor’,32179,37270,2); INSERT INTO `employees` VALUES (67009,’North’,’de Clerc’,’VP Product Management’,114257,37270,2); INSERT INTO `employees` VALUES (67370,’Elladine’,’Rising’,’Social Worker’,96767,37270,2); INSERT INTO `employees` VALUES (68249,’Nisse’,’Voysey’,’Financial Advisor’,52832,37270,2); INSERT INTO `employees` VALUES (72540,’Guthrey’,’Iacopetti’,’Office Assistant I’,117690,37270,3); INSERT INTO `employees` VALUES (72913,’Kass’,’Hefferan’,’Computer Systems Analyst IV’,96401,37270,3); INSERT INTO `employees` VALUES (75900,’Virge’,’Goodrum’,’Information Systems Manager’,54578,37270,3); INSERT INTO `employees` VALUES (76196,’Mirilla’,’Janowski’,’Cost Accountant’,119241,37270,3); INSERT INTO `employees` VALUES (80529,’Lynde’,’Aronson’,’Junior Executive’,77182,37270,4); INSERT INTO `employees` VALUES (80679,’Mildrid’,’Sokale’,’Geologist II’,67987,37270,4); INSERT INTO `employees` VALUES (84791,’Hazel’,’Tarbert’,’General Manager’,93760,37270,4); INSERT INTO `employees` VALUES (95213,’Cole’,’Kesterton’,’Pharmacist’,86119,37270,4); INSERT INTO `employees` VALUES (96513,’Theresa’,’Binney’,’Food Chemist’,47354,37270,5); INSERT INTO `employees` VALUES (98374,’Estrellita’,’Daleman’,’Staff Accountant IV’,70187,37270,5); INSERT INTO `employees` VALUES (115357,’Ivy’,’Fearey’,’Structural Engineer’,92710,37270,5);

and so on… make sure to adapt the CREATE and USE in the beginning..

Source

Published By

allaboutian

open profile for all

Latest entries

all Entries

• allPost2024.11.15The man who donated this year‘s Rockefeller Center Christmas tree suffered a stroke
• allPost2024.11.15Easy Steps To Exness Niger Of Your Dreams
• allPost2024.11.15Prosecutor says Jose Ibarra ‘went hunting for females’ on day Laken Riley was slain
• allPost2024.11.15How I Improved My Online Casino Neonix In One Easy Lesson

Dillard's - The Style of Your Life.