Tag: sql

All the articles with the tag "sql".

• SQL 聚合查询 GROUP BY

  Published:May 15, 2019 |  at 08:00 AM

  五个常用的聚合函数 - COUNT - SUM - AVG - MAX - MIN - **计算行数** ```SQL SELECT COUNT(*) FROM `Product`

• SQL SELECT 查询基础

  Published:May 8, 2019 |  at 08:00 AM

  ```SQL SELECT * FROM Product; ``` ```SQL SELECT product_id AS '商品别名', product_name AS '商品名字',

• SQL CREATE 建表

  Published:May 1, 2019 |  at 08:00 AM

  数据库选的是 MySQL，语法是 MySQL 语法。 ```SQL CREATE DATABASE shop; ``` ```SQL CREATE TABLE Product(