✅
✅
✅
4460]
(c) Microsoft Corporation. All rights reserved.
C:\Users\RAFAT>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 8.0.40 MySQL Community Server - GPL
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select
bookno,bookname,dateofpublition,CONCAT(DAY(dateofpublition),",",MONTHNAME(dateofpub
lition),",",YEAR(dateofpublition)) as "Starting Date"from b
ookdetails;
+--------+-------------------+-----------------+------------------+
| bookno | bookname | dateofpublition | Starting Date |
+--------+-------------------+-----------------+------------------+
| 1 | MAHABHARAT | 2020-10-01 | 1,October,2020 |
| 2 | RAMAYAN | 2019-11-11 | 11,November,2019 |
| 3 | LE PERE GARIOT | 1835-11-11 | 11,November,1835 |
| 4 | DAVID COPPERFIELD | 1849-12-11 | 11,December,1849 |
| 5 | WAR AND PEACE | 1869-09-08 | 8,September,1869 |
| 6 | HULULU | 1870-09-08 | 8,September,1870 |
| 7 | LALLAA | 1876-01-08 | 8,January,1876 |
| 8 | KOHRE KOHRE SAPNE | 1896-01-02 | 2,January,1896 |
| 9 | SIGMA | 1796-07-05 | 5,July,1796 |
| 10 | SITUATIONSHIP | 1996-02-01 | 1,February,1996 |
+--------+-------------------+-----------------+------------------+
10 rows in set (0.00 sec)
mysql>