MySQL 5.6 手冊 第三章 目錄

Chapter 3 Tutorial

第三章 輔導(dǎo)教程

Table of Contents  

目錄   

• 3.1 Connecting to and Disconnecting from the Server

• 3.1連接和斷開與服務(wù)器的連接  

• 3.2 Entering Queries

• 3.2輸入查詢

• 3.3 Creating and Using a Database    

• 3.3創(chuàng)建和使用數(shù)據(jù)庫    

• 3.4 Getting Information About Databases and Tables

• 3.4獲取有關(guān)數(shù)據(jù)庫和表的信息

• 3.5 Using mysql in Batch Mode

• 3.5在批處理模式下使用mysql

• 3.6 Examples of Common Queries     

• 3.6常見查詢示例     

• 3.7 Using MySQL with Apache

• 3.7在Apache中使用Mysql

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.

本章通過介紹如何使用mysql客戶端程序來創(chuàng)建和使用簡單的數(shù)據(jù)庫，提供了MySQL的教程介紹。mysql（有時(shí)稱為“ 終端監(jiān)視器 ”或 “ 監(jiān)視器 ”）是一種交互式程序，可以連接到MySQL服務(wù)器，運(yùn)行查詢并查看結(jié)果。 mysql也可能在批處理模式下使用：您先將查詢放在一個(gè)文件中，然后告訴 mysql執(zhí)行該文件的內(nèi)容。這里介紹了使用mysql的兩種方法。

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

要查看mysql提供的選項(xiàng)列表，請使用以下--help選項(xiàng)來調(diào)用它：

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.)

本章假設(shè)您的機(jī)器上安裝了mysql，并且可以使用MySQL服務(wù)器連接。如果這不正確，請與您的MySQL管理員聯(lián)系。（如果 您是管理員，則需要參考本手冊的相關(guān)部分，如 第5章MySQL服務(wù)器管理。）

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.

本章介紹設(shè)置和使用數(shù)據(jù)庫的整個(gè)過程。如果您僅對訪問現(xiàn)有數(shù)據(jù)庫感興趣，可能需要跳過描述如何創(chuàng)建數(shù)據(jù)庫及其包含的表的部分。

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.

因?yàn)楸菊率禽o導(dǎo)教程，許多細(xì)節(jié)必然被省略。有關(guān)本文涉及的主題的更多信息，請參閱手冊的相關(guān)章節(jié)。