Languages and Software to Be Covered (Cont.)

MySQL Database Management System (DBMS)
MySQL is a relational DBMS that runs as a server providing multi-user access to a number of databases. 

       
  <html><body>
  <?php
   $userid   = "wenchen";
   $database = "wenchen";
   $password = "";
   $host     = "undcemmysql.mysql.database.azure.com";

   // Initializing MySQLi
   $conn     = mysqli_init( );

   // Creating an SSL connection
   mysqli_ssl_set( $conn, NULL, NULL, "DigiCertGlobalRootCA.crt.pem", NULL, NULL );

   // Opening a new connection to the MySQL server
   mysqli_real_connect( $conn, $host, $username, $password, $database, 3306 );

   // Connect to the database.
   if ( $conn->connect_errno )
     die( 'Failed to connect to MySQL: ' . $conn->connect_error );
   else
     echo  "Successfully connect to MySQL!";

   // Close the database connection.
   $conn->close( );
  ?>
  </body></html>
               

SQL (Structured Query Language)
A standard language for creating, updating, and querying databases

           


MySQL Workbench
MySQL Workbench is an IDE (integrated development environment) for MySQL database management including design, modeling, development, administration, and maintenance.





      Years ago I used to supply Filofaxes for the mafia.    
      I was involved in very organised crime.    
      – Milton Jones