Preparation: Install "MSQL-ODBC driver"I. Configuring the data source1, Win7, open the Control Panel-system and security-management tools, click "Data Source (ODBC)".Open the data source (ODBC) and click the "Add" button on the User DSN tab to bring
//Multi-table query: Get the latest data before you execute a multi-table querySELECT * from' Students ' st ' Right JOIN( SELECT * from (SELECT * fromGoutongWHEREgoutongs= ' asdf 'ORDER byTimeDESC ) asGttGROUP bygtt.name_idORDER byGtt.goutong_
If the database storage field is a MySQL keyword, an error occurs during a query or other operation. So what should we do,Maybe some people will say, change a field is not good ah. Of course this is also possible, no problem at all.However, what if
Let's talk about the use of simple joins in detail below. First we assume that there are 2 tables A and B, and their table structures and fields are:Table A:
Id
Name
1
Tim
2
Jimmy
MySQL operates and maintains a centralized database. It can be performed by a single MySQL on the database server, deploying multiple MySQL samples. This feature is implemented by Mysqld_multi. Mysqld_multimysqld the service process. These mysqld
The database engine you can use depends on how MySQL was compiled when it was installed. To add a new engine, you must recompile MySQL. By default, MySQL supports three engines: ISAM, MyISAM, and heap. Two other types of InnoDB and Berkley (BDB) are
1. Check whether the installation of Mysql,grep-i indicates that the case is ignored when matching#rpm-qa |grep-i MySQLMysql-libs-xxxx indicates that a MySQL library file has been installed#rpm-E mysql-libs.xxx--nodeps to uninstall first, or
Sets the character set set NAMES UTF8;Create a database "databases";Show all databases show DATABASES;Using the database use "Dataname"Show all tables show TABLES;Modify the name of the Table RENAME table study to Study_new;ALTER TABLE study_new
To start the MySQL service :net start MySQL(using this command to start MySQL, you need to register MySQL to the list of services, if it is Wamp's own MySQL registered to the service list is a bit troublesome, if there are experts want to tell one
MySQL basic command operation (mainly in mysql5.5 for example)
How to log on to a single instance of MySQL
# mysql-uroot-pThen enter the password to log in to the database.2. Modify the root user password for single instance MySQLFrench one:
First of all, I have been using MSSQL, because of the work, every day to write hundreds of SQL statements, and continued for several years, because the job is currently the main contact with MySQL; So now start learning MySQL.My study plan is very
Small mood (can jump directly after the split line)I'm in a better mood today. Some strong not open bad mood, also gradually in the evening to solve a complex logic problem, gradually dissipated.Today at noon to eat, Kun elder brother casually said:
Stored procedures are what, their own Baidu, Baidu said better than I said. Why use stored procedures, which can improve efficiency. Say less nonsense, directly on the code:First, the syntax: write stored procedures in MySQLDELIMITER $ $CREATE /*[
1. Composite IndexFor example, there is a statement like this: SELECT * from users where area= ' Beijing ' and age=22;If we were to create a single index on area and age, because the MySQL query can only use one index at a time, even though this has
First, pre-installation preparationClose iptables:Service iptables stop;Chkconfig iptables offClose SELinuxVi/etc/selinux/configquery whether the system has MySQL installed , and if so, remove it. Rpm-qa | grep MySQLto remove the installed MySQL:Yum
One, stop the MySQL service# Service Mysqld StopSecond, modify the parameters of the Mysqld_safe# Mysqld_safe--skip-grant-tables--skip-networkingParameter explanation:--skip-grant-tables: Bypass the authorization table so that you can temporarily
Original address: http://blog.chinaunix.net/uid-16844903-id-3896711.htmlBinlog Introduction
Binlog, the binary log, which records all changes on the database.
At the end of the SQL statement that changes the database, a record is
If the MySQL table is Tanki, then the primary key will be indexed by the system default.If the MySQL table is a composite primary key, the system will follow the left alignment principle, such as composite primary key A and B fields and C fields ...,
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