MySQL

First, MySQL installation steps1. Check if MySQL is installed on your Linux systemsudo service MySQL start2. Install MySQL server, core programsudo apt-get install Mysql-server3. Install the MySQL clientsudo apt-get install mysql-clientDuring

First, insert the recordCREATE DATABASEMYDB; UseMYDB;CREATE TABLE IDENTITY(NAMECHAR( -)PRIMARY KEY, BIRTHDATETIME not NULL, HOMECHAR( -));CREATE TABLESTUDENT ( Number INT PRIMARY KEYauto_increment, NAMECHAR( -) not NULL, AgeTINYINT not NULL,

First, MYSQL master-slave replication principle1. Master records These changes in the binary log before each transaction updates the data. After the write binary log is complete, Master notifies the storage engine to commit the transaction.2. Slave

1. Create DATABASE Database-name2. Deleting a database Drop DB dbname3. Creating a new Table CREATE table tabname (col1 type1 [NOT NULL] [primary key],col2 type2 [NOT NULL],..)To create a new table from an existing table:A:CREATE table tab_new like

Sometimes when you start a MySQL database with a command mysql-u root-p or a server, it throws an exception and fails.The following are the anomalies that have been encountered.1, 1) Thrown exception: Error 2002 (HY000): Can ' t connect to local

First, the basic knowledgeA trigger is a specific action triggered by an event such as INSERT, UPDATE, and delete.When trigger conditions are met, the database system executes the program statements defined in the trigger.Second, createThe for every

Mysql>Use mysql;database changedmysql> Show Index fromuser;+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+--- ---+------------+---------+| Table | Non_unique | Key_name | Seq_in_index |

The binary format is installed in the following ways:1. Query the local installation of MySQL database related packages (uninstall) Rpm-qa "mysql*" (CENTOS6) Rpm-qa "mariadb*" (CETOS7) 2. mariadb.org Download the source binary package with the Linux

#! /bin/bashMysqluser=rootMysqlpass=123.comMysqlpath=/usr/mysql/binmysqlprot=3306Start (){If [ netstat -tnlup | grep ‘$mysqlprot‘ | wc -l -lt 1];thenecho "Mysql service try to starting."/bin/sh

The ideal Index Frequent queries High degree of differentiation Small length Try to overwrite common query fields Indexing and sorting When querying directly on an index for overwriting an index, there is a

Btree Index and Hash Index (index is a data structure that improves query, sorting, grouping speed) Btree index data structure is balanced binary tree, time complexity of LGN Hash index data structure is a hash function, time complexity

1.1 Installation DependenciesYum Install Ncurses-devel libaio-devel-yRpm-qa Ncurses-devel Libaio-devel1.2 Installing CMakeYum Install Cmake-yRpm-qa CMake1.3 Creating a MySQL UserUseradd-s/sbin/nologin-m MySQLID MySQL1.4 Download/Unzip the source

Index Overridesmeans that if the column of the query is exactly part of the index, then the query needs to be done only on the index file, without having to go back to the disk and find the data. This query is very fast, called "Index overlay", less

First, the system databaseINFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permission information, character information,

Mysql index, Index name: you can create an index on multiple columns. This index is called composite index (Composite Index) (composite index) I. Create an indexCreate table t1 (id int primary key, username varchar (20), password varchar (20

Reprinted -- MYSQL5.7: Access denied for user 'root' @ 'localhost' (using password: YES) solution, -- mysql5.7denied 1. Open the my. ini file in the MySQL directory, add "skip-grant-tables" at the end of the file, and save and close the file; 2.

MySQL database index OverviewI. Meanings and features of indexes are independent and stored on disks.Database StructureThey includeReference pointer of all records in the data table. The index is used to quickly find rows with a special value in one

MySQL common storage engine introduction and parameter settings tuning, mysql Tuning MyISAM Features:1. Concurrency and lock level2. Repair of Table CorruptionCheck table tablenameRepair table tablename3. Index types supported by MyISAM tables①

MySQL series-Chapter 1: MySQL introduction and installation, mysql Chapter 11. Database Introduction1. What is Database? '' Simply put, a data warehouse is organized and stored according to a certain data structure , we can use a variety of methods

[Daily] MySQL memory failure solution, mysql Solution 1. Failed to start mysql. Check the error log/var/log/mysql/error. log. 2. The main error messages are as follows: [ERROR] InnoDB: mmap (136151040 bytes) failed; errno 12 [ERROR] InnoDB: