Directory
First, the relevant concept of MySQL introduction
Second, the configuration of MySQL under Windows
Configuration steps
Start, stop, and uninstall of MySQL service
Third, the basic composition of MySQL
If the Apt-get is installedsudo apt-get--purge Remove Mysql-serversudo apt-get--purge Remove mysql-clientsudo apt-get--purge Remove Mysql-commonApt-get-f AutoremoveApt-get AutoCleanrm/etc/mysql/-Rrm/var/lib/mysql/-R---------------Copy to
1, download the compressed package: To download the free installation of MySQL compression package http://dev.mysql.com/downloads/mysql/According to the machine select 64 or 32 bit:2, unzip to the corresponding directory. I extracted it under
MySQL database backup and recovery methodMysql-uroot-pshow databases;1. Export the database1). MySQL command line export entire database (contains data)The export file is present in the Mysql\bin directory by defaultMysqldump-u user name-p database
StringThe string is similar to ‖i like Mysql.‖ and ' MySQL is powerful. ' Such values can be enclosed in double quotes or single quotes.Not only can you use normal characters in a string, but you can also use several escape sequences, which are used
MySQL version:5.5.40 MySQL Community serverWhether you are connecting from GUI software or Java through JDBC, always prompt for errors:The LastPacket sent successfully to the server was0milliseconds ago. The driver has no received any packets
In OJ, MySQL is primarily used to store user information. Its installation and use is relatively simple, the following brief introduction. First of all, my Linux branch environment is Ubuntu 12.04, the other branches of the approximate steps are
Under the Mac installed MySQL, want to set up the boot from start, originally thought and the General Linux system, is also in RC.D such directory placement startup script. On the Internet to check some information, found that Apple should be
Http://hi.baidu.com/liangjian1024/blog/item/6861541b1416094842a9ad7c.htmlTable finance has two fields as followsDate DateMoney Double (15,2)The following need for the 2010 financial data of the table finance, monthly statisticsSQL code
Select
A database is a critical part of a high availability project in which customers need to be highly available. Many of MySQL's high-availability studies have been made, with more MySQL cluster and MySQL master-slave replication.MySQL cluster is too
mysql> ALTER TABLE name modify column field name type;For exampleThe Address Table City field in the database is varchar (30)Modification types can be used (careful modification of types may result in errors in existing data)mysql> ALTER TABLE
The recent use of MySQL database is a bit higher than the version encountered, insert and modify statements such as failure conditions. The statement has no errors, but Workbench prompts Field ' id ' doesn ' t has a default value. Reason isThe
Disk Space Trend Analysis of MySQLschema and binarylog
Disk Space Trend Analysis of MySQL schema and binary log
[root@skatedb55 dist]# ./mysqlsize --helpusage: Database diskspace usage v0.1 ,(C) Copyright Skate 2014[-h] [--load LOAD] --dbtype DBTYPE
MySQLInnoDB lock mechanism (2)
MySQL InnoDB supports three row locking methods:Record Lock: the Lock is directly added to the index Record. Gap Lock: When a Lock is added to a non-existent free space, it can be the space between two index records,
CentOS Study Notes-MySQL installation, centos-mysqlInstall MySQL
MySQL is the most widely used database in Linux. The version installed using the online yum method lags behind several minor versions on the MySQL website. This section tests and
Usage of mysqlhavingHaving usage
Having clauses allow us to filter various data After grouping. where clauses filter records before aggregation, that is, before group by and having clauses. The having clause filters group records after
7. mysql-cluster-Installation
This article describes how to install Mysql-Cluster. First, let's take a look at the following: (linux User, debian myself)
MySQL Cluster is a technology that allows you to deploy the "in memory" Database Cluster in a
MySQL self-study (8)
2. String functions (1) functions for calculating the number of character strings and functions for String Length
CHAR_LENGTH (str) returns the number of characters contained in the str string. A multi-byte character is counted
MySQL slow Query
Slow query (slow log)It can help us locate specific SQL statements for SQL statement optimization. For example, slow query logs record the SQL statements whose execution time exceeds the given value, so as to locate the
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