MySQL Database System Overview, mysql database Overview

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.