Build WAMP environment, database basic knowledge

Server Management software
PHP Apache
. NET IIS
Java Tomcat

Server management software plays a role: the Management Server work, the specific work is as follows:
1. Static page
The user sends the request to the server, the server management software will send the request to the corresponding page, the static page feeds the content to the server management software, and the server management software renders the static page to the user.
2. Dynamic page
The user sends the request to the server, the server management software in the server will send the request to the corresponding page, and the page will be sent to PHP (if the database is used, then PHP and database MySQL establish a link), the page is converted to static feedback to the server management software, the server management software then presents the page to the user.

WAMP: Developing under Windows
1. Build the environment: simulate the server

To modify the database connection password method:

Open the SQL command line, press ENTER on the default, and then enter the statement to change the password:

Use MySQL;

Updatemysql.user set Password=password (123) where user= ' root ';

which

Mysql User name: Root

Mysql Password: modify it yourself

Mysql Server address: localhost

2. Create a database:
int integral type
varchar (length) string
Bit Boolean type
DateTime Date-Time type
Text Long
Money currency
Image storage Binary Data

Data sheet:
Must have:
(1) Column name, type, length;
(2) Primary key: Uniquely identifies a data, each table must have, and primary key columns cannot be duplicated
(3) Type of control column (Index): Unique index, non-null index, unique non-null index
(4) Foreign key: exists between two tables (relationship)
Table Two is referenced in the main table and from table: Table One,
Two columns have a relationship, the column is the primary key is the main table, not just from the table

Design of the database:
Three main paradigms:
First paradigm: Guaranteed column atomicity, relative to function
Second paradigm: Each column is related to the primary key, and each column has a relationship to the table
The third paradigm: Each column is directly related to the primary key

Build WAMP environment, database basic knowledge