MySQL

Open cmd terminal, start MySQL, execute command net start MySQL;Log in as root userMysql-u-root-p;If an error is1045 (28000foruser'root'@'localhost ' (using Password:yes)It is expected that after the mysql5.6 version, you need to enter a

Installationyum install mysqlyum install mysql-serveryum install mysql-develStart and stopservice mysqld startps -ef | grep mysqld[email protected]# cd /usr/bin./mysqladmin -u root -p shutdownEnter password: ******Change root passwordmysqladmin -u

pl1900-smelting number into gold MySQL database operation and maintenanceEssay background: In a lot of times, many of the early friends will ask me: I am from other languages transferred to the development of the program, there are some basic

Source: http://blog.csdn.net/a466350665/article/details/52994761http://blog.csdn.net/xingyu0806/article/details/52080962ifnull (EXPR1,EXPR2) usage: if EXPR1 is not NULL, the return value of Ifnull () is expr1; Otherwise its return value is EXPR2.

Source: http://www.jb51.net/article/125744.htmTest sql:CREATE TABLE ' test ' ( ' id ' int (8) NOT NULL auto_increment, ' name ' varchar (255) is not NULL, ' list ' varchar (255) N OT NULL, PRIMARY KEY (' id ')) INSERT into ' Test ' VALUES (1, '

Steps:1. Turn on transaction start transactionWhen we start a transaction, our operations on SQL occur in memory, but there is no real feedback to the files in the database disk!2. Rollback rollbackRollback is the most primitive state to revert to

Yesterday began to write code, the data inserted into the MySQL database, but there is no way to insert, Internet search, the final method is to insert the data in the phpMyAdmin after the conversion to PHP statements, and finally the following:$sql

installation MysqlOperating System: Windows Server R2 StandardMySQL version: mysql-5.7.17-winx64First step: Unzip mysql-5.7.17-winx64 . zip to the specified locationThe Second step: Add the Data folder under the root directory of the installation

about MySQL database optimizationIn my humble opinion, the database is optimized to optimize storage and query speedAt present the main optimization I think is to optimize the query speed, query speed, improve the user's experienceI think that the

1. Add primary key (primary key index):ALTER TABLE ' table_name ' ADD PRIMARY KEY (' column ')2. Add unique (unique index):ALTER TABLE ' table_name ' Add UNIQUE (' column ') 3. Add index (normal index): ALTER TABLE ' table_name ' Add index

One, key words:1) Left (connection type) join on (condition)two, common connections:1) Join (acquisition of a Cartesian product),SELECT * from T_table1 join T_table2;2) Left connection (two table associations, after matching criteria, left table

MySQL has 4 functions for conditional operation, which can implement the conditional logic of SQL, allowing the developer to transform some application business logic into the database background.MySQL Control flow function:Case When[test1] then

The two are different under Linux and under Windows, under Linux is not differentiated under Windows.The main difference under Windows isSingle quotation marks (') or double quotation marks are used primarily for string reference symbolsSuch

1. Upload the tar package to the server and unzip the tar package to the/usr/local/directorycd/usr/local/TAR-XVF Mysql-5.7.17-linux-glibc2.5-x86_64.tarTAR-ZXVF mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzMV Mysql-5.7.17-linux-glibc2.5-x86_64 MySQL2.

Machine standardization: Server hardware configuration (CPU, hard disk, memory, RAID) to be consistentDirectory standardization: MySQL installation directory, storage data directory, log files, etc., on multiple machines to be unified

Pull MySQL ImageDocker pull MySQL:5.65. 6 Version of ImageRunning a MySQL imageDocker run--name some-mysql-v/mnt/db:/var/lib/mysql-e [email protected]1233306:3306 -D MySQL:5.6#-p Specifies the external port of MySQL #-E for setting environment

When we want to log into the MySQL database via mysql-client under the Shell, we always need to enter the password again and again in a very troublesome time.Usually when we log in to the database, this is the way to log in, as follows[Email

1.find_in_set functionFind_in_set (str,strlist); STR is a string strlist is a string list--a string that has more than one child chain "," separated byThere are a number of situations:Null find_in_set (NULL, "A.STR") returns NULL when NULL or

Mysql database table dead solution, mysql database --- Restore content start --- Cause: Because the MySQl thread is not terminated after the program is accidentally terminated when a large number of insert operations are executed, the table

Basic mysql operations in Windows and basic windowsmysql 1. Database Table operations: -Start the mysql server, open the cmd window in the directory where mysql is installed, and run mysql: 'mysql.exe-hlocalhost-p3306-uroot-p123456 '; -View all