Page 74 - Computer Software Application TP - Volume 1
P. 74

COMPUTER SOFTWARE APPLICATION - CITS




           EXERCISE 20 : Creating and Using a Database in MySQL


            Objectives

            At the end of this exercise you shall be able to
           •  create the database & use it
           •  create the table and use it & perform insert ,Select,update and delete queries


           Requirements


           Tools/Materials
           •   Operating System: Windows 10 or 11 (64-bit)
           •   MySQL Setup Software
           •  Desktop/Laptop will latest configuration


           Procedure

           TASK 1 : Creating and Using a Database in MySQL

           1  Open the MySQL Command Line Client:
              Windows: Search for “MySQL Shell” or “mysql.exe” in the Start menu.
              macOS/Linux: Open a terminal and type mysql (if installed globally) or path/to/your/mysql/bin/mysql.




































           2  Connect to the MySQL Server:
           Type mysql -u root -p
           Enter your root password when prompted.









                                                           59
   69   70   71   72   73   74   75   76   77   78   79