Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
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.

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 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
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 • • • • .
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
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Encryption and Decryption
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.
Similar questions
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS