以下是一些软件测试工程师可能会用到的 SQL 语句:
- 查询数据:
-
- 选择所有行和列:SELECT * FROM table_name;
- 选择特定列的数据:SELECT column1, column2 FROM table_name;
- 带有条件的查询:SELECT * FROM table_name WHERE condition;
- 插入数据:
-
- 插入一行数据:INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
- 更新数据:
-
- 更新特定行的数据:UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
- 删除数据:
-
- 删除特定行的数据:DELETE FROM table_name WHERE condition;
- 聚合函数:
-
- 计算总行数:SELECT COUNT(*) FROM table_name;
- 计算平均值:SELECT AVG(column) FROM table_name;
- 计算最大值:SELECT MAX(column) FROM table_name;
- 计算最小值:SELECT MIN(column) FROM table_name;
- 求和:SELECT SUM(column) FROM table_name;
- 连接表:
-
- 内连接:SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
- 左连接:SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column;
- 右连接:SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
- 子查询:
-
- 在 WHERE 子句中使用子查询:SELECT column FROM table_name WHERE column = (SELECT column FROM another_table);
- 排序和限制:
-
- 按某一列升序排列:SELECT * FROM table_name ORDER BY column ASC;
- 按某一列降序排列:SELECT * FROM table_name ORDER BY column DESC;
- 限制结果集的行数:SELECT * FROM table_name LIMIT 10;