(N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23...

Transcribed Image Text:

(N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups 000 Calendar Inbox K History (? Help -- F Z HQ employees A S M D G S P Administration A SCHEMAS employees Tables > Local instance 3306 departments dept_emp Columns emp_no dept_no from_date to_date Indexes Foreign Keys Triggers Showing loaded schemas only Object Info Schema: employees Query Completed O Schemas Session DEC 5850 X dept_emp 1. 100% Result Grid emp_no 110022 110039 110085 110114 110183 110228 110303 110344 110386 110420 110511 110567 110725 110765 110800 VIO SELECT * FROM employees.dept_manager; dept_manager 5 Action Output 63 64 65 V 66 * 38:1 salaries Time 10:11:33 10:11:45 10:11:45 10:12:01 Filter Rows: current_dept_emp dept_no d001 |d001 d002 d002 d003 d003 d004 d004 d004 d004 d005 d005 d006 d006 d006 Search from_date 1985-01-01 1991-10-01 1985-01-01 1989-12-17 1985-01-01 1992-03-21 1985-01-01 1988-09-09 1992-08-02 1996-08-30 1985-01-01 1992-04-25 1985-01-01 1989-05-06 1991-09-12 ( MySQL Workbench Untitled * Limit to 2000 rows tv A Edit: to_date 1991-10-01 9999-01-01 1989-12-17 |9999-01-01 1992-03-21 9999-01-01 1988-09-09 1992-08-02 1996-08-30 9999-01-01 1992-04-25 9999-01-01 1989-05-06 1991-09-12 1994-06-28 @ Action SELECT dept_no, emp_no, first_name, last_name FROM employees.current_dept_emp, em... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 zoom dept_manager Export/Import:A d O ? | Mon Dec 5 10:25 AM PC "^^^^^^ Apply 0 Response Error Code: 1052. Column 'emp_no' in field list is amb... 0.00056 sec 24 row(s) returned Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned Result Grid Form Editor BO === Field Types Query Stats Revert Duration / Fetch Time 0.00046 sec / 0.000... 0.0025 sec 0.00038 sec / 0.000... (N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups 000 Calendar Inbox K History (? Help -- F Z HQ employees A Sy M D G S P Administration A SCHEMAS employees Tables Local instance 3306 > departments dept_emp Columns Columns: Indexes Foreign Keys Triggers Showing loaded schemas only Object Info Table: departments Schemas Query Completed emp_no dept_no from_date to_date O dept_no char(4) PK dept_name varchar(40) Session DEC 5850 dept_emp 1. 100% Result Grid dept_no d005 d002 d003 d001 d004 d006 d008 d007 d009 NULL VIO SELECT * FROM employees.departments; departments 1 Action Output 64 X 65 66 67 1:1 salaries Time 10:11:45 10:11:45 10:12:01 10:25:16 Filter Rows: dept_name Development Finance Human Resources Marketing Production current_dept_emp Quality Management Research Sales Supportive Ninjas NULL Search (6 MySQL Workbench Untitled * Limit to 2000 rows tv A Edit: zoom dept_manager Export/Import: Action SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT * FROM employees.departments LIMIT 0, 2000 1 W departments 7 Response 24 row(s) returned Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned 9 row(s) returned O ? | PC Mon Dec 5 10:25 AM "^^^^^^ Apply 0 Result Grid Form Editor FO Field Types ==== Query Stats Revert Duration / Fetch Time 0.00046 sec / 0.000... 0.0025 sec 0.00038 sec / 0.000... 0.0013 sec / 0.00000... (N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups Calendar Inbox O History (? Help K Administration SCHEMAS > employees employees Tables > > > > > employees salaries titles > > Local instance 3306 departments dept_emp dept_manager user Columns: Views Stored Procedures Functions Showing loaded schemas only Object Info Table: employees Schemas Query Completed Session int PK emp_no birth_date date first_name varchar(14) last_name varchar(16) gender hire_date pronoun enum ('M','F') date char(50) DEC LO 5 550 Account dept_emp 1. 100% Result Grid 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 emp_no employees 1 Action Output K VIO SELECT * FROM employees.employees; 65 66 67 68 SCHEMAS Q employees employees Tables 1:1 salaries Time 10:11:45 10:12:01 10:25:16 10:26:15 Filter Rows: birth_date 1953-09-02 1964-06-02 1959-12-03 1954-05-01 1955-01-21 1953-04-20 1957-05-23 1958-02-19 1952-04-19 1963-06-01 1953-11-07 1960-10-04 1963-06-07 1956-02-12 1959-08-19 current_dept_emp $8 Search first_name Georgi Bezalel Parto Chirstian Kyoichi Anneke Tzvetan Saniya Sumant Duangkaew Mary Patricio Eberhardt Berni Guoxiang Limit to 2000 rows 1. SELECT FROM employees.departments; MySQL Workbench Untitled * Limit to 2000 rows Edit: last_name Facello Simmel Bamford Koblick Maliniak Preusig Zielinski Kalloufi Peac Piveteau Sluis Bridgland Terkki Genin Nooteboom tv A zoom M F M M M IF F M F IF F M M M M dept_manager gender Action SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT * FROM employees.departments LIMIT 0, 2000 SELECT * FROM employees.employees LIMIT 0, 2000 Export/Import:A departments ? [1 7 W Fetch rows: hire_date pronoun NULL NULL NULL 1986-06-26 NULL 1985-11-21 1986-08-28 1986-12-01 NULL 1989-09-12 1989-06-02 NULL 1989-02-10 NULL 1994-09-15 NULL 1985-02-18 NULL 1989-08-24 NULL 1990-01-22 1992-12-18 NULL 1985-10-20 1987-03-11 NULL 1987-07-02 NULL NULL NULL employees === HER Response Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned 9 row(s) returned 2000 row(s) returned ?O? PC Mon Dec 5 10:26 AM "^^^^^^ Apply Result Grid Form Editor MO Field Types | Query Stats Revert Duration / Fetch Time 0.0025 sec 0.00038 sec / 0.000... 0.0013 sec / 0.00000... 0.0029 sec / 0.0036... (N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups 000 Calendar Inbox K History (? Help -- F Z HQ employees A S M D G S P Administration A SCHEMAS employees Tables > Local instance 3306 departments dept_emp Columns emp_no dept_no from_date to_date Indexes Foreign Keys Triggers Showing loaded schemas only Object Info Schema: employees Query Completed O Schemas Session DEC 5850 X dept_emp 1. 100% Result Grid emp_no 110022 110039 110085 110114 110183 110228 110303 110344 110386 110420 110511 110567 110725 110765 110800 VIO SELECT * FROM employees.dept_manager; dept_manager 5 Action Output 63 64 65 V 66 * 38:1 salaries Time 10:11:33 10:11:45 10:11:45 10:12:01 Filter Rows: current_dept_emp dept_no d001 |d001 d002 d002 d003 d003 d004 d004 d004 d004 d005 d005 d006 d006 d006 Search from_date 1985-01-01 1991-10-01 1985-01-01 1989-12-17 1985-01-01 1992-03-21 1985-01-01 1988-09-09 1992-08-02 1996-08-30 1985-01-01 1992-04-25 1985-01-01 1989-05-06 1991-09-12 ( MySQL Workbench Untitled * Limit to 2000 rows tv A Edit: to_date 1991-10-01 9999-01-01 1989-12-17 |9999-01-01 1992-03-21 9999-01-01 1988-09-09 1992-08-02 1996-08-30 9999-01-01 1992-04-25 9999-01-01 1989-05-06 1991-09-12 1994-06-28 @ Action SELECT dept_no, emp_no, first_name, last_name FROM employees.current_dept_emp, em... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 zoom dept_manager Export/Import:A d O ? | Mon Dec 5 10:25 AM PC "^^^^^^ Apply 0 Response Error Code: 1052. Column 'emp_no' in field list is amb... 0.00056 sec 24 row(s) returned Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned Result Grid Form Editor BO === Field Types Query Stats Revert Duration / Fetch Time 0.00046 sec / 0.000... 0.0025 sec 0.00038 sec / 0.000... (N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups 000 Calendar Inbox K History (? Help -- F Z HQ employees A Sy M D G S P Administration A SCHEMAS employees Tables Local instance 3306 > departments dept_emp Columns Columns: Indexes Foreign Keys Triggers Showing loaded schemas only Object Info Table: departments Schemas Query Completed emp_no dept_no from_date to_date O dept_no char(4) PK dept_name varchar(40) Session DEC 5850 dept_emp 1. 100% Result Grid dept_no d005 d002 d003 d001 d004 d006 d008 d007 d009 NULL VIO SELECT * FROM employees.departments; departments 1 Action Output 64 X 65 66 67 1:1 salaries Time 10:11:45 10:11:45 10:12:01 10:25:16 Filter Rows: dept_name Development Finance Human Resources Marketing Production current_dept_emp Quality Management Research Sales Supportive Ninjas NULL Search (6 MySQL Workbench Untitled * Limit to 2000 rows tv A Edit: zoom dept_manager Export/Import: Action SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT * FROM employees.departments LIMIT 0, 2000 1 W departments 7 Response 24 row(s) returned Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned 9 row(s) returned O ? | PC Mon Dec 5 10:25 AM "^^^^^^ Apply 0 Result Grid Form Editor FO Field Types ==== Query Stats Revert Duration / Fetch Time 0.00046 sec / 0.000... 0.0025 sec 0.00038 sec / 0.000... 0.0013 sec / 0.00000... (N MySQLWorkbench File Edit View Query Database Server Tools Scripting Help O Account Dashboard Courses 23 Groups Calendar Inbox O History (? Help K Administration SCHEMAS > employees employees Tables > > > > > employees salaries titles > > Local instance 3306 departments dept_emp dept_manager user Columns: Views Stored Procedures Functions Showing loaded schemas only Object Info Table: employees Schemas Query Completed Session int PK emp_no birth_date date first_name varchar(14) last_name varchar(16) gender hire_date pronoun enum ('M','F') date char(50) DEC LO 5 550 Account dept_emp 1. 100% Result Grid 10001 10002 10003 10004 10005 10006 10007 10008 10009 10010 10011 10012 10013 10014 10015 emp_no employees 1 Action Output K VIO SELECT * FROM employees.employees; 65 66 67 68 SCHEMAS Q employees employees Tables 1:1 salaries Time 10:11:45 10:12:01 10:25:16 10:26:15 Filter Rows: birth_date 1953-09-02 1964-06-02 1959-12-03 1954-05-01 1955-01-21 1953-04-20 1957-05-23 1958-02-19 1952-04-19 1963-06-01 1953-11-07 1960-10-04 1963-06-07 1956-02-12 1959-08-19 current_dept_emp $8 Search first_name Georgi Bezalel Parto Chirstian Kyoichi Anneke Tzvetan Saniya Sumant Duangkaew Mary Patricio Eberhardt Berni Guoxiang Limit to 2000 rows 1. SELECT FROM employees.departments; MySQL Workbench Untitled * Limit to 2000 rows Edit: last_name Facello Simmel Bamford Koblick Maliniak Preusig Zielinski Kalloufi Peac Piveteau Sluis Bridgland Terkki Genin Nooteboom tv A zoom M F M M M IF F M F IF F M M M M dept_manager gender Action SELECT dept_no, first_name, last_name FROM employees.current_dept_emp, employees.... SELECT * FROM employees.dept_manager LIMIT 0, 2000 SELECT * FROM employees.departments LIMIT 0, 2000 SELECT * FROM employees.employees LIMIT 0, 2000 Export/Import:A departments ? [1 7 W Fetch rows: hire_date pronoun NULL NULL NULL 1986-06-26 NULL 1985-11-21 1986-08-28 1986-12-01 NULL 1989-09-12 1989-06-02 NULL 1989-02-10 NULL 1994-09-15 NULL 1985-02-18 NULL 1989-08-24 NULL 1990-01-22 1992-12-18 NULL 1985-10-20 1987-03-11 NULL 1987-07-02 NULL NULL NULL employees === HER Response Error Code: 1055. Expression #2 of SELECT list is not... 24 row(s) returned 9 row(s) returned 2000 row(s) returned ?O? PC Mon Dec 5 10:26 AM "^^^^^^ Apply Result Grid Form Editor MO Field Types | Query Stats Revert Duration / Fetch Time 0.0025 sec 0.00038 sec / 0.000... 0.0013 sec / 0.00000... 0.0029 sec / 0.0036...