Scripting Kid _ Little-mysql Learning Preparation

MySQL Learning Preparation

Briefly:

I. Understanding of database knowledge

Second, the environment construction

Third, MySQL basic operation

I. Understanding of database knowledge

1, why need database management system?

A: It is easy for us to manage the data.

In our daily life, we manage our data in a simple and easy-to-use Notepad to record/query/delete/modify data. So mapping this operation to the computer, we can also use the computer's Notepad tool to complete this function, but, inconvenient, management is also troublesome. At this point, the database management system plays an important role. The database management system is essentially a file on the operating system. (This is because in the end, the file will eventually be stored on disk), but the database management system is a layer of encapsulation, and we are using this layer of encapsulation capabilities.

Approximate Sketch:

2, the common database management system

Msserver, Oracle, MySQL, ETC.,

Note: This series is based on MySQL

Second, the environment construction

1. Select the integrated environment Wampserver

2, after installation, the initial situation, MySQL password is empty, modify the MySQL password

A. Log into MySQL at the command line

b, select database MySQL, with command: Usemysql

C. Use the update command to modify the MySQL user table information

UpdateUser Set Password=password (' root ') where user= ' root ' and host= ' localhost ';

D, after the change, refresh permissions

flushprivileges;

3. How to operate MySQL

A, MySQL comes with MySQL tool, in the installation directory of the bin directory

B, web management tools such as phpMyAdmin

C, third-party tools, etc.

Iii. MySQL basic commands

1. Login Database

2. View all current databases

3. Select a database

4. Help command

Help command word or? Command Word%

The quieter become,the more you is able to hear!

Scripting Kid _ Little-mysql Learning Preparation