These days want to debug Erlang nif call C CPI so download the source code, the main want to generate a Mysql_nif.dll link library.Win under:Extract source code out, Lib directory under Libmysql.dll, Libmysql.lib, Mysqlclient.lib three files, feel
Navicat is a powerful MySQL database management and development tool. NAVICAT provides professional developers with a powerful enough cutting-edge tool, but it is still easy to learn for new users.
The new features of Navicat 9.0.15 include:
-Form
Percona has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, provides some very useful performance diagnostic
Today to introduce six more useful MySQL SQL statements, probably a lot of people through PHP to achieve these functions.
1. Calculation of years
You want to figure out how old this person is by birthdays.
SELECT Date_format (From_days to_days
Class if there is a reply form for a post, posts (ID, TID, subject, message, Dateline), ID for the automatic growth field, Tid for the reply to the topic of the ID (Foreign key Association), subject for reply to the title, message for the reply,
In real life, backing up the database on a regular basis is an extremely important task. When we use MySQL, there is a lot of choice in database backup, and this article will show readers how to use MySQL's mysqldump to back up the database.
First,
In the second edition of the high performance MySQL, the time comparison between the SQL file and the definition character file in the backup and restore was seen.Method file size Export time restore timeSQL Dump 727M 102s 600sDelimited dump 669M
The MySQL database is an open source database based on structured data. The SQL statement is the core language in the MySQL database. However, in the MySQL database to execute SQL statements, you need to be careful two traps.
Trap one: null value
As we all know, query optimization is an unavoidable topic in any database. For database engineers, optimization is the most challenging job. MySQL Open source database is no exception. In fact, the author believes that the database optimization is
In real life, backing up the database on a regular basis is an extremely important task. When we use MySQL, there is a lot of choice in database backup, and this article will show readers how to use MySQL's mysqldump to back up the database.
First,
If you host your own blog or no web-based application running on the stack, should have a backup system Keeping data stored in MySQL databases safe. There are several solutions that can help for you, and but nothing beats a simple Bash script I
MARIADB is a MySQL branch version of the Maria storage engine, a free Open-source database server developed by a company founded by the original MySQL author Michael Widenius.
Download Mariadb 5.1.50:http://downloads.askmonty.org/
Improvement
Percona has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, provides some very useful performance diagnostic
Home can be found on the Internet are Redhat systems and so on, the Ubuntu system MySQL cluster does not introduce articles, I now write to write Ubuntu this MySQL cluster method. Novice don't scold me, hehe.
Introducing the network environment:
A few days ago, in the management system encountered a strange problem, today has the opportunity to install a good MySQL environment to reproduce this problem, because it is not the most original environment, so may not be able to reproduce
The mysql stored procedure described below is a stored procedure with parameters (Dynamic execution of SQL statements) that queries the user's information based on the conditions and sort of user input, and the sorting criteria can be not invoked:
What can delimiter in MySQL do? Many people may have such doubts, the following is to introduce you to the role of delimiter MySQL, for your reference.
After MySQL exports one sql:
DELIMITER $$
DROP TRIGGER IF EXISTS '
SQLyog is an easy-to-use, fast and concise tool for graphically managing a MySQL database that can effectively manage your database in any location.
Changes:
1. SJA now supports a additional-r parameter that tells how big CHUNKS should is
What is the difference between a MySQL hash index and a b-tree index? I believe many people have such a question, the following is a detailed analysis of the difference between the two for your reference.
MySQL Hash Index structure particularity,
MySQL command line is to learn the MySQL database must have knowledge, the following for you to introduce 10 useful MySQL command line, I hope you learn the MySQL command line can help.
1, display the structure of the data table:
mysql> DESCRIBE
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.