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?
Chapter7: Working With The Bash Shell
Section: Chapter Questions
Problem 5DE
Related questions
Question
how to make this mysql cli table change to display the dates in mm/dd/yyyy?
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
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
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
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L