Today, in centos6, copy the database folder that mysql cannot start to/usr/local/mysql/var. The error "table isreadonly" is displayed when you modify the table. First of all, I encountered a permission problem, so I went to/usr/local/mysql/var to
In the past, oracle databases were used for enterprise projects and mysql was used for new company projects.
1 In windows, mysql is case-insensitive by default. To make mysql case-insensitive. Change Method
Find the my. ini file in the mysql
Today, let's take a look at common commands in MySQL (command keywords in MySQL are case insensitive ):
(1) show databases; displays all databases in MySQL
(2) create database dbname; create database dbname in MySQL
For example, we create a database
The InnoDB Engine of MySQL is configured with indexes and data cache pools. The LRU algorithm is used to maintain the cache hit rate.
The sequence table list is used as the buffer pool. Each data node is called a block.
This algorithm uses the dot-
ZookeeperThere is a mysql database table. The result of querying the last two pieces of data is as follows:
This is the content in the original table:Idname1 ad2 jk3 tre
4 hgv
This is the last two pieces of data to be queried (for the latest
Copy codeThe Code is as follows:Create definer = 'root' @ 'localhost' PROCEDURE 'createbusiness '(parameter1 int)BEGIN# Routine body goes here...DECLARE flag int DEFAULT parameter1; # DECLARE the variable flag and assign the parameter value to the
Mysql has some time functions, although not commonly used, but sometimes used for interviews.
1. Convert the current time to the timestamp
select UNIX_TIMESTAMP();2. We generally do not directly describe the specific age about age. Because age is
I. Syntax
EXPLAIN select sid,filename,filetype from (SELECT * from by_disk_file where uid=830814) a
Result:
Id: indicates the SQL Execution sequence. The SQL statements are executed from large to small.
Select_type: Query type, which can be:
1.
Because the data capacity is smaller than 20 GB, using mysqldump for full-Database Export has little impact on the business. Therefore, this mode is used to build a slave database:
PS: master-data = 1, record the Master_Log_File and
Garbled characters occur in Chinese when MySQL databases are used in the project (are all Chinese characters changed ?) Solution:
1. unified project and database coding, the project uses UTF-8, So I unified the database coding into UTF-8
When performing ROLLBACK, if you receive the following message, one or more tables used in the transaction do not support transactions:
Warning some changed non-transactional tables cannot be rolled back.
These non-transactional tables are not
Parsing: How to Create a foreign key in MySQL
Example:
1. master table
Drop table if exists 'biao ';
Create table 'biao '(
Id'int (11) not null auto_increment,
Title 'varchar (11) default NULL,
Content 'varchar (11) default NULL,
Primary key ('id ')
1. Download:
Mysql address: http://dev.mysql.com/downloads/mysql/ select the type you want to download, this package has the two servers we want to use, clinet
2. decompress:
There are many files, and the two files are used below
MySQL-client-5.5
The following method can be used to solve the MySQL5 garbled problem:
1. Set phpMyAdminCopy codeThe Code is as follows:Language: Chinese simplified (zh-utf-8)
MySQL Character Set: UTF-8 Unicode (utf8)
MySQL connection verification gbk_chinese_ci
If you are using a mysql database, you can store passwords or other sensitive and important information in your application. Protecting this data from access by hackers or prophers is an important concern, because you cannot allow unauthorized users
I have never stepped on this mine, but today, Mr. Zhou recorded his record on Weibo. It must have been a pain point in the hearts of his elders.
Why? I think this is exactly the same as the record I stepped on last time. What's different is that I
I feel that I have been using the framework since my work, and some basic things of the database have been forgotten. This time I used this series of blogs to review the old knowledge and learn a little new knowledge.
Today we will start with join
How to add innoDB to phpMyAdmin
PhpNow (the free green Apache + PHP + MySQL environment package under Win32) finds that the database does not support the innoDB Engine by default. Many methods have been tried on the Internet. The following method
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