询问MySQl中的删除语句 [英] Asking about delete Statement in MySQl

问题描述

你好！

任何人都可以通过MySql中的Deleting Statement帮助我.我想删除一个值(从现在起7天)的表.如图所示:

<a href="http://i1137.photobucket.com/albums/n512/character_kute/ASP%20net%20MVC2/Question.jpg">http://i1137.photobucket.com/albums/n512/character_kute/ASP%20net%20MVC2/Question.jpg</a>

Hello !

Can anyone help me with the Deleting Statement in MySql. I want to delete a Table with value ( 7 days from now ). As picture bellow:

<a href="http://i1137.photobucket.com/albums/n512/character_kute/ASP%20net%20MVC2/Question.jpg">http://i1137.photobucket.com/albums/n512/character_kute/ASP%20net%20MVC2/Question.jpg</a>

推荐答案

运行MySql事件，如所讨论的^ ].

Run a MySql event as discussed here[^].

那么，如何在C#中使用它?您能给我一个更清晰的代码示例吗?

So, how can i use it in C#? can you give me a code sample more clearly about that?

您需要在sql语句中使用dataadd函数.

Mysql Date函数 [

you need to use the dataadd function in a sql statement.

Mysql Date functions[^]

either use this in the delete statement as a sub query or delete in your application.

这篇关于询问MySQl中的删除语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！