MySQL Database System Overview, mysql database Overview

MySQL Database System Overview, mysql database Overview

Understand the MySQL database management system as follows:
 
I. Database-based PHP Project
 
Currently, dynamic websites are all based on databases and use the database management system to manage website content.
 
Users, columns, images, articles, and comments are stored in the database.
 
XSCMS
 
Users
 
Clumn
 
Pic
 
Articles
 
Commtents
 
Ii. Why MySQL (Overview)
 
Oracle DB2 SQL Server .....
 
Use MySQL in PHP
 
PHP + MySQL Gold partner
 

 

 
Iii. MySQL Architecture
 
C/s client/server
 
MySQL DBMS
 
Client Server-database-data table-(record, field)
 

 
4. PHP programmers mainly learn about database operations
 
DBA
 
Programmer
 
1. Design a table for your project
 
Ii. use SQL statements (SQL programming)
 
All can be done using tools
 
V. MySQL installation and Startup Process
 
Linux Installation
Windows Installation
 
Integration with PHP


 
Vi. directory structure of MySQL
My. ini bin/data/
 
7. Understand Database SQL statement operations

Structured Query Language)
 
DDL
Create database Name
Create table [database name.] table Name use Database Name
 
Drop database Name
Drop table Name
DML
Insert into users (id, name) values ('1', 'hangsan ');
Update users set name = 'A', age = '10' where id = '1 ';
Delete from table name where id = '2 ';
 
DQL
Select * from table name;
 
DCL
 
\ S view status
Show databases view all databases
Show tables
Desc View table structure
Variables in the show variables configuration file

 

1. Execute SQL statements and connect to the Database Server

 
2. Create Database xsphpdb
 
3. Select a database as the default database
 
Help usage
? Content to be queried