Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 129 - CodePilot V5.0 C8
P. 129

    MySQL

     See the following tables:
                     MySQL is an open-source RDBMS software. It uses a query language called SQL. Some of its
     Order Table     important features include:
     Order_ID  Product_ID   Order_Quantity  Customer_Name    MySQL is free and open-source.
     O001  P101  2  Aarav Sharma    Ideal for both small and large applications.

     O002  P102  1  Priya Patel    Very fast, reliable, scalable and easy to use.
     O003  P101  1  Rahul Verma    Cross-platform and compliant with the ANSI SQL standard.

     O004  P103  3  Sneha Iyer    Developed, distributed and supported by Oracle Corporation.

     Product Table       Runs on all operating systems, including Linux, Unix and Windows.
     Product_ID  Product_Name  Price  Stock_Quantity  You can install the MySQL Installer by downloading it from the official MySQL website:

     P101  Laptop  50000  20  https://dev.mysql.com/downloads
     P102  Smartphone  25000  50  Follow the installation instructions.

     P103  Headphones  1500  100  https://orangewebsupport.co.in/CodepilotV5.0_C8/MySQL_Server_Installation.pdf
     P104  Mouse  800  200
                     STARTING MYSQL SERVER APPLICATION
     Now, answer the following questions:
                     The steps to start MySQL Server application are as follows:
     (a)  Name the primary key in the Product Table.

     (b)  How many records or tuples exist in the Order Table.
     (c)  Name the key that creates the relationship between the Order Table and the Product Table.
                      2  Click on the All option.

     INTRODUCTION TO SQL

     SQL stands for Structured Query Language. It is the standard language for managing relational
     databases and performing various operations on the data in the tables. SQL enable us to store,
     retrieve and manipulate data in the form of tables.                                       3  Click on the MySQL 8.0
                                                                                              Command Line Client option.

     High   Integrates
     Easy to    Performance   Free of   Provides   with    Ensures   Enables
     use  and   Cost  Offers   High   Various   Data   Multi-user   1  Click on the Start button.
     Efficiency  Portability  Security  Platforms  Integrity  Access

     Key Features of SQL

                                                                                4  Enter the password and press the Enter key.

     SQL was developed by IBM researchers Raymond Boyce and Donald Chamberlin in the 1970s.

                                                                                                                      127
                                                                                              MySQL: My First Database

| 124 125 126 127 128 129 130 131 132 133 134 |