MySQL Database Basics-up

How the Web works and the MySQL database management system

Dynamic Web site is the operation of the database,

MySQL database selection is mainly due to its open source, free, simple configuration, good stability, excellent performance

MySQL database management system is C/s structure

MySQL database learns those operations and the classification of SQL statements

Database main learning of four items: increase, delete, change, check

Contents, data table, database, fields

increase, delete, change, check the database

increase, delete, change, check the data sheet

increase, delete, change, check the data field

increase, delete, change, check the contents of the data

SQL statements: Structured query statements

• SQL statement structure is concise, powerful, easy to learn, relational database can be used.

SQL statements are divided into 4 categories:

• Database definition language (DDL)
• Database manipulation Language (DML)
• Database Query Language (DQL)
• Database Control Language (DCL)

MySQL actual operation configuration environment variable (cmd start xampp under MySQL)

• Copy xampp under MySQL's Bin directory to system environment variables
• Detailed Practice: Right-click Computer, properties, advanced system settings, environment variables----new value------------------------"

MySQL Database Basics-up