how to make this mysql cli table change to display the dates in mm/dd/yyyy?
how to make this mysql cli table change to display the dates in mm/dd/yyyy?
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
how to make this mysql cli table change to display the dates in mm/dd/yyyy?
![My MySQL 8.0 Command Line Client
ERROR 1062 (23000): Duplicate entry '45270' for key 'cruise.PRIMARY'
mysql> Insert into cruise values (45382,8/3/2011,8/10/2011, 'Stevenson', 25);
ERROR 1062 (23000): Duplicate entry '45382' for key 'cruise.PRIMARY'
mysql>
mysql>
mysql>
mysql> select * from cruise;
| CRUISENUM | STARTDATE | ENDDATE | DIRECTOR | SHIPNUM |
9|
20 |
21644 0000-00-00 0000-00-00 | Smith
23007 0000-00-00 0000-00-00 | Chen
24288 0000-00-00 0000-00-00 | Smith
26964
0000-00-00 0000-00-00 | Gomez
27045
0000-00-00
0000-00-00
9
20
0000-00-00 | Adams
12
24
28532 0000-00-00
20332
0000-00-00
0000-00-00 | Adams
29191
Jones
0000-00-00 |
Levin
0000-00-00 | Carter
0000-00-00 | Lucas
0000-00-00 | Lucas
42999
42999 0000-00-00
0000-00-00
0000-00-00
Norton
43744 0000-00-00 0000-00-00 | Goldberg
44791 0000-00-00 0000-00-00 Barton
45109 0000-00-00 0000-00-00 | Adams
45231 0000-00-00 0000-00-00 | Davidson
45270 0000-00-00 0000-00-00 | Cohen
45382 0000-00-00 |
0000-00-00
0000-00-00 | Stevenson
29890
29690
35218
35218
42983
42996
42990
0000-00-00
0000-00-00 0000-00-00
mysql>
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
18 rows in set (0.00 sec)
I
12
**
9
20
20
32
32
20
28
28
20
28
41
20
25
25
25
25
*new 1 - Notepad++
File Edit Search View Encoding Language Settings Tools Macro Run Plugins Window ?
lên ch
OPHE
L
15
La ba
150 G 3
new 1 x
2
3
4
5
6
1 Insert into cruise values (21644,7/5/2002,7/1/2002, 'Smith', 9);
Insert into cruise values (23007,8/14/2002,8/24/2002, 'Chen', 20);
Insert into cruise values (24288,3/28/2003,4/4/2003, 'Smith',9);
Insert into cruise values (26964,7/1/2003,7/11/2003, 'Gomez', 20);
Insert into cruise values (27045,7/15/2003,7/22/2003, 'Adams', 12);
Insert into cruise values (28532,8/17/2003,8/24/2003, 'Adams', 12);
Insert into cruise values (29191,12/20/2003,12/27/2003, 'Jones', 9);
Insert into cruise values (29890,1/15/2004, 1/22/2004, 'Levin', 20);
9 Insert into cruise values (35218,2/25/2008,3/5/2008, 'Carter', 32);
10 Insert into cruise values (42983,7/15/2011, 7/22/2011, 'Lucas',28);
11 Insert into cruise values (42996,7/22/2011,7/29/2011, 'Lucas',28);
Insert into cruise values (42999,7/29/2011,8/5/2011, 'Norton',28);
Insert into cruise values (43744,7/25/2011,8/10/2011, 'Goldberg', 41);
Insert into cruise values (44791,7/21/2011,7/28/2011, 'Barton', 20);
15 Insert into cruise values (45109,7/2/2011, 7/9/2011, 'Adams', 25);
16 Insert into cruise values (45231,7/9/2011,7/16/2011, 'Davidson', 25);
17 Insert into cruise values (45270,7/16/2011,8/3/2011, 'Cohen',25);
18 Insert into cruise values (45382,8/3/2011,8/10/2011, 'Stevenson',25);
19
12
13
14
7](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F432934f5-038b-441a-9abc-66d6c6189f7b%2F342e8a09-afa1-4f32-9d8e-7b1a2f1c6a2e%2Frbr7qmt_processed.png&w=3840&q=75)
Transcribed Image Text:My MySQL 8.0 Command Line Client
ERROR 1062 (23000): Duplicate entry '45270' for key 'cruise.PRIMARY'
mysql> Insert into cruise values (45382,8/3/2011,8/10/2011, 'Stevenson', 25);
ERROR 1062 (23000): Duplicate entry '45382' for key 'cruise.PRIMARY'
mysql>
mysql>
mysql>
mysql> select * from cruise;
| CRUISENUM | STARTDATE | ENDDATE | DIRECTOR | SHIPNUM |
9|
20 |
21644 0000-00-00 0000-00-00 | Smith
23007 0000-00-00 0000-00-00 | Chen
24288 0000-00-00 0000-00-00 | Smith
26964
0000-00-00 0000-00-00 | Gomez
27045
0000-00-00
0000-00-00
9
20
0000-00-00 | Adams
12
24
28532 0000-00-00
20332
0000-00-00
0000-00-00 | Adams
29191
Jones
0000-00-00 |
Levin
0000-00-00 | Carter
0000-00-00 | Lucas
0000-00-00 | Lucas
42999
42999 0000-00-00
0000-00-00
0000-00-00
Norton
43744 0000-00-00 0000-00-00 | Goldberg
44791 0000-00-00 0000-00-00 Barton
45109 0000-00-00 0000-00-00 | Adams
45231 0000-00-00 0000-00-00 | Davidson
45270 0000-00-00 0000-00-00 | Cohen
45382 0000-00-00 |
0000-00-00
0000-00-00 | Stevenson
29890
29690
35218
35218
42983
42996
42990
0000-00-00
0000-00-00 0000-00-00
mysql>
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
0000-00-00
18 rows in set (0.00 sec)
I
12
**
9
20
20
32
32
20
28
28
20
28
41
20
25
25
25
25
*new 1 - Notepad++
File Edit Search View Encoding Language Settings Tools Macro Run Plugins Window ?
lên ch
OPHE
L
15
La ba
150 G 3
new 1 x
2
3
4
5
6
1 Insert into cruise values (21644,7/5/2002,7/1/2002, 'Smith', 9);
Insert into cruise values (23007,8/14/2002,8/24/2002, 'Chen', 20);
Insert into cruise values (24288,3/28/2003,4/4/2003, 'Smith',9);
Insert into cruise values (26964,7/1/2003,7/11/2003, 'Gomez', 20);
Insert into cruise values (27045,7/15/2003,7/22/2003, 'Adams', 12);
Insert into cruise values (28532,8/17/2003,8/24/2003, 'Adams', 12);
Insert into cruise values (29191,12/20/2003,12/27/2003, 'Jones', 9);
Insert into cruise values (29890,1/15/2004, 1/22/2004, 'Levin', 20);
9 Insert into cruise values (35218,2/25/2008,3/5/2008, 'Carter', 32);
10 Insert into cruise values (42983,7/15/2011, 7/22/2011, 'Lucas',28);
11 Insert into cruise values (42996,7/22/2011,7/29/2011, 'Lucas',28);
Insert into cruise values (42999,7/29/2011,8/5/2011, 'Norton',28);
Insert into cruise values (43744,7/25/2011,8/10/2011, 'Goldberg', 41);
Insert into cruise values (44791,7/21/2011,7/28/2011, 'Barton', 20);
15 Insert into cruise values (45109,7/2/2011, 7/9/2011, 'Adams', 25);
16 Insert into cruise values (45231,7/9/2011,7/16/2011, 'Davidson', 25);
17 Insert into cruise values (45270,7/16/2011,8/3/2011, 'Cohen',25);
18 Insert into cruise values (45382,8/3/2011,8/10/2011, 'Stevenson',25);
19
12
13
14
7
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education