MySQL-8.0.15 - SELECT 语句

SELECT 查询语句

　查询1

USE sql_store;

SELECT *
FROM customers
-- WHERE customer_id = 1
ORDER BY first_name;

查询 2

SELECT 
    last_name,
    first_name,
    points,
    points * 10 + 100
FROM customers;

练习

-- Return all the products
-- name
-- unit price
-- new price (unit price * 1.1)

SELECT
    name,
    unit_price,
    unit_price * 1.1 AS new_price
FROM products;