A program that youve written to extract the data from

This preview shows page 23 - 28 out of 475 pages.

a program that you've written to extract the data from the form. These programs are mostoften written as CGI scripts and Java servlets, but they can also be implemented byembedding programming commands directly inside the HTML page. We will look at all ofthese methods later in this book.
Now your program knows what the user is asking for or wishes to add to the database. Theprogram issues an SQL query or update, and the database magically takes care of the rest.Any results obtained from the database can be formatted by your program into a new HTMLpage to send back to the user.only for RuBoard - do not distribute or recompile
only for RuBoard - do not distribute or recompile1.6 What You GetMySQL is a relational database management system. It includes not only a server process tomanage databases, but also tools for accessing the databases and building applicationsagainst those databases. Among these tools are:mysqlExecutes SQL against MySQL, and can be used to execute SQL commands stored in afilemysqlaccessManages usersmysqladminEnables you to manage the database server, including the creation and deletion ofdatabasesmysqldThe actual MySQL server processmysqldumpDumps the definition and contents of a MySQL database or table to a filemysqlhotcopyPerforms a hot backup of a MySQL databasemysqlimportImports data in different file formats into a MySQL tablemysqlshowShows information about the MySQL server and any objects (such as databases andtables) in that serversafe_mysqldormysqld_safeSafely starts up and manages themysqldprocess on a Unix machineOver the course of this book, we will go into the details of each of these tools. How you usethese tools and this book will depend on how you want to use MySQL.Are you a database administrator (DBA) responsible for the MySQL runtime environment?The chief concerns of a DBA are the installation, maintenance, security, and performance ofMySQL. We tackle these issues inPart II.Are you a database or application architect responsible for the design of solid databaseapplications? We address the impact of MySQL on these issues in the first few chapters of
Part III.Are you a database application developer responsible for building applications that rely on adatabase? Database application developers need tools for providing their applications withdata from MySQL. Most ofPart IIIcovers the various programming APIs that supportapplication interaction with MySQL.No matter who you are, you need to know the language spoken by MySQL: SQL. Like mostdatabase engines, MySQL supports the ANSI SQL2 standard with proprietary extensions.Chapter 3is a comprehensive tutorial on MySQL's dialect of SQL. The details of thelanguage are covered inPart IV.only for RuBoard - do not distribute or recompile
only for RuBoard - do not distribute or recompileChapter 2. InstallationThis chapter describes how to download and install MySQL. MySQL is available for a widevariety of target operating systems. In this chapter, we provide an overview of how to install

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 475 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture