Found a strange problem today, the root user login MySQL database suddenly become restricted permissions, no permissions MySQL LibraryMy solution is to add a ship-grant password in the my.cnf config file to log in to the database using the root
1. Open and CloseMysql> set profiling=1;Mysql> set profiling=0;The database of INFORMATION_SCHEMA will create a profiling table record.2. Execute some statements (custom statements)Mysql>select * from Navigation_sub where navpid3. Query statement
1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. You should try to avoid null values in the WHERE clause, otherwise it will cause
MySQL Learning notesSelect substring (now (), 1,10);MySQL landed capital Letter P is portC:\Program Files\mysql\mysql Server 5.6\bin>Mysql-h 127.0.0.1-p-U root-pSet the password for the root accountmysql> set password for ' XP ' @ ' 127.0.0.1 '
MySQL installation and configuration and login and exitIntroduction to the installation directoryStart/stop MySQL servicenet start MySQLnet stop MySQLLog in/out of MySQLModify the MySQL command promptMySQL Common commands:SELECT VERSION (); Show
Binlog, redo log, undo log, relay log just start to learn that all kinds of log is what exactly do not understand:Binlog: For logical replication and possible incremental backup recovery strategies, only log changes to the data, recording mode there
OverviewThis section describes using Cursors for bulk table operations, including batch indexing, batch adding fields, and more. If you are not familiar with stored procedures, variable definitions, and preprocessing, read the articles on these
Error code 1045Access denied for user ' root ' @ ' localhost ' (using Password:yes)The workaround is to reset the root user password by following the steps in the Windows platform:1. Log in to the system as a system administrator;2. If the MySQL
Modify the ibdata1 size verification and how to use mysqld_multi to manage multiple instances and mysqldmulti
Verification of modifying the ibdata1 size
Ibdata is a shared tablespace that is generated during MySQL initialization.
However, many
How mysql creates Indexes
Index query is an important record query method in the database. Whether to enter the index or create an index on those fields must be considered in conjunction with the query requirements of the actual database system,
MySQLMerge storage engineThe Merge storage engine allows a Group to use the MyISAM storage engine and the table structure is the same (that is, the field order, field name, field type, index definition order of each table and the way they are
MySQL sorting principle and case analysis, and mysql sorting
Preface
Sorting is a basic function in the database, and MySQL is no exception. The Order by statement can be used to sort the specified result set. It is not only an Order by statement,
Shell executes the mysql command and shellmysql commandThe difficulty lies in the parameter transmission method. However, it is very easy to check the information. 1. use the-e parameter to pass the command. It is applicable to the simple statement
CUBRID Study Notes 19 SQL statement 1, cubrid Study Notes
Create
You are welcome to reprint it. Please keep the author's information during reprinting. This article copyright belongs to me, if you have any questions, please contact me
MYSQL tips and tips
Use str_to_date () in mysql to convert a string to a date.
Take the BJSJ of T_TGS_ALARMED as an example to query the data within this range.
Insert into T_TGS_ALARMED (XH, HPZL, HPHM, BJSJ, BJLX, BJYY, KKID, DDBH, FXBH, CDBH,
SQL functions and SQL Functions
SQL has many built-in functions for counting and computing.
SQL Aggregate Function
The SQL Aggregate function calculates the value obtained from the column and returns a single value.
Useful Aggregate functions:
Enable slow query log in MYSQL5.7.9
MYSQL 5.7.9 is used as the monitoring database of ZABBIX 2.4.7. Some time ago, the slow query log was enabled, and later it was found that the slow query log expanded to 700 mb.
Check that most of the last 100
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service