I'm having issues with MySQL and my issue is with the orders table where the columns are retrieved but the rows aren't and it's only the orders table and I include the order_line table and it works correctly.
I'm having issues with MySQL and my issue is with the orders table where the columns are retrieved but the rows aren't and it's only the orders table and I include the order_line table and it works correctly.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
So I'm having issues with MySQL and my issue is with the orders table where the columns are retrieved but the rows aren't and it's only the orders table and I include the order_line table and it works correctly.
Transcribed Image Text:MYSQL Workbench
Local instance MYSQL80 (sys) x
File
Edit
View
Query Database Server
Tools Scripting
Help
Navigator:
SQL File 3*
SQL chapter 3*
SQL File 9*
SQL File 8*
SCHEMAS
Dont Limit
Q Filter objects
77
INSERT INTO CUSTOMER
78
E sys
A Tables
A Views
A Stored Procedures
A Functions
VALUES
('79 Execute the statement under the keyboard cursor orthfield', 'CA', '90098',124.75,7500.00, '45');
INSERT INTO CUSTOMER
VALUES
79
80
81
('824', 'Kline''s','945 Gilham St.', 'Mesa','CA', '90104',2475.99,15000.00, '30');
INSERT INTO CUSTOMER
82
83
84
VALUES
85
('893', 'All Season Gifts','382 Wildwood Ave.','Fullton', 'CA', '90085',935.75,7500.00,'15');
86
INSERT INTO ORDERS
87
VALUES
('51608','10-12-2015','126');
INSERT INTO ORDERS
88
89
90
VALUES
91
('51610', '10-12-2015','334');
92
INSERT INTO ORDERS
VALUES
('51613','10-13-2015','386');
INSERT INTO ORDERS
93
94
95
96
VALUES
614','10-13-2015','260');
INSERT INTO ORDERS
97
98
VALUES
('51617','10-15-2015', '586');
INSERT INTO ORDERS
99
100
101
102
VALUES
103
('51619', '10-15-2015','126');
104
INSERT INTO ORDERS
105
VALUES
('51623','10-15-2015','586');
INSERT INTO ORDERS
106
107
108
VALUES
('51625','10-16-2015','796');
SELECT * FROM ORDERS;
109
110
111 •
INSERT INTO ITEM
112
VALLIES
Result GridE
A Filter Rows:
Edit: 4 3 Export/Import: A 6 Wrap Cell Content: IA
CUSTOMER_NUM
ORDER_NUM ORDER DATE
NULL
Result
Grid
NULL
NULL
Form
Editor
Administration Schemas
Information
ORDERS 28 x
Apply
Revert
Schema: sys
Output
A Action Output
23
Time
Action
Message
Duration / Fetch
473 09:17:17 select "from orders
O row(s) retumed
0.000 sec / 0.000 sec
474 10:29:44 SELECT * FROM ORDERS
O row(s) retumed
0.000 sec / 0.000 sec
Object Info
Session
Query Completed
10:29 AM
O Type here to search
O
4/13/2021
Transcribed Image Text:MYSQL Workbench
Local instance MYSQL80 (sys) x
File
Edit View
Query Database Server
Tools Scripting
Help
Navigator: s
SQL File 3*
SQL chapter 3*
SQL File 9*
SQL File 8*
SCHEMAS
Dont Limit
Q Filter objects
158 •
INSERT INTO ORDER_LINE
VALUES
('51610', 'KL78',25.00,10.95);
INSERT INTO ORDER LINE
159
E sys
A Tables
A Views
A Stored Procedures
A Functions
160
161 •
162
VALUES
('51610', 'TR40',10.00,13.99);
INSERT INTO ORDER_LINE
163
164 •
165
VALUES
('51613', 'DL51',5.00,104.95);
INSERT INTO ORDER_LINE
166
167 •
168
VALUES
('51614', 'FD11',1.00,124.95);
INSERT INTO ORDER_LINE
VALUES
('51617', 'NL89',4.00,115.99);
INSERT INTO ORDER_LINE
169
170 •
171
172
173 •
VALUES
('51617', 'TW35',3.00,116.95);
INSERT INTO ORDER_LINE
VALUES
174
175
176 •
177
('51619','FD11',2.00,121.95);
INSERT INTO ORDER_LINE
178
179 •
180
VALUES
181
('51623', 'DR67',5.00,29.95);
182 •
INSERT INTO ORDER LINE
183
VALUES
('51623', 'FH24',12.00,36.95);
INSERT INTO ORDER LINE
184
185 •
186
VALUES
('51623', 'KD34',10.00,13.10);
INSERT INTO ORDER_LINE
187
188 •
VALUES
('51625', 'MT03',8.00,45.79);
SELECT * FROM ORDER_LINE;
189
190
191 •
192
Result Grid I O Filter Rows:
Edit:
B & Export/Import: A Wrap Cell Content: IA
ORDER NUM ITEM_NUM
NUM ORDERED
QUOTED PRICE
51617
Result
Grid
NL89
4
115.99
51619
FD11
2
121.95
51623
FH24
12
36.95
51623
KD34
10
13. 10
Form
51625
NULL
MT03
NULL
8
45.79
Editor
NULL
NULL
Administration Schemas
Information
ORDER LINE 29 x
Аpply
Revert
Schema: sys
Output
A Action Output
23
Time
Action
Message
Duration / Fetch
474 10:29:44 SELECT FROM ORDERS
O row(s) retumed
0.000 sec / 0.000 sec
475 10:30:04 SELECT FROM ORDER_LINE
5 row(s) retumed
0.000 sec / 0.000 sec
Object Info Session
Query Completed
10:30 AM
O Type here to search
4/13/2021
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY