MySQL Study first day

1. Data Warehouse. As with the plain text that we have learned before, properties,xml these techniques. Used to save data. and provide the operation of the data to be added and censored. When we do the project later,

The data in the project is saved in the database.

2, the characteristics of the database

2.1. Realize data sharing
2.2, reduce the redundancy of data

2.3, the data to achieve centralized control

2.4, data consistency, integrity and maintainability to ensure the security and reliability of data

2.5. Failure recovery

3. mysql Installation

There are two mounting positions.

Database service location: MySQL Server
Database data File location: Server data files

The MySQL database administrator name is root.

4. Frequently Asked Questions:
4.1, MySQL uninstall.
4.1.1, run Uninstall program
4.1.2, deleting directories
4.2. Forget to configure character set encoding when installing
The configuration at the time of installation is reflected in the My.ini file. The file is in the same path as the database service. Locate the configuration file to modify the save. To be effective, you need to restart the database (restart the service).
4.3. Forget the administrator password. = = "Refer to the method under the Resource folder.
4.4, forget to check the automatic configuration environment variable.
Locate the bin directory under the database Services installation directory. Configure the directory path under the PATH environment variable.
4.5, install the new version of MySQL, prompted to install the Framework 4.0.

//------------------------------------------------------------------------------------------------------------- ------------------------------------------
5. SQL

DDL database Definition language Data definition Language | | Create Alter drop
DCL Database Control Language-Data Control Language | | Grant rollback commit.
DML Database Manipulation Language Data Manipulation Language | | Insert Update Delete Select
|
DQL database Query Language data Query Language | | Select

6. Comments in SQL
Single line:--
Multiple lines:/* */
Is SQL case insensitive?
Statements are not case-sensitive.
Data is case sensitive.
The end of SQL in MySQL uses ";" The number indicated.

Exit command = Exit

Commands to connect to the database service

Mysql-u root-p

You can establish a connection by entering the password as prompted.

MySQL Study first day