MySQL Database system overview

Learn about MySQL database management system, which reads as follows:

A database-based PHP project

The current dynamic site is based on the database, the site content using the database management system to manage

Users, columns, pictures, articles, comments are stored in the database

Xscms

Users

Clumn

Pic

Articles

Commtents

Second, why to choose to use MySQL (overview)

Oracle DB2 SQL Server .....

PHP to choose to use MySQL

Php+mysql Gold Partner





Third, the MySQL architecture

C/S Client/server

MySQL DBMS

Client Server-Database---data table-(record, field)



PHP programmers mainly learn the operation of those databases

Dba

Programmers

First, design the table for your project

II. using SQL statements (SQL Programming)

Can all be done using tools

V. Installation and startup process of MySQL

Linux Installation
Window installation

and PHP Integration



VI. directory structure of MySQL
My.ini bin/data/

Vii. Understanding the SQL statement operations of the database

SQL (structured Query Language)

Ddl
Create DATABASE library Name
CREATE table [library name.] Table name Use library name

Drop DATABASE Database name
DROP table Name
Dml
INSERT into users (ID, name) VALUES (' 1 ', ' Zhangsan ');
Update users set name= ' AA ', age= ' where id= ' 1 ';
Delete from table name where id= ' 2 ';

DQL
SELECT * from table name;

DCL

\s Look at the state
Show databases See all libraries
Show tables See all Tables
DESC View Table Structure
The variables in the show variables configuration file



1. Execute the SQL statement to connect to the database server


2. Create a database xsphpdb

3. Select a library as the default database

Use of Help
? What to search for

MySQL Database system overview