Shulou(Shulou.com)06/03 Report--

Chapter 3 Tutorial

Chapter III tutoring course

Table of Contents

Catalogue

3.1 Connecting to and Disconnecting from the Server

3.1 Connect and disconnect from the server

3.2 Entering Queries

3.2 enter query

3.3 Creating and Using a Database

3.3 create and use databases

3.4 Getting Information About Databases and Tables

3.4 get information about databases and tables

3.5 Using mysql in Batch Mode

3.5 using mysql in batch mode

3.6 Examples of Common Queries

3.6 examples of common queries

3.7 Using MySQL with Apache

3.7Using Mysql in Apache

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. Mysql (sometimes referred to as the "terminal monitor" or just "monitor") is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. Mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute the contents of the file. Both ways of using mysql are covered here.

This chapter provides an introduction to MySQL tutorials by showing how to use mysql client programs to create and use simple databases. Mysql (sometimes called "terminal monitor" or "monitor") is an interactive program that connects to a MySQL server, runs queries, and views results. Mysql may also be used in batch mode: you first put the query in a file, and then tell mysql to execute the contents of the file. Here are two ways to use mysql.

To see a list of options provided by mysql, invoke it with the-- help option:

To view a list of options provided by mysql, use the following-- help option to invoke it:

Shell > mysql-- help

This chapter assumes that mysql is installed on your machine and that a MySQL server is available to which you can connect. If this is not true, contact your MySQL administrator. (If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 5, MySQL Server Administration.)

This chapter assumes that you have mysql installed on your machine and that you can connect using a MySQL server. If this is not correct, contact your MySQL administrator. (if you are an administrator, you need to refer to the relevant sections of this manual, such as Chapter 5, MySQL Server Administration. )

This chapter describes the entire process of setting up and using a database. If you are interested only in accessing an existing database, you may want to skip over the sections that describe how to create the database and the tables it contains.

This chapter describes the entire process of setting up and using a database. If you are only interested in accessing an existing database, you may want to skip the section that describes how to create the database and the tables it contains.

Because this chapter is tutorial in nature, many details are necessarily omitted. Consult the relevant sections of the manual for more information on the topics covered here.

Because this chapter is a tutorial, many details are bound to be omitted. For more information about the topics covered in this article, see the relevant sections of the manual.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.