first, from the operating system, said :1. We know that MySQL is cross-platform and it can run on many platforms such as Windows, Linux, Unix (MAC). Linux is Unix-like,But Windows and Linux have a very big difference. Windows: File names are
================================ installation Version =======================================The MySQL installation version requires the following two software:Tip: For. NET 4 framework-related, install the-->net4_ framework first. rarTip: Microsoft
The MySQL system database primarily stores some system information tables that store MySQL services. In general, MySQL library tables are Myasim engines, except in individual cases. The functions of the MySQL library table can be broadly divided
--select num from table GROUP by Num--select Num from table GROUP by num,nid--Special: Group by must be in where, after order by--select Num,nid F Rom table where nid > Group by Num,nid Order by Nid desc--Group BY is key-can be connected to
Per entity, one tableWhen a business requires data from more than one entity, it is obvious that multiple tables are used together, and the records of multiple tables are connected.1. General Ideas :First, all the data is connected to a certain
(1) server 1 configuration 1) Install Mariadb-server[Email protected] ~]# yum-y install Mariadb-server2) Edit the/etc/my.cnf file[[email protected] ~]# VIM/ETC/MY.CNF Add the following at the end of the [mysqld] segment skip_name_resolve = on innodb_
Development encountered 650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/ Zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "spacer.gif"/> A page of shops, need to
1. Order by (sort)A field is typically used as the reference standard for sorting.Syntax: ORDER BY "Field" ASC|DESC; (ascending, descending)Tip: Proofing rules determine the sort relationship.Allow multi-field sorting (Sort by first field, sort by
MySQL's official address: https://www.mysql.com/Community Latest Version: 5.7.18There are two kinds of download formats: Installer and zip twoBrief introduction in ZIP format:Copy the contents of the compressed package to the desired directory (e.g.,
Nearly spent a day in a MySQL database, record the twists and turns.1. Just start the Community version downloaded from the official website, unzip, copy, install, but how to install the unsuccessful;2. Today a change of mind to see the online yum
Requirements: Get the record information that is grouped by table1_id and age maximum, i.e. 2, 3, 5 method One: SELECT * FROM (SELECT * from Table2 ORDER BY age DESC) as a group by a.table1_id method Two: Select A.* from Table2 as a where age =
Transactions: Treat the business process as a minimal business processing unitFor example: Friend transferThere are four main features of transactions:Atomicity: the smallest unit with function is inseparable;Persistent: The correct data for
MySQL information_schema and informationschemaThe information_schema database is a MySQL database that provides access to database metadata. It seems that information_schema is like an encyclopedia of a MySQL instance, which records most of the
MySQL commonly used statements for table creation, adding fields, modifying fields, and adding indexes.
This article describes the common SQL statements used by MySQL to create tables, add fields, modify fields, and add indexes. We will share this
MySQL uses variables for sorting, and mysql variables for sorting
Core code
-- Below I will demonstrate the implementation of sorting columns in MySQL -- CREATE TABLE tb (score INT) test data ); INSERT tb SELECT 5 union all select 4 union all select
Recursion in MySQL: recursion in MySQL
Mysql itself does not support recursive syntax, but some simple recursion can be achieved through self-connection in disguise
-- Recursive small method: Different Methods for temporary tables and normal tables -
Mysql specifies the sorting Implementation Method for a row or column, and mysql specifies the sorting
Method:
Desc:
Cannot achieve:
Method 1:
Select sp. productid, sp. productname, ss. sku from sp_product sp inner join sku_skus ss on sp.
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