MySQL sub-table 3 ways to tag: MySQLposted on 2017-12-26 10:49:20First, let's talk about why the tables are divided.When a piece of data reaches millions of, you spend more time searching for it, and if you have a joint query, I think it's possible
1. Login:Mysql-u username-pShow all databases:show databases;Use a database:Use DatabaseName;Show all tables for a database:Show tables;Exit:Quitdeleting databases and data tablesMysql>drop database name;Mysql>drop table Data Sheet name;User-Related:
Linux Centos Migration MySQL data locationThe database is now migrated due to an increase in traffic that causes the disk space on the system disk (20G) to be fully occupied. Mysqlis through yum the installation.centos6.5mysql5.1yumInstalled mysql
To run a command with an administrator user:Mysql> Show [full] processlist; # full is optional, and if not added, only the first 100 results are displayed by default.You can rely on this result to analyze some information such as user connection
Data typetruncate t1 (delete table) # unsigned type ALTER TABLE t1 modify ID tinyint unsigned (table has value, cannot be changed directly) desc T1========================================tinyint[(m)] [unsigned] [zerofill] small integer, data type
1. Create a new file named My.ini. My.ini in the Bin folder of the MySQL extract directory, with the contents of[Client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8basedir=%mysql_home%
Aggregated by year, statistics:Select SUM (Mymoney) as Totalmoney, COUNT (*) as sheets from MyTable Group by Date_format (Col, '%Y ');Summary by month, statistics:Select SUM (Mymoney) as Totalmoney, COUNT (*) as sheets from MyTable Group by
Smaller is usually betterAt the beginning of the table design, I think the choice of the right data type here is very critical, he can minimize the disk footprint of the database, and in the process of querying the simpler the smaller the data type
"Barrier Reproduction"Condition Description 01: A program is often reported in the Linux downgrade can not find the table, but I clearly built a table, testing, encountered some problems, from the Windows platform to access the virtual machine in
Error: Could not open JDBC Connection for transaction; Nested exception is Java.sql.SQLException:The server time zone value '????????? ' was unrecognized or represents more than One time zone. You must configure either the server or JDBC driver (via
Start and stop of MySQL servicenet stop MySQLnet start MySQLlog in to MySQLThe syntax is as follows: Mysql-u user name-p user PasswordType the command mysql-uroot-p, enter the password after entering, enter 12345, and then enter into the MySQL,
First, the configuration MySQL Database1, unzip the green version of MySQL, and renamed to mysql5.7, such asCompare The previous versions of 5.6, with fewer data directories ( storage ) and My-default.ini file (configuration information)Second,
A brief introduction: Today we discuss the strategy of incremental backupTwo backgrounds: With the increasing of data volume, the full preparation is unrealistic, so the incremental backup strategy is discussed and tested.Three specific strategies: 1
Date_format (DATE,FMT)Date value formatted as String FMTFormat (x, y) formats x as a comma-separated sequence of numbers, and Y is the number of decimal digits of the resultInet_aton (IP) Returns the number representation of an IP addressInet_ntoa
MySQL has 4 functions for conditional operation, which can implement the conditional logic of SQL, allowing the developer to transform some application business logic into the database background.MySQL Control flow function:Case When[test1] then
First, storage engine conceptData in MySQL is stored in files (or memory) in a variety of different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and ultimately offers a wide range
Unzip MySQL to D packing directory
Copy the My-default.ini under the decompression path and modify the name to My.ini
The contents of the My.ini are as follows
[Client]Default-character-set=utf8 [mysqld]
Recently encountered "TOO deep OR LONG SEARCH in the LOCK TABLE waits-for GRAPH, WE'll roll back following TRANSACTION".Re-review the benefit of a lot of, which the deadlock of the rules, in fact, we have 5 years ago to solve the first version of
MySQL [Delete misoperation] data recovery [convert], mysqldelete
Preface:During database operations, it is inevitable that the database will be mistakenly operated due to the "carelessness". If you need to recover quickly, it is unlikely that the
Mysql5.7 installation and configuration tutorial, mysql5.7 configuration tutorial
This article shares with you the mysql installation and configuration tutorial for your reference. The specific content is as follows:
1. Configure the MySQL database
1
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