如何删除colomn数据？ [英] how to delete colomn data?

问题描述

ID  name    Score   paper-II     image
1   vinod   12  paper-II       null
2   vinod   10  paper-I        null
3   vinod   0   paper-II       null
4   vinod   15  paper-I        <binary data>
5   vinod   12  paper-III      null
6   vinod   15  paper-IIII     <binary data>
7  vinod    16  paper-II       <binary data>
8   vinod   18  paper-II       null
9   vinod   13  paper-I        null

在图像列中，用户在再次上传图像后的前两次或更多次上传图像用户想要更改该图像，以便如何删除第一张图像并插入新图像image

In Image column user did not upload image in first two or more times after that upload an image again user want to change that image so how delete first image and insert new image

推荐答案

我认为没有必要删除图像数据。

你可以直接更新Image列而不是先删除它然后再插入它。

您可以使用以下查询：

Hi,
I think there is no need to delete image data.
You can directly update the Image column instead of delete it first and then insert it again.
You can use following query :

Update table SET image = <binary data=""> where ID = 1</binary>

谢谢

Thanks

这篇关于如何删除colomn数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！