Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
nocgod17558yPro tip: always begin your update queries as select and only when you select only what you want to update - put the update in.
-
personally I always break the query until I'm done writing it where nothing will screw up
-
Pro tip, use triggers to output a copy of each row to a backup table, prior to delete and updates.
Related Rants
-
cdrice105"You gave us bad code! We ran it and now production is DOWN! Join this bridgeline now and help us fix this!" ...
-
MoboTheHobo36My Friend: Dude our Linux Server is not working anymore! Me: What? What did you do? My friend: Nothing I swe...
-
tommy15Right now someone at Google is coding something useless for us to laugh at on April Fools.
Never forget the where clause in an UPDATE query.......
undefined
fml