|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
![]() |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
|
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: Europe
Posts: 3,055
|
Need little help qith SQL query
I need to update few rows of data but only for range of entries with ID's between 40 and 100.
so update table set field='blah-blah' where id ---- ???
__________________
My Network Is Waiting For Your Fuckin' Trade!
|
|
|
|
|
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Apr 2004
Location: OC
Posts: 720
|
update table set field='blah blah' where id >= 40 and id <=100
__________________
|
|
|
|
|
|
#3 |
|
Confirmed User
Join Date: Jul 2004
Location: The Beach
Posts: 4,626
|
correct.
__________________
ICQ# 143561781 |
|
|
|
|
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Jun 2004
Location: Europe
Posts: 3,055
|
I kiss you.
Thanks
__________________
My Network Is Waiting For Your Fuckin' Trade!
|
|
|
|
|
|
#5 |
|
Too lazy to set a custom title
Join Date: Mar 2002
Location: Australia
Posts: 17,393
|
Try also
UPDATE table SET field='blah blah' WHERE id BETWEEN 40 AND 100 |
|
|
|