MySQL

The modified users are listed as root.first, the root of the original myql password;Method One:Outside the MySQL system, use the Mysqladmin#mysqladmin-u root-p Password "test123"Enter Password: "Enter the original password"Method Two:By logging into

View (views):Virtual tablesMainly used to see (check) the dataThe data changes in the base table are reflected in the viewPermission controlIntegrate the results of multi-table queries into the view for easy viewing by usersCreate VIEW v1 as SELECT .

StatementThe Stars last nightBlog:http://yestreenstars.blog.51cto.com/This article by oneself creation, if need reprint, please indicate source, thank cooperation!ObjectiveFull hot backup of MySQL with InnobackupexEnvironmentOs:centos 6.6

Insert table record (1):Demo: This method supports arithmetic when writing a value1 # Create a database and use a database2 CREATE DATABASEGzcsql;3 UseGzcsql;4 # Create a data table5 CREATE TABLEtable1 (6IdSMALLINTUNSIGNEDPRIMARY KEYAuto_increment,7

About MySQLMySQl database is relational database . Relational: Use a relationship to represent the connection between entity information and entities.Relationship: Two-dimensional table , there are rows and columns. SQL: Structured Query language.

Master-slave replication provides better customer response times by slicing the load of client queries between the primary server and the server.The advantages of MySQL master-slave replication are as follows: Increased robustness, a

Data manipulation: (insertinto)1. Add Data:Insert into table name (field name) values (data list);Insert  into  1 Span style= "font-family: ' The song Body '; >), (field list 2 .... Insert into table name set field 1= value 1,... ;notes:

FOREIGN KEY constraintsFOREIGN key: Used to establish a connection between two entities.FOREIGN KEY constraint: restricts the correspondence between the records of the current table and the records of the associated table.Constraint restriction:

Trigger (Trigger)1. Role: Monitor a situation and trigger an action.The trigger can monitor the increase, deletion and change of the table, and make the operation of adding, deleting and changing.2. Create TRIGGER Syntax: (Requires early

Storage Engine1, Concept: The database on the same data, has a different way of storage and management.2, MyISAM:1.the MyISAM table is operating system independent, which means that it can be easily ported from a Windows Server to a Linux Server

Index1. Index: The directory created for the data. Btree Index Count:Log2NNumber of hash indexes:12, the use of the principle:1. do not over-index. 2. index Criteria column (where the frequent condition is appropriate for the index). 3. index hash

Character set and proofing rules1. Character set: A set of symbols and character encodings.2. Proofing Rules: A set of rules that are used to compare characters within a character set. 3, the installation of the database is best with our fixed code.4

Error:alter command denied to the user ' xxxx ' @ ' localhost ' for table ' uc_notelist ' errno:1142sql::alter table uc_notelist ADD CO Lumn App1 tinyint NOT NULL indicates that the XXXX user does not have ALTER permission. To MySQL,mysql> SELECT

First spit trough under a company's machine environment, channel machine What is the most annoying! Make a securefx is not good to use!! The egg-ache MySQL installation Ah, basically is Linux the right struggle. 1. Yum one MySQL, start service ....

MySQL data backup, its importance is self-evident. In general, we typically use mysqldump, xtrabackup, and LVM snapshots for backup, or a dedicated MySQL replication backup server.Characteristics:Logical Backup tool is slower than physical backup,

Forget the limit and record it every time.Paged query (limit start line, query a few lines)--start line starting from 0--Pagination: The current page shows how many bars per page--Paged Query the current page of the data Sql:select * from Student

1. Backing Up the databaseMysqldump-u root-p Test>/home/victor/test.sqlDescription: If you are prompted to find the mysqldump command, first find the path to mysqldump with a Find command-name mysqldump-printThen use the LN command to link

In the "field plus & Appointment queuing" project, "Dealer Troubleshooting" is not a problem when testing online, but after the line, due to the large amount of data on the line, resulting in the execution of the query system crashes; Later, after

1. Pre-preparation1.1 Environment Description:Operating system: CentOS release 6.4 (Final) [view command Cat/etc/redhat-release]mysql:mysql-5.6.261.2 Completely delete the system comes with MySQLYum remove MySQL mysql-server mysql-libs

Create a new user under 1,mysqlGrammar:1.create user username identified by ' password ';Example: Create user Xiaogang identified by ' 123456 ';The newly created user, by default, does not have any permissions.2. How to assign permissions to