Home > Database > Mysql Tutorial > body text

The road to learning MySQL data: MySQL installation and MySQL overview

黄舟
Release: 2017-02-11 11:17:38
Original
1355 people have browsed it

First of all, let’s understand the program structure of MySQL. The following is the program structure diagram of MySQL

The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><h2>MySQL installation:</h2><p>First we need Download the MySQL installation program from the MySQL official website (http://www.php.cn/), and then we install it. The specific steps are as follows: </p><p>Double-click to run the installation program: take Win32 bit as an example<br/></p><p><span   style=The road to learning MySQL data: MySQL installation and MySQL overview<br/></span></p><p>##Select the installation type, there is

The road to learning MySQL data: MySQL installation and MySQL overview<img src=



The road to learning MySQL data: MySQL installation and MySQL overviewConfirm the previous settings, if If there is an error, press


The road to learning MySQL data: MySQL installation and MySQL overviewInstalling, please wait until the following interface appears. <br/></p><p><br/></p><p><img src=


The road to learning MySQL data: MySQL installation and MySQL overviewNow that the software installation is completed, the above interface appears. There is a very good function here, the mysql configuration wizard. You don’t have to do it yourself as before. Manually configure my.ini messily, check the box in front of , click "Finish" to end the software installation and start the mysql configuration wizard.



The road to learning MySQL data: MySQL installation and MySQL overviewMySQL Server Configuration Wizard starts, click


##Select the configuration method, "Detailed Configuration (manual precise configuration)", "Standard Configuration (standard configuration)", we select "Detailed Configuration" to facilitate familiarity with the configuration process. The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p><br/></p><p><br/></p><p>Select the server type,



Choose the general purpose of the mysql database, "Multifunctional Database (general multifunctional, good)", "Transactional Database Only (server type, focused For transaction processing, generally)", The road to learning MySQL data: MySQL installation and MySQL overview



Configuring the InnoDB Tablespace is for the InnoDB database Select a storage space for the file. If it is modified, remember the location and choose the same location when reinstalling, otherwise the database may be damaged. Of course, it will be fine to make a backup of the database. I will not go into details here. There are no modifications here. Use the default location and press "Next" to continue. The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p><br/></p><p>Select the general mysql traffic of your website and the number of simultaneous connections, "Manual Setting (manual setting, enter a number yourself)", I choose "Decision Support (DSS)/OLAP" here, my own server should be enough, press "Next" to continue.

The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p>Whether to enable TCP/IP connection and set the port, if not enabled, you can only access the mysql database on your own machine, I Enable here, tick the previous check, Port Number: 3306. On this page, you can also select

The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p>Note: If you want to use the data from the original database, it is best to determine what encoding the original database uses. If the encoding set here is the same as the original The encoding of database data is inconsistent, and garbled characters may appear when using it. This is more important, which is to set the default database language encoding of MySQL. The first one is Western encoding, and the second one is multi-byte general UTF8 encoding. Neither of them are our common encodings. Choose the third one here, and then select it in Character Select or fill in

The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p>Choose whether to install mysql as a windows service, and you can also specify the Service Name (service identification name), whether Add the bin directory of mysql to Windows PATH (after adding it, you can directly use the files under bin without pointing out the directory name, such as connecting,

The road to learning MySQL data: MySQL installation and MySQL overview<br/></p><p><br/></p><p><img src= previously installed mysql server is completely uninstalled; if not, check whether the previous password has been modified as mentioned in the step above, and follow the above operations; if If it still doesn't work, back up the data folder in the mysql installation directory and then delete it. After the installation is completed, delete the data folder generated by the installation, move the backed up data folder back, and then restart the mysql service. In this case Next, you may need to check the database and repair it to prevent data errors.

SQL Overview

DML:

DML is used to query and modify data records, including the following SQL statements:
INSERT: Add data to the database
UPDATE: Modify the data in the database
DELETE: Delete the data in the database
SELECT: Select (query) data
SELECT is the basis of SQL language and the most important.
DDL:
DDL is used to define the structure of the database, such as creating, modifying or deleting database objects, including the following SQL statements:
CREATE TABLE: Create a database Table
ALTER TABLE: Change table structure, add, delete, modify column length
DROP TABLE: Delete table
CREATE INDEX: Create an index on the table
DROP INDEX: Delete the index
DCL:
DCL is used to control database access, including the following SQL statements:
GRANT: Grant access
REVOKE: Revoke access
COMMIT: Commit transaction
ROLLBACK: Transaction Handling rollback
SAVEPOINT: Set save point
LOCK: Lock a specific part of the database

We have installed MySQL, Here we do a little test:

Log in to the Mysql server
window + r ->cmd->Enter the command line interface
mysql -uroot If this is the case You can log in, which means your database does not have a password set. Execute the following command to set the password
mysql> set password for 'root'@'localhost'=password('123456');
If the above cannot log in, enter
mysql -uroot -p123456, where 123456 is the password I set. Please fill in your own password when filling it in. Press the Enter key and the following interface will appear to indicate successful login.
Next we can enter mysql to use I learned
Common operations are:
Check which databases are currently available:

<span style="color:#330033;">show databases;</span>
Copy after login

Note: Each line of MySQL statement must end with a semicolon in English
Create a new database:

create database company;
Copy after login

Switch the current working database:

use company;
Copy after login

View the current working database:

select database();
Copy after login

Import data or execute SQL script, in Provided that you have the company.sql database and the path is correct:

source d:/mywork/mysql/company.sql;
Copy after login

Check which tables are in the current database:

show tables;
Copy after login

View all data in a table:

select * from employees;
Copy after login

Mysql management mode
mysql server
Database (directory)
Table (file) (equivalent to class)
Record (equivalent to object)
Discard database:

drop database world;
Copy after login

Create table

<span style="white-space:pre">	</span>create table customer(
		id int, 
		age int, 
		name varchar(20)
	);
Copy after login

View table structure: desc[ribe] customer;
Drop table: drop table customer;
Insert data

<span style="white-space:pre">	</span>insert into customer(id, age, name) values(1, 30, &#39;张三&#39;);
	insert into customer(id, age, name) values(2, 40, &#39;李四&#39;);
Copy after login

Update data
##

<span style="white-space:pre">	</span>update customer set age = age + 1;// 更新所有记录, 谨慎使用
	update customer set age = age + 1 where id = 1; // 更新指定的记录
Copy after login

Delete data
##

<span style="white-space:pre">	</span>delete from customer;// 删除所有数据, 谨慎使用!!
	delete from customer where id = 2; // 删除指定的记录
Copy after login


The above is the MySQL installation and MySQL overview of the MySQL data learning journey Content, for more related content, please pay attention to the PHP Chinese website (www.php.cn)!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template