|
|
|
|
||||
|
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 |
01-13-2011, 09:33 AM
|
#1 |
|
(felis madjewicus)
Industry Role:
Join Date: Jul 2006
Location: In Mom & Dad's Basement
Posts: 20,368
|
MySQL question regarding truncating tables.
Can you Truncate a table with a WHERE clause, and remove only elements which match a certain criteria? Or is TRUNCATE simply used to wipe the entire table?
|
|
|
|
01-13-2011, 09:41 AM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Aug 2006
Location: Poland
Posts: 9,228
|
truncate wipes entire table, you want delete.
DELETE FROM `tablename` WHERE foo = 'bar'
__________________
Mechanical Bunny Media Mechbunny Tube Script | Mechbunny Webcam Aggregator Script | Custom Web Development |
|
|
|
|
01-13-2011, 09:48 AM
|
#3 | |
|
(felis madjewicus)
Industry Role:
Join Date: Jul 2006
Location: In Mom & Dad's Basement
Posts: 20,368
|
Quote:
|
|
|
|
|
|
01-13-2011, 10:21 AM
|
#4 |
|
Too lazy to set a custom title
Join Date: Jan 2002
Location: Holland
Posts: 9,870
|
stay away from mysql if you dont know the difference between del and truncate
__________________
Don't let greediness blur your vision | You gotta let some shit slide icq - 441-456-888 |
|
|
|
|
01-13-2011, 10:54 AM
|
#5 | |
|
(felis madjewicus)
Industry Role:
Join Date: Jul 2006
Location: In Mom & Dad's Basement
Posts: 20,368
|
Quote:
|
|
|
|
|
|
01-13-2011, 10:57 AM
|
#6 |
|
Making PHP work
Industry Role:
Join Date: Nov 2002
Location: 🌎🌅🌈🌇
Posts: 20,542
|
NoSQL FTW!!!
__________________
Make Money with Porn |
|
|
|
