MySQL

1. Core PrinciplesDo not operate in the database;CPU computing must be moved to the business layer;Number of control columns (field few but good, number of fields recommended within 20);Equilibrium paradigm and redundancy (efficiency first; often

Problem Description: The local host connected to the MySQL times error on the server: Host ' xxx ' is not allowed to connect to this MySQL server;Server configuration, Windows Server;Analysis: This is a MySQL access issueWorkaround:1. Enter the

A query for numeric data:SELECT * from Tb_name WHERE sum > 100;Query predicate:>,=,,!=,!>,!,=Two query stringsSELECT * from tb_stu WHERE sname = ' Xiao Liu 'SELECT * from Tb_stu WHERE sname like ' Liu 'SELECT * from Tb_stu WHERE sname like '%

#数据准备drop table if exists class;CREATE TABLE Class (class_no Int (2) unsigned Zerofill primary key auto_increment comment ' class number ',Class_name varchar (+) NOT null comment ' class name ');INSERT into class values (1, ' Pui gifted class

MySQL is the most used database of the company, it is cow and ox cow!Everyone can design a database, from the deletion of the library to the run. But how to do better, faster, and more accurately build your MySQL database is a matter of concern

View the number of connections command: Show Processlist If you are a root account, you will be able to see all current user connections. If you are a regular account, you can only see the number of connections you occupy.  show Processlist can only

[MySQL Data Directory migration dislocation] Error resolutionIt takes about 4 steps,The 1th step is to stop the database through service MySQL stop.2nd move the data file, do not know whether the reason for Ubuntu intelligence, when moving the

1. Download MySQL for mac:https://dev.mysql.com/downloads/installer/2. Double-click mysql-5.7.17-macos10.12-x86_64.dmg to Unzip, double-click mysql-5.7.17-macos10.12-x86_64.pkg to install3. Continue, Continue, Agree, Install, enter the administrator

1. Log in to Mysql:mysql-u root-p2. Creating a Database: Create database name [other options];Such as: Create Database firstbase character Set GBK;3.show databases; command to see which databases have been created.4. To operate on a database, you

Sometimes it is considered that count (*) is slower than count (1) or count (column name) and is actually handled in a sub-case.Like what:---initialization statementsCreate a table and insert the data:Create table test2 (id BIGINT PRIMARY key, name

MySQL Best optimization tips posted on 2012-04-12-Views: 979 Comments: 0 Favorites 01. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general, the smaller the tables in the database, the faster

The Replace statement is generally similar to insert, but if there is a primary or a unique index in the table, if the inserted data is the same as the original primary key or unique, the original data is deleted, and then a new piece of data is

C:\appserv\mysql> Mysql-u Root-pEnter Password:ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)Workaround:Edit the MySQL profile My.ini (in the MySQL installation directory, my D:\Program files\mysql\mysql

Reset MySQL Auto-increment auto_increment initial valueNote that existing data will be deleted using any of the following methods.Method One:delete from tb1; ALTER TABLE tbl AUTO_INCREMENT = 100; 1 2 (Benefit, you can set

Transferred from: http://blog.csdn.net/kevinlifeng/article/details/43233227Statement is their own study is not original, hope everyone support the original.SQL statement optimization and indexing1.Innerjoin and left connection, right connection, sub

Stored procedures and functions are a collection of SQL statements that have been compiled and stored in a database, except that the function must have a return value, and that the stored procedure has no parameters for the stored procedure to use

MySQL is older (not the old MySQL software, but that the set of MySQL function in PHP is older), and there are many shortcomings and deficiencies, As a result, this set of extensions was deprecated in the PHP5.5 version, removed in a new version of

How to install mysql 5.7.11 in Win7, win75.7.11 Operating System: win7 64-bit flagship Edition Mysql package: mysql-5.7.11-winx64.zip 1. decompress the MySQL package Decompress the downloaded MySQL package to the custom directory. The decompressed

Mysql common operators and functions and mysql Operators Create a data table first. Use test; create table 'employe' (emp_no int unsigned, emp_name varchar (30), emp_sex varchar (3), emp_age tinyint unsigned, sal double, history datetime ); insert

MYSQL prevents duplicate sample code and mysql sample code when adding a shopping cart Preface Recently, due to work reasons, I placed an order to pay for this item in the APP shopping cart. A bug was raised in the test. When the point is added to