MySQL

8 Key excerpts on "MySQL"

• 

  eBook - PDF

  Software Engineering: The Implementation Phase

  The Implementation Phase

  • Claude Petitpierre(Author)
  • 2006(Publication Date)
  • EPFL PRESS

    (Publisher)

  chapter 6 Database - MySQL 6.1 Introduction Data management is the main purpose for which distributed applications are used, hence the importance of the database support. In the following, we present the basics of SQL (Structured Query Language) and describe the way Java is interfaced to the databases. The chapter is based on MySQL, a powerful Open Source database package. A database is composed of a set of tables like the one shown below. This example has been printed by the SQL interpreter available in the MySQL package. identifier name quantity category price 1 wheel 76 aa,cc 12.45 2 tire 88 bb 62.60 3 door 44 52.20 A table has rows and columns. Each column has a name and contains values of the type attributed to the column. A row is also called a record or a tuple, and a table, a relation – hence the name relational database given to the databases that use such tables. These tables can be filled and their rows can be modified, read and deleted by commands written in the SQL language. There are many variations of the SQL commands, but we have stuck to the one defined by MySQL, for which we have prepared the examples available on the book Web site. The set of SQL statements and operators that are presented in this chapter covers the needs of most applications. 125 126 Database - MySQL 6.1.1 Installing the MySQL Package The MySQL group offer two versions of their package, one of them being offered as free source. Support is only granted to the commercial version. In order to install MySQL, follow the indications found at www.MySQL.org. In this section we assume that the package has been loaded on Windows, in C :\MySQL. In order to protect the database from unauthorized accesses, the administrator can introduce usernames and passwords (see Paragraph 6.12.4), but note that if no administrative function is performed after installation, the database can be used freely, for example to exercise the examples described in this chapter.

  Sign up to read

  Learn more about book
