帮我写一段删除体检数据表的SQL
时间: 2023-05-20 22:04:47 浏览: 66
Sure, here's an example SQL statement to delete data from a physical examination table:
```
DELETE FROM physical_examination WHERE exam_date < '2021-01-01';
```
This statement will delete all records from the physical_examination table where the exam_date is before January 1st, 2021.
相关问题
帮我写一段查询供货清单表的sql
当然可以,以下是一段查询供货清单表的 SQL:
SELECT * FROM 供货清单表;
如果你需要更具体的查询,可以加上 WHERE 子句,例如:
SELECT * FROM 供货清单表 WHERE 供应商 = 'ABC公司';
希望这可以帮到你!
帮我写一段sql查去年今天的数据
SELECT * FROM TABLE_NAME WHERE YEAR(date_column) = YEAR(CURDATE()) - 1 AND DAY(date_column) = DAY(CURDATE());
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)