MySQL Character set support (Character set supports) has two aspects:The character set (Character set) and the Sort method (Collation).Support for character sets is refined to four levels:Servers (server), database, data tables (table), and
Hive synthetic hbase Two advantages table: 1. Implement data import to MySQL.2. Implement the HBase table into another hbase table. Three operation Links:1.hbase Associated hive as an external table:SQL code
create external table
Remotely connect yourself or someone else's MySQL when prompted with a hint: "1130-host ' win7 ' is not allowed to connect to this MySQL server", meaning that the host does not allow connections to the MySQL server, not allowed because the
Workaround: 1. Change the table method. may be your account is not allowed to login from remote, only on localhost. This time, as long as the computer in localhost, log in to MySQL, change the "MySQL" database "user" table "host", from
Directory (?) [+]
Transaction
Commit or roll back
Common transaction Directives
Characteristics of the business acid
Trigger
Create a Trigger
Manage triggers
TransactionsCreateTable Swpu
1. View MySQL deadlockSELECT * from INFORMATION_SCHEMA. Innodb_trx;2. Viewing transactions that are being lockedSELECT * from INFORMATION_SCHEMA. Innodb_locks; 3. Viewing a transaction waiting for a lockSELECT * from INFORMATION_SCHEMA. Innodb_lock_
When you use the Explain tool to view the SQL statement execution plan, if the Select_type field appears "DEPENDENT subquery", you have to notice that you have fallen into the MySQL sub-query Slow "pit."Related books: high-performance MySQL (3rd
Although the development of MySQL + PHP can be used in PDO, but some of the older programs are not used, or other reasons1. Comment BypassSelect/*comment*/user/*zzsdsdsf*/from Mysql.user;2. Inline Comment Bypass/*!12345select*//*!12345user*/from
Linux login MySQL server is generally the command line to manually enter the link information[Email protected] ~]# mysql-hlocalhost-uroot-p11111In the case of MySQL 5.6, there will be security prompts when you log in.Warning:using a password on the
MySQL batch replacement is the function we often use, sometimes the station contains sensitive words, will bring us trouble, and in the case of large amounts of information, a piece of the search, modification is unrealistic.With MySQL batch
#if exists If a result set exists, the IF is the where condition if true executesDROP TABLE IF EXISTS itcast_class;#创建表格CREATE TABLE Itcast_class (class_id INT PRIMARY KEY auto_increment,Class_name VARCHAR (Ten) not NULL DEFAULT ' ') CHARACTER SET
A few common sense about MySQL privilege:1, MySQL's authority system is mainly used to verify the user's operation rights.2, Inside MySQL, the permission information is stored in the MySQL database granttable. When MySQL starts, the information in
1. Modify the configuration filesudo vim/etc/mysql/my.cnfChange the value of the bind-address parameter to your internal/external network IP or 0.0.0.0, or comment out the line directly.2. Log in to the databaseMysql-u root-pEnter passwordmysql> use
1. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general, the smaller the tables in the database, the faster queries are executed on it. Therefore, in order to achieve better performance when
Traditional writing:Echo"This is a test";Echo"ASDFASDFADSF";$mysql _server_name="localhost";//Database server name$mysql _username="Root";//Connect to database user name$mysql _password="??????";//Connect Database Password$mysql _database="??????";//
Insist on learning a little every day, accumulate a little every day, as their own daily amateur harvest, this article is my meal during the writing, using their own scattered time to learn python operation MySQL, so tidy up a bit.I am using the
OrderRecently has been busy projects, various overtime, project on-line, gradually did not have the time to study. This is not, just these days to spare some time, sneak in, is reading a database of books, I believe many small partners have also
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