• 

  eBook - PDF

  Developing Windows-Based and Web-Enabled Information Systems

  • Nong Ye, Teresa Wu(Authors)
  • 2014(Publication Date)
  • CRC Press

    (Publisher)

  177 9 MySQL Most relational database systems (RDBSs) adopt the basic syntax of Structured Query Language (SQL) data definition language (DDL) and data manipulation language (DML) discussed in Chapter 8, but may have some minor variations. In this chapter, a widely used open-source database system, MySQL, is introduced. First, the use of DDL and DML in MySQL is illustrated, followed by the discussions on the use of transaction control lan-guage (TCL) and data control language (DCL). Some unique features of MySQL, specifi-cally, the utilities, the tools, and some SQL variations of MySQL, are also introduced. Since MySQL products are enhanced regularly, this chapter only covers the key aspects of this database system. When using a particular system version, it is recommended to consult the user manuals available online (http://www.MySQL.com) for specific details. 9.1 Introduction Currently, the most popular RDB management systems are Oracle (Oracle Corporation), SQL Server (Microsoft), DB2 (IBM), and MySQL (Oracle Corporation). As an open-source database server, MySQL is on the top of the list chosen by the users who are looking for a free or inexpen-sive database management system. Some notable advantages of MySQL include the following: • Ease of use . MySQL is a high-performance but relatively simple database system and is much less complicated to set up and administer than larger systems such as Oracle and DB2. • MySQL supports the SQL standard, which is the language of choice of all modern RDBS systems. • Capability . In MySQL, many clients can connect to the server at the same time. Furthermore, developers can access MySQL interactively using several interfaces to enter queries and view the results. Examples of these interfaces are command-line clients, Web browsers, or X Window system clients. In addition, a variety of interfaces are available for programming languages, such as Perl and Java, just to name a few.

  Sign up to read

  Learn more about book
• 

  No longer available |Learn more

  SQL Pocket Primer

  • Oswald Campesato(Author)
  • 2022(Publication Date)
  • Mercury Learning and Information

    (Publisher)

  Second, there is an important detail that is mentioned in the preface that is worth repeating here: this book is primarily for data scientists who want to increase their knowledge of SQL to manage data in a database. Although this book can be useful for any motivated beginner, its primary purpose is different from books that prepare readers to become database administrators (DBAs).

  Third, there is a section in the middle of this chapter that shows you the SQL statements that create several tables, along with details of purchase orders. This section is a preview of what you will learn in subsequent chapters, and it’s intended primarily for readers who already have a good understanding of SQL statements. However, if you are unfamiliar with the syntax of the SQL statements in that section, there’s no need to worry: you can return to this section after reading subsequent chapters that explain the details of the SQL syntax and functionality.

  WHAT IS MySQL?

  MySQL is an open source database that is portable and provides many features that are available in commercial databases. Oracle is the steward of the MySQL database, and you can download MySQL 8.0 from the following site:

  https://www.MySQL.com/downloads/

  MySQL is a highly popular database that is used by many companies, including Amazon, Google, LinkedIn, Netflix, and Twitter. MySQL is written in C++, whereas the user-level interaction is through SQL. Other add-ons for MySQL can be purchased from Oracle, as well as free third-party tools are available for monitoring and managing MySQL databases.

  If you prefer, MySQL also provides a GUI interface for performing database-related operations. The code samples in this book have been written for MySQL 8, which provides the following new features beyond earlier versions:

  • A transactional data dictionary
  • Improved support for BLOB, TEXT, GEOMETRY, and JSON data types
  • Support for CTEs (common table expressions)
  • Support for window functions

  As you will see in Chapter 6

  Sign up to read

  Learn more about book
• 

  eBook - ePub

  PHP, MySQL, & JavaScript All-in-One For Dummies

  • Richard Blum(Author)
  • 2018(Publication Date)
  • For Dummies

    (Publisher)

  The specific relational database server that I discuss in this book is the MySQL database server. The MySQL server is the most popular database server used in web applications — and for good reason. The following sections describe the features of the MySQL server that make it so popular.

  MySQL features

  The MySQL database server was created by David Axmark, Allan Larsson, and Michael Widenius as an upgrade to the mSQL database server and was first released for general use in 1996. It’s now owned and supported by Oracle but released as open-source software.

  MySQL was originally created to incorporate indexing data to speed up data queries in the mSQL database server, by using the indexed sequential access method (ISAM). It did this by incorporating a special data management algorithm called the MyISAM storage engine. This proved to be a huge success.

  MySQL was initially recognized for its speed of accessing data. The MyISAM data storage and indexing method proved to be a game changer in speeding up data access from other types of DBMS packages. It wasn’t long before the Internet world took notice, and MySQL became the DBMS package of choice for high-volume web applications.

  These days, MySQL has evolved to do more than just fast data queries. Development is continually ongoing to add new features to MySQL. A short list of features includes the following:

  Sign up to read

  Learn more about book
• 

  eBook - PDF

  Technology for Success

  Computer Concepts

  • Cengage, Jennifer Campbell, Mark Ciampa, Barbara Clemens, Steven Freund(Authors)
  • 2019(Publication Date)
  • Cengage Learning EMEA

    (Publisher)

  Module 13: Databases CC 13-25 13 MODULE Summary A database is a collection of data organized in a manner that allows access, retrieval, and report- ing of that data. Data is the lifeblood of most organizations, and databases are entrusted with the critical job of organizing this data, making it easily accessible when needed, and ensuring the data is kept safe and secure. Unlike a spreadsheet, a database can show relationships between tables. A relationship shows how data in one table relates to data in another table. However, the many advan- tages of databases come at a cost; databases are complicated to design and set up, requiring intricate knowledge of the data in order to structure it appropriately. Relational databases rely on relationships between types of data to show how some data is related to other data. Relational databases are best suited to data that can be organized into tables where each record in a table stores the same pieces of information. Most relational databases are managed using Structured Query Language (SQL). The data in a database is accessed through a database management system (DBMS), which is a collection of programs used to interact with and manage data in the database. One common example of a DBMS is Microsoft Access. Others include Oracle Database and MySQL. When you interact with your social media account on a website, you’re using the front-end database user interface that is built using web languages such as HTML, CSS, and JavaScript. Database designers and administrators interact with the database’s back-end, which includes the database server host- ing the data, some aspects of the DBMS, and the database itself. Microsoft Access includes both front-end and back-end elements. Data in a database is organized to allow for quick searches and to support connections between data in relationships.

  Sign up to read

  Learn more about book
• 

  eBook - ePub

  HTML5 and CSS3 All-in-One For Dummies

  • Andy Harris(Author)
  • 2014(Publication Date)
  • For Dummies

    (Publisher)

  Free and open source: MySQL is available at no cost, which makes it quite an attractive alternative. MySQL offers other advantages of open-source software. Because the code is freely available, you can learn exactly how it works. The open-source nature of the tool also means there are likely to be add-ons or variations because it's easy for developers to modify open-source tools.

  Understanding the three-tier architecture

  Modern web programming often uses what's called the three-tiered architecture, as shown in Table 1-2 .

  The user talks to the system through a web browser, which manages HTML code. CSS and JavaScript may also be at the user tier, but everything is handled through the browser. The user then makes a request of the server, which is sometimes passed through a server-side language like PHP. This program then receives a request and processes it, returning HTML back to the client. Many requests involve data, which brings the third (data) tier into play. The web server can package up a request to the data server through SQL. The data server manages the data and prepares a response to the web server, which then makes HTML output back for the user.

  Figure 1-1 provides an overview of the three-tier system.

  Figure 1-1: An overview of the three-tier data model.

  Practicing with MySQL

  MySQL is a server, so it must be installed on a computer in order to work. To practice with MySQL, you have a few options:

  • Run your own copy of MySQL from the command line. If you have MySQL installed on your own machine, you can go to the command line and execute the program directly. This task isn't difficult, but it is tedious.
  • Use phpMyAdmin to interact with your own copy of MySQL. This solution is often the best. phpMyAdmin is a set of PHP programs that allows you to access and manipulate your database through your web browser. If you've set up XAMPP, you've got everything you need. (See Book VIII for more information about XAMPP.) You can also install MySQL and phpMyAdmin without XAMPP, but you should really avoid the headaches of manual configuration, if you can. In this chapter, I do all MySQL through phpMyAdmin, but I show other alternatives in Chapters 2 and 5

  Sign up to read

  Learn more about book
• 

  eBook - ePub

  PHP and MySQL For Dummies

  • Janet Valade(Author)
  • 2009(Publication Date)
  • For Dummies

    (Publisher)

  Part II MySQL Database

  In this part . . .

  This part provides the details of working with a MySQL database. You find out how to use SQL (Structured Query Language) to communicate with MySQL. In addition, you discover how to create a database, change a database, and move data into and out of a database.

  Passage contains an image

  Chapter 4 Building the Database In This Chapter Using SQL to make requests to MySQL Creating a new database Adding information to an existing database Looking at information in an existing database Removing information from an existing database

  A

  fter completing your database design (see Chapter 3 if you haven’t done this yet), you’re ready to turn it into a working database. In this chapter, you find out how to build a database based on your design — and how to move data into and out of it.

  The database design names the database and defines the tables that make up the database. To build the database, you must communicate with MySQL, providing the database name and the table structure. Later, you must communicate with MySQL to add data to (or request information from) the database. The language that you use to communicate with MySQL is SQL. In this chapter, I explain how to create SQL queries and use them to build new databases and interact with existing databases.

  Communicating with MySQL The MySQL server is the manager of your database: It creates new databases. It knows where the databases are stored.

  It stores and retrieves information, guided by the requests, or queries, that it receives.

  To make a request that MySQL can understand, you build an SQL query and send it to the MySQL server. (For a more complete description of the MySQL server, see Chapter 1.) The next two sections detail how to do this.

  Building SQL queries

  SQL (Structured Query Language)

  is the computer language that you use to communicate with MySQL. SQL is almost English; it’s made up largely of English words, put together into strings of words that sound similar to English sentences. In general (fortunately), you don’t need to understand any arcane technical language to write SQL queries that work.

  Sign up to read

  Learn more about book
• 

  eBook - ePub

  PHP & MySQL: Novice to Ninja

  • Tom Butler(Author)
  • 2022(Publication Date)
  • SitePoint

    (Publisher)

  Chapter 3: Introducing MySQL

  As I explained in the last chapter, PHP is a server-side scripting language that lets you insert instructions into your web pages that your web server software will execute before it sends those pages to browsers that request them. We’ve looked at a few basic examples, including generating random numbers and using forms to capture input from a user.

  Now, that’s all well and good, but it really gets interesting when a database is added to the mix. In this chapter, we’ll learn what a database is, and how to work with your own databases using Structured Query Language (SQL).

  An Introduction to Databases

  A database server is a program that can store large amounts of information in an organized format that’s easily accessible through programming languages like PHP. For example, you could tell PHP to look in the database for a list of jokes that you’d like to appear on your website.

  In this example, the jokes would be stored entirely in the database. The advantage of this approach is twofold. First, instead of writing an HTML page for each joke, you could write a single PHP script designed to fetch any joke from the database and display it by generating an HTML page for it on the fly. Second, adding a joke to your website would be a simple matter of inserting the joke into the database. The PHP code would take care of the rest, automatically displaying the new joke along with the others when it fetched the list from the database.

  Let’s run with this example as we look at how data is stored in a database. A database is composed of one or more tables , each of which contains a list of items , or things . For our joke database, we’d probably start with a table called joke that would contain a list of jokes. Each table in a database has one or more columns , or fields . Each column holds a certain piece of information about each item in the table. In our example, our joke table might have one column for the text of the jokes, and another for the dates on which the jokes were added to the database. Each joke stored in this way would be said to be a row or entry

  Sign up to read

  Learn more about book