MySQL

MySQL Database-source installationTags: mysqlOne: Uninstall the old versionUse the following command to check if MySQL Server is installedRpm-qa | grep MySQLSome words are unloaded by the following commandRPM-E MySQL//normal Delete modeRpm-e–nodeps

--Complete the SQL exercises in the project footage and save the written SQL files and runs, and then submit them as jobs.--Design a student performance database that contains information about students, teachers, courses and accomplishments, and

The explain command is the first recommended command to address database performance, and most performance issues can be easily resolved with this command, explain can be used to see how SQL statements are executed, to help select better indexes

Advanced Knowledge Explained:First, Index knowledge:1. The concept of indexing: a data structure for quick find (sort).2. mysql Innerdb engine tries btree tree to store index values.3. Clustered index Concept: The primary key is generally clustered

Commonly used in a total of 4 methods, as follows: 1. Using the Locate () method1.1. General Usage:SELECT ' column ' from ' Table ' where locate (' keyword ', ' condition ') >0Java-like indexOf (), but locate () can only find the returned result is

1) Whether MySQL is installed in CHEKC CentOS[Email protected] mysql]# Rpm-qa | grep mariadbMariadb-libs-5.5.52-1.el7.x86_642) uninstallation process[Email protected] mysql]# rpm-e--nodeps mariadb-libs-5.5.52-1.el7.x86_643) installation processThe

Recently encountered a demandThe original data is as follows:Mysql> select Id,sdkname,sid,date,total_count from U1ge_query_log;+------+----------------+------+------------+-------------+| ID | Sdkname | Sid | Date | Total_count |+------+-------------

1. Log in to MySQL[Email protected] ~]# mysql-u root-pEnter Password:2. Turn on remote connectionsGRANT all privileges on * * to ' root ' @ '% ' identified by ' [e-mail protected] ' with GRANT OPTION;Root for MySQL user, [email protected] for user

Go to GitHub download the identity server4 with EF Core integrated source code, the source address is: https://github.com/IdentityServer/IdentityServer4.EntityFrameworkOpen the project, set the host project as the startup project, add

One, CMD-based operation1. Database folder:Create Database db1; #创建数据库db1Drop database db1; #删除数据库db1Show databases db1; #查看文件db1Use db1; #切换到t1文件2. Data sheet:Build table:CREATE TABLE T1 user table (id int auto_increment primary key,num

Table structure:1 CREATE TABLE IF not EXISTS`User` (2`user_id`int( One) not NULLCOMMENT'PRIMARY Key',3' User_level 'int( One) not NULL DEFAULT 0COMMENT'level',4`user_name`varchar( +) not NULL DEFAULT 0COMMENT'name',5' server_id 'int( One) not NULL

This morning, I spit up the Oracle SQL performance optimization of the 40 military, many of the rules are also applicable to MySQL, the results of this evening found this article-the exhaustion of the power of the MySQL database compiled 32 rules ,

. Double-click the. msi installation package　　2. Tick agree, next3. Always next, encounter the pop-up window select OK, then click Execute4.check OK then click Next5.next6. Set the root password, next7. No brain next, come to the error-prone

1, the unloading system comes with the Mariadb-lib[Email protected]linux ~]# rpm-qa|grep mariadbMariadb-libs-5.5.44-2.el7.centos.x86_64[Email protected] ~]# rpm-e mariadb-libs-5.5.44-2.el7.centos.x86_64--nodeps2. Download RPM installation PackageGo

1. Performance degradation, SQL execution time reason: query statement did not write well, index invalid, associated too many joins, server parameters set unreasonable (joinbuffer size, sortbuffer size, maximum number of connections)2. use join

1, Stop the service:Service Mysqld Stop2, modify MY.CNF:1 vim/etc/my.cnf23# Add 4 skip-grant-tables3. Start the service:Service mysqld Start4. Login and Change Password:1 # Login Database 2 MySQL 3 # Change Password 4 Update Mysql.user set Password=

Troubleshoot remote connections MySQL error 1130Remotely connect to MySQL server's database, error code is 1130,error 1130:host xxx.xxx.xxx.xxx are not allowed to connect to this MySQL serverConjecture is a problem with user permissions that cannot

Multi-Table query and Table query /*Create a one-to-many tableMain table: Product category Table categoryFrom table: Product table productsProducts uses the primary key in category as the foreign key*/-- Create a product category table category:

MySQL 5.7 in windows, modify the max_allowed_packet variable, mysqlallowedpacket(1) The following error occurs during SQL Execution: ### Cause: com. mysql. jdbc. packetTooBigException: Packet for query is too large (38708097> 4194304 ). you can

Create, view, and insert MySQL Data Tables.Data Table: a data table (or table) is one of the most important components of a database and the basis of other objects. 1. First, open a database (here I open a new aaa database ). Open the database: use +