467,149 Members | 1,351 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

update

EXAMPLE:

SNO NAME

5 jony
4 rocky
1 jojo
6 raman
2 hero
3 monty


in this example if i want to arrange SNO in order (increasing) then how i can update or arrange the column SNO.

pls tell me.
Sep 13 '08 #1
  • viewed: 736
Share:
1 Reply
code green
Expert 1GB
in this example if i want to arrange SNO in order (increasing) then how i can update or arrange the column SNO
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM example ORDER BY sno ASC.
Expand|Select|Wrap|Line Numbers
  1. UPDATE example SET name = 'newinfo' WHERE sno = 5
for example
Sep 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Dave | last post: by
8 posts views Thread by Lauren Quantrell | last post: by
16 posts views Thread by Philip Boonzaaier | last post: by
5 posts views Thread by PAUL | last post: by
8 posts views Thread by Zorpiedoman | last post: by
5 posts views Thread by Stephen Plotnick | last post: by
3 posts views Thread by Michel Esber | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.