sql查询更新 [英] sql query for update

问题描述

我是一个更新鲜的帮我...

S_ID，Name，Subject，Mark1，Mark2这些是我的字段，我想更新它.我需要更新查询，我的表名是tb_studentinfo ..，还提供了VB.net编码

hi i am a fresher help me...

S_ID,Name,Subject,Mark1,Mark2 these are my fields,, i want to update this.. i need query for updating,,my table name is tb_studentinfo.. and also give VB.net codings

推荐答案

您可以使用与此类似的查询.

You can use query similar to this.

Update tb_studentinfo set Name='anyName',Subject='anySubject',Mark1=100,Mark2=79 where S_ID=10

仍然需要学习如何做.
Google [ ^ ]来获得一本好书/文章.
http://www.perfectxml.com/sybex/Files/2878ch06.pdf [ ^ ]

Still you need to learn how to do this.
Google[^] for a good book/article.
http://www.perfectxml.com/sybex/Files/2878ch06.pdf[^]

实际上您是需要学习而不是得到这个问题的答案.浏览 SQL教程@ w3schools [ SQL UPDATE语句 [

Actually you need to learn instead of getting answer for this question. Browse SQL Tutorial @ w3schools[^]

Try this

SQL UPDATE Statement[^]

Update tb_studentinfo set Name='YOUR CHOICE',Subject='YOUR CHOICE',Mark1='YOUR CHOICE',Mark2='YOUR CHOICE' where S_ID=102

这篇关于sql查询更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！