MySQL

I have long heard that the two commands, lock tables and unlock tables, literally know that the function of the former is to lock the table and the latter is to unlock it. But how to use, how to use, not very clear. Today, in a detailed study, we

The last time the MySQL database was installed, there is no login operation, this time to briefly introduce the basic operation of MySQLI. Access to the MySQL database (after the installation of the initialization process, the default administrator

MySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server Community version, open source is free, but does not provide official technical support.2. MySQL

[download MySQL 5.6.13]From the MySQL official website mysql.com find the MySQL Community Server 5.6.13 for http://dev.mysql.com/downloads/mysql/, where you can choose the operating system platform. Here are three optional download files, the first

"to the program Ape on the road."For a developer, the ability to develop a free module in a system is the embodiment of its core value.For an architect, mastering the advantages of various languages and applying them to the system simplifies the

Unix timestamp converted to date function: From_unixtime () Select From_unixtime (1156219870); Date conversion to UNIX timestamp function: Unix_timestamp () Select unix_timestamp (' 2006-11-04 12:23:00′);

First,Common topologies for replicationThe architecture of replication has the following basic principles:(1) Each slave can have only one master;(2) Each slave can only have a unique server ID;(3) Each master can have a lot of slave;(4) If you set

"1" Create Employee profile formRequirements field: Employee employee number, employee name, gender, salary, email, entry time, department."2" reasonable choice of data type and field modifiers, requires not null,auto_increment, primary key and so

The most recent project is the development of the public platform, the official demo is PHP, found that most of the learning material is also PHP, then well, give up Java, to paragraph PHP barLet's talk about setting up a PHP environment under

The fact is that three points of knowledge are integrated together. Includes how to access MySQL. How to generate an XML file and how to use it for WebService developmentAll right. Words don't say much. Direct Stick CodePackage Com.service;import

Performance-schema first appeared in MySQL 5.5, and now 5.6,5.7 Performance-schema added more monitoring items, more statistical information, more and more oracle-awr statistical information Bright, is the DBA children's shoes for performance

Mysql+pam-based VSFTPD virtual User ConfigurationFirst, the experimental explanationOperating system: Redhat5.8_x64bitExperimental platform: VMware WorkstationRequired Packages: P am_mysql-0.7rc1.tar.gzSecond, the installation of the necessary

First, the Preparation toolVisual Stuido (this example uses Visual Studio 2010)MySql.Data.dllMysql_installer_community_v5.6.21.1_setup.1415604646.msi (online search to download or request from me, contact information in

#-----------------------------CentOS 6.x version upgrade MySQL------------------#! /bin/sh#1. Turn off SELinuxCp-rp/etc/selinux/config/etc/selinux/config.bakSetenforce 0Sed-i ' 7s/enforcing/disabled/'/etc/selinux/config#2. Show SELinux status

This article has referred to Http://www.tuicool.com/articles/3iUNFnA and has made some additions to the details. Make the installation process smoother.The first thing to say is that Ubuntu requires the sudo command, so start with sudo on the

1, database Operation example: Public static void jdbctest ()  throws exception {connection conn =  null; string url =  "Jdbc:mysql://localhost:3306/mysql_learn?" +  "User=root&password=123qwe&useunicode=true&characterencoding=utf8";

Mysql semi-sync source code implementation, mysqlsemi-sync Mysql replication briefly introduces the causes of mysql semi-sync, and explains how semi-sync ensures that no data is lost. This article focuses on the implementation of semi-sync, and

MySQL optimized 100 of the 100 suggestions for MySQL Optimization MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 100 tips for adjusting and optimizing

MySQL InnoDB table-Basic BTree data structure, innodb-btree MySQL InnoDB table is an index organization table. This should be the first thing that anyone who learns MySQL will learn. This means that the data in this table is stored in the primary

MySQL-optimized MRR (Multi-Range Read: secondary index merged back to table), mrrmulti-range MRR is introduced in MySQL5.6 for optimization:List index range scan and need to return to the table. The principle is to sort multiple secondary indexes