having an issue with MySQL and my issue is that I need to retrieve the rows and columns, but I can only retrieve the columns and not the rows of the ORDERS table, but when I use other tables (like the ITEM table) it works and i don't know what the problem is.
having an issue with MySQL and my issue is that I need to retrieve the rows and columns, but I can only retrieve the columns and not the rows of the ORDERS table, but when I use other tables (like the ITEM table) it works and i don't know what the problem is.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
I having an issue with MySQL and my issue is that I need to retrieve the rows and columns, but I can only retrieve the columns and not the rows of the ORDERS table, but when I use other tables (like the ITEM table) it works and i don't know what the problem is.
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*
SQL File 10* x
SCHEMAS
Dont Limit
Q Filter objects
19
('DL51', 'Classic Train Set',12.00, 'TOY','3',107.95);
20 •
INSERT INTO ITEM
E sys
A Tables
A Views
A Stored Procedures
A Functions
VALUES
('DR67', 'Giant Star Brain Teaser',24.00, 'PZL', '2',31.95);
INSERT INTO ITEM
21
22
23 •
24
VALUES
('DW23', 'Mancala',40.00, 'GME','3',50.00);
INSERT INTO ITEM
25
26 •
27
VALUES
28
('FD11', 'Rocking Horse',8.00,'TOY','3',124.95);
29 .
INSERT INTO ITEM
30
VALUES
('FH24', 'Puzzle Gift Set',65.00, 'PZL','1',38.95);
INSERT INTO ITEM
31
32 •
33
VALUES
('KA12', 'Cribbage Set',56.00, 'GME','3',75.00);
INSERT INTO ITEM
34
35 •
36
VALUES
37
('KD34', 'Pentominoes Brain Teaser', 60.00, 'PZL','2',14.95);
38 •
INSERT INTO ITEM
39
VALUES
40
('KL78', 'Pick Up Sticks',110.00, 'GME','1',10.95);
41
INSERT INTO ITEM
42
VALUES
43
('MT03', 'Zauberkasten Brain Teaser',45.00, 'PZL','1',45.79);
44
INSERT INTO ITEM
45
VALUES
46
('NL89', 'Wood Block Set (62 piece)',32.00, 'TOY','3',119.75);
47 •
INSERT INTO ITEM
VALUES
('TR40', 'Tic Tac Toe',75.00, 'GME','2',13.99);
INSERT INTO ITEM
VALUES
48
49
50 •
51
('TW35','Fire Engine',30.00, 'TOY','2',118.95);
SELECT * FROM ITEM
52
53 •
Result Grid I 0 Filter Rows:
Edit: A 5 & Export/Import: A 8 wrap Cell Content: IA
ПЕМ NUM
DESCRIPTION
ON_HAND
CATEGORY
STOREHOUSE
PRICE
AH74
22.99
Result
Grid
Patience
GME
BR23
Skittles
21
GME
2
29.99
CD33
Wood Block Set (48 piece)
36
ΤΟΥ
1
89.49
DL51
Classic Train Set
12
TOY
107.95
Form
DR67
Giant Star Brain Teaser
24
PZL
2.
31.95
Editor
Administration Schemas
DW23
Mancala
40
GME
50.00
FD11
Rocking Horse
8
TOY
124.95
Information
IТЕМ З Х
Аpply
Revert
Schema: sys
Output
A Action Output
23
Time
Action
Message
Duration / Fetch
488 12:11:13 SELECT * FROM ORDERS
O row(s) retumed
0.000 sec / 0.000 sec
489 12:15:58 SELECT FROM ITEM
15 row(s) retumed
0.000 sec / 0.000 sec
Object Info
Session
Query Completed
| |
12:16 PM
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:
SQL File 3*
SQL chapter 3*
SQL File 9
SQL File 8*
SQL File 10* x
SCHEMAS
Dont Limit
Q Filter objects
CREATE TABLE ORDERS
2
E (ORDER NUM CHAR(5) PRIMARY KEY,
E sys
A Tables
A Views
A Stored Procedures
A Functions
ORDER_DATE DATE,
CUSTOMER_NUM CHAR(3) );
INSERT INTO ORDERS
VALUES
('51608', '10-12-2015','126');
INSERT INTO ORDERS
7
8 •
VALUES
10
('51610', '10-12-2015','334');
11 •
INSERT INTO ORDERS
VALUES
('51613','10-13-2015','386');
INSERT INTO ORDERS
12
13
14 •
15
VALUES
('51614','10-13-2015','260');
INSERT INTO ORDERS
16
18
VALUES
19
('51617', '10-15-2015','586');
20
INSERT INTO ORDERS
21
VAL
('51619','10-15-2015','126');
INSERT INTO ORDERS
22
23 .
24
VALUES
25
('51623','10-15-2015','586');
26 •
INSERT INTO ORDERS
27
VALUES
('51625','10-16-2015','796');
SELECT * FROM ORDERS;
28
29 •
Result Grid I O Filter Rows:
Edit: A 3 & Export/Import: A 6 Wrap Cell Content: IA
ORDER_NUM ORDER DATE
NULL
CUSTOMER_NUM
NULL
Result
Grid
NULL
Form
Editor
Administration Schemas
Information
ORDERS 2 X
Apply
Revert
Schema: sys
Output
A Action Output
23
Time
Action
Message
Duration / Fetch
487 12:10:27 SELECT FROM ORDER_LINE
5 row(s) retumed
0.000 sec / 0.000 sec
488 12:11:13 SELECT * FROM ORDERS
O row(s) retumed
0.000 sec / 0.000 sec
Object Info
Session
Query Completed
| |
12:11 PM
O Type here to search
O
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.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education