答:
1、
SELECT * FROM 会员表 WHERE 姓名 <> '小七';
2、-- 删除id为NULL的数据
DELETE FROM user WHERE id IS NULL;
-- 将name为NULL的name值改为"匿名"
UPDATE user SET name = '匿名' WHERE name IS NULL;
3、
SELECT 商品编号, 商品名称
FROM 商品表
ORDER BY 商品编号, 商品名称;
4、
SELECT *
FROM student
WHERE name LIKE 'h%' OR gender = '女' OR grade = 100;
5、
SELECT *
FROM student
WHERE class = 3;
6、
DELIMITER //
CREATE PROCEDURE numberTraversal()
BEGIN
DECLARE i INT DEFAULT 1;
traversal_loop: LOOP
IF i > 10 THEN
LEAVE traversal_loop;
END IF;
-- 在这里进行数字的输出或其他操作
SELECT i;
SET i = i + 1;
END LOOP traversal_loop;
END //
DELIMITER ;
-- 调用存储过程执行遍历
CALL numberTraversal();
7-1、
SELECT d.*
FROM dept d
INNER JOIN employee e ON d.dept_id = e.dept_id
WHERE e.age > 21;
7-2、
SELECT e2.*
FROM employee e1
INNER JOIN employee e2 ON e1.dept_id = e2.dept_id
WHERE e1.name = '王红';
8、
SELECT *
FROM send
WHERE DATE(sendtime) = CURDATE();
9、
CREATE VIEW sales_year_total AS
SELECT SUM(first_half) AS total_sales
FROM sales
UNION ALL
SELECT SUM(latter_half) AS total_sales
FROM sales;