MySQL

Problem Description:Install Navicat, enter Chinese characters, view display garbled from client. Insert Chinese characters from client, Navicat view garbled.1, shut down the MySQL server, "Computer"-"management"-"service"--"close2. Open the. ini

In order to facilitate the performance of testing, table and other work, it is necessary to establish a larger data table. I'm going to build a tens of millions of user tables here first. Step: 1 Create a data table (MyISAM mode storage insert speed

respect for the original: http://blog.csdn.net/abc19900828/article/details/39501643Dynamic SQL statement Basic syntax1: Normal SQL statements can be executed with execEg:select * from TableNameExec (' select * from TableName ')Exec sp_executesql n '

Generally speaking, the left connection, outer connection refers to the left outer connection, right outside the connection. Do a simple test, you see.First, left outer and right outer joins:[test1@orcl#16-12 Month-11] Sql>select * from T1;ID NAME---

1. Download MySQLAccess https://dev.mysql.com/downloads/mysql/5.6.html#downloads, download the corresponding version of the operating system (no account needs to register one first), take Mysql-5.6.38-win32 as an example2. UnzipTake decompression to

Due to my 1045 error, no solution was found on the internet, I could not restrain myself from being irritable, I uninstalled it directly and then reinstalled it.Uninstall process: sudo rm/var/lib/mysql/-RDelete a MySQL data file sudo rm/etc/

01. Extract the Mysql-5.5.58-win32.zip to the custom D:\mysql-5.5.58-win3202. My Computer--attribute--advanced--environment variable--system variable--new system environment variableVariable name: mysql_homeVariable Value: D:\mysql-5.5.58-win3203.

1, view database: show databases;2, using Database: Use database name;3, Enquiry form: Show tables;4, view table structure :desc table;4, CREATE TABLE, delete table, modify etc settings, Navicat can be easily done, not recorded5, add, delete, change,

Data types in MySQL (String type)Character Typedata types in the six databaseschar, varchar, text, Blob,enum,setChar and varcharchar fixed length: Disk space is wasted, but high efficiency, determine the length of the data is the same, the use of

Navicat you choose to dump the structure and data, the resulting SQL file will be larger, because each piece of data will generate an SQL statement, it will cause the use of source restore will be very slow slow very slow,Files that are exported

DRBD is a software-implemented, non-shared storage replication solution for mirrored block device content between servers. The functionality of DRBD is implemented through the Linux kernel, which maintains data synchronization through the TCP/IP

Problem: The program reported the error of table ' xxx ' doesn ' t exist, but the view database found that the table already exists and the letters are not misspelled.Cause: MySQL on Linux defaults to case sensitivity.FIX: Change the MySQL

In MySQL, a blob is a binary large object, a container that can store large amounts of data, which can accommodate different sizes of data. The Blob type is actually a type family (Tinyblob, Blob, Mediumblob, Longblob) and they are equivalent except

The results from the MySQL query are:Mysql-ne "Select Ip,port from Op.host WHERE os= ' Linux ' and type= ' support '" +------------+------+|   10.3.1.155 | 22 | |   10.3.1.156 | 22 | |   10.3.1.174 | 22 | | 10.3.1.212 | 2222

Note: The newly installed MySQL contains a root account with a blank password and an anonymous account, which is a great security risk, for some important applications we should improve security as far as possible, in this case, the anonymous

MySQL export fast, import a particularly slow solution:Add two parameters to import: Max_allowed_packet; Net_buffer_length--max_allowed_packet the maximum size of the buffer between client/server communication;--net_buffer_length TCP/IP and socket

Mysql Master/Slave Log File mysql-binfile clearing method, mysqlmysql-bin By default, mysql keeps mysql-binfiles, so that the disk may be fully occupied by a certain period of time. Can these files be deleted at this time? Can they be safely

Mysql-innoDB-transaction,Transaction isolation level: 　　Read uncommitted (uncommitted read) At this level, the modifications in the transaction are visible to other transactions even if they are not committed, and the transaction can read

Mysql-innoDB-lock,Before locking InnoDB, why do we need to start transaction first? The release of locks in innodb is after the transaction is committed/rolled back. Once the transaction is committed/rolled back, the locks in the transaction are

Mysql partition, mysql When a table contains a large amount of data, for example, if a single. myd file reaches 10 Gb, the reading efficiency will inevitably decrease. In this case, you can use the partition function provided by mysql to separate