Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 73 - 2629_Devagiri_C-8
P. 73

    The MySQL prompt appears, allowing queries to be performed on the MySQL server.
        MySQL

     MySQL is an open-source RDBMS software. It uses a query language called SQL. Some of its

     important features include:
       MySQL is free and open-source.

       Ideal for both small and large applications.
       Very fast, reliable, scalable and easy to use.

       Cross-platform and compliant with the ANSI SQL standard.
       Developed, distributed and supported by Oracle Corporation.
       Runs on all operating systems, including Linux, Unix and Windows.

     You can install the MySQL Installer by downloading it from the official MySQL website:

     https://dev.mysql.com/downloads   PRIVACY PRACTICES
     Follow the installation instructions.  Update  your database  passwords regularly, avoid  reusing them  and always back  up your

     https://orangewebsupport.co.in/CodepilotV5.0_C8/MySQL_Server_Installation.pdf  database work.

     STARTING MYSQL SERVER APPLICATION
     The steps to start MySQL Server application are as follows:
                            SQL DATA TYPES

                     A data  type  defines  the  type  of value that  a column  will contain.  In  a database  table,  every
     2  Click on the All option.  column must have a name and a data type. Some common SQL data types and their descriptions
                     listed below:

                        Data Type                     Description                                 Example

                                                                                    age INT;
                      INTEGER(INT)     Stores whole numbers (no decimals).
                                                                                    Example: 25, 30
                                       Stores  fixed-length character  strings of  gender CHAR(1);
     3  Click on the MySQL 8.0   CHAR(n)
     Command Line Client option.       size n.                                      Example: ‘M’, ‘F’
                                       Stores  variable-length character strings  name VARCHAR(50);
                      VARCHAR(n)
                                       with a maximum size of n.                    Example: ‘Yash Gupta’, ‘Sonia’

     1  Click on the Start button.     Stores  numbers  with precision  p and  price DECIMAL(5,2);

                      DECIMAL(p,s)
                                       scale s.                                     Example: 123.45, 99.99
                                       Stores  date  values in YYYY-MM-DD  birthdate DATE;
                      DATE
                                       format.                                      Example: ‘1990-05-25’

                                       Stores   floating-point   numbers      with temperature FLOAT(5);
     4  Enter the password and press the Enter key.  FLOAT(p)
                                       precision p.                                 Example: 98.6, 35.75

                                                                                    appointment_time TIME;
                      TIME             Stores time values in HH:MM:SS format.
                                                                                    Example: ‘10:30:00’, ‘15:45:00’

                                                                                                                      71
                                                                                              MySQL: My First Database

| 68 69 70 71 72 73 74 75 76 77 78 |