mysql语句中select sum into
时间: 2023-11-04 18:33:45 浏览: 45
SELECT SUM(column_name) INTO variable_name FROM table_name;
This statement selects the sum of values in a specific column of a table and stores the result in a variable. The variable can be used later in the code or displayed to the user.
相关问题
Mysql语句整理大全
MySQL语句整理大全如下:
1. 创建数据库:
```
CREATE DATABASE database_name;
```
2. 删除数据库:
```
DROP DATABASE database_name;
```
3. 切换到指定数据库:
```
USE database_name;
```
4. 创建数据表:
```
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
.....
);
```
5. 删除数据表:
```
DROP TABLE table_name;
```
6. 插入数据:
```
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
```
7. 更新数据:
```
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
```
8. 删除数据:
```
DELETE FROM table_name WHERE condition;
```
9. 查询数据:
```
SELECT column1, column2, ... FROM table_name WHERE condition;
```
10. 查询数据并排序:
```
SELECT column1, column2, ... FROM table_name WHERE condition ORDER BY column1 ASC|DESC, column2 ASC|DESC, ...;
```
11. 查询数据并限制返回结果的数量:
```
SELECT column1, column2, ... FROM table_name WHERE condition LIMIT num;
```
12. 查询数据并分页:
```
SELECT column1, column2, ... FROM table_name WHERE condition LIMIT start, num;
```
13. 查询数据并计算统计值:
```
SELECT COUNT(column_name) FROM table_name WHERE condition;
```
14. 查询数据并计算平均值:
```
SELECT AVG(column_name) FROM table_name WHERE condition;
```
15. 查询数据并计算最大值:
```
SELECT MAX(column_name) FROM table_name WHERE condition;
```
16. 查询数据并计算最小值:
```
SELECT MIN(column_name) FROM table_name WHERE condition;
```
17. 查询数据并计算总和:
```
SELECT SUM(column_name) FROM table_name WHERE condition;
```
这些是MySQL语句的常见用法,希望对你有帮助。
mysql语句大全及用法
MySQL 是一种流行的关系型数据库管理系统,下面是一些常用的 MySQL 语句及其用法:
1. 创建数据库
CREATE DATABASE database_name;
2. 删除数据库
DROP DATABASE database_name;
3. 选择数据库
USE database_name;
4. 创建表
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
.....
);
5. 删除表
DROP TABLE table_name;
6. 插入数据
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
7. 更新数据
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
8. 删除数据
DELETE FROM table_name WHERE condition;
9. 查询数据
SELECT column1, column2, ... FROM table_name WHERE condition;
10. 排序
SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC|DESC;
11. 分组
SELECT COUNT(column_name), column_name
FROM table_name
GROUP BY column_name;
12. 连接
SELECT column_name(s)
FROM table_name1
JOIN table_name2
ON table_name1.column_name = table_name2.column_name;
13. 子查询
SELECT column_name(s)
FROM table_name
WHERE column_name IN (SELECT column_name FROM table_name WHERE condition);
14. 嵌套查询
SELECT column_name(s)
FROM table_name
WHERE column_name operator
(SELECT column_name FROM table_name WHERE condition);
15. 合计函数
SELECT AVG(column_name)
FROM table_name;
16. 最大/最小值
SELECT MAX(column_name)
FROM table_name;
17. 计数
SELECT COUNT(column_name)
FROM table_name;
18. 求和
SELECT SUM(column_name)
FROM table_name;
以上是 MySQL 常用的一些语句及其用法,希望对你有帮助!