vue实现点击换肤
1. 创建表结构
首先，我们需要创建表结构。假设表名为 users，包含以下字段：
id: 主键name: 用户姓名age: 用户年龄email: 用户邮箱
CREATE TABLE users (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT,
email VARCHAR(100)
);2. 插入数据
接下来，我们插入一些数据：
INSERT INTO users (id, name, age,) VALUES (1, 'John Doe', 25, 'john@example.com');
INSERT INTO users (id, name, age, email) VALUES (2, 'Jane Smith', 30, 'jane@example.com');
INSERT INTO users (id, name, age, email) VALUES (3, 'Bob Johnson', 35, 'bob@example.com');
INSERT INTO users (id, name, age, email) VALUES (4, 'Alice Brown', 40, 'alice@example.com');
INSERT INTO users (id, name, age, email) VALUES (5, 'Charlie Davis', 45, 'charlie@example.com');
INSERT INTO users (id, name, age, email) VALUES (6, 'Diana Evans', 50, 'diana@example.com');
INSERT INTO users (id, name, age, email) VALUES (7, 'Ethan Fox', 55, 'ethan@example.com');
INSERT INTO users (id, name, age, email) VALUES (8, 'Grace Harris', 60, 'grace@example.com');
INSERT INTO users (id, name, age, email) VALUES (9, 'Ian Jackson', 65, 'ian@example.com');
INSERT INTO users (id, name, age, email) VALUES (10, 'Kate Lee', 70, 'kate@example.com');3. 查询数据
SELECT * FROM users;4. 更新数据
UPDATE users SET age = 30 WHERE id = 1;5. 删除数据
DELETE FROM users WHERE id = 10;6. 排序数据
SELECT * FROM users ORDER BY age DESC;7. 过滤数据
SELECT * FROM users WHERE age > 50;8. 限制数据
SELECT * FROM users LIMIT 5;9. 分组数据
SELECT age, COUNT(*) FROM users GROUP BY age;10. 连接数据
SELECT * FROM users JOIN another_table ON users.id = another_table.user_id;11. 创建索引
CREATE INDEX idx_name ON users (name);12. 删除表
DROP TABLE users;13. 创建视图
CREATE VIEW user_view AS SELECT id, name FROM users;14. 删除视图
DROP VIEW user_view;15. 创建存储过程
CREATE PROCEDURE get_users()
BEGIN
SELECT * FROM users;
END;16. 调用存储过程
CALL get_users();17. 创建触发器
CREATE TRIGGER before_insert_users BEFORE INSERT ON users FOR EACH ROW SET NEW.age = 20;18. 创建事件
CREATE EVENT my_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE DO UPDATE users SET age = 30 WHERE id = 1;19. 创建函数
CREATE FUNCTION get_age() RETURNS INT DETERMINISTIC RETURN 30;20. 删除函数
DROP FUNCTION get_age;
