Using DELETE FROM with INNER JOIN
Ever needed to delete a table? Oh wait it’s joined to another. Well here’s some how you do it… the right way!
For MSSQL
DELETE Users
FROM Users u
INNER JOIN
Profiles p on u.UserID = p.UserID
WHERE u.UserIsArchived = 1
For MySQL
DELETE u, p
FROM Users u
INNER JOIN Profiles p ON u.UserID = p.UserID
WHERE u.UserIsArchived = 1… Continue reading
XAMPP for Windows
I recently started using this program its fantastic! It’s like Uniform Server yet slightly better. XAMPP is a type of WAMP (Windows/Apache/MySQL/PHP) that runs straight off your computer.
http://www.apachefriends.org/en/xampp-windows.html
Uniform Server on the other can run off a single usb – simply by running the app it mounts a virtual drive for your web server and off you go. When your done, simply stop and the drive is unmounted. On the other Continue reading
Email Subscription
Latest Tweets
@GameSpy Barb, it was my very first character in Diablo 2 and I can't wait to play it again - posted on 15/05/2012 07:32:57- #diablo3 - posted on 15/05/2012 05:24:55
- Well done reds!! Liverpool v Chelsea 4-1 full time RT @empireofthekop: All the goals here http://t.co/UQt2VA90 - posted on 09/05/2012 07:06:58
- hump day, you could not have come sooner #win - posted on 09/05/2012 06:40:19
- @DHughesy @nova100 196 retweets from hughesy last night, great work! http://t.co/zYAeXL8N - posted on 09/05/2012 06:16:34
Recent Comments
- Omar on iOS5 create custom ringtone for iPhone
- amr on iOS5 create custom ringtone for iPhone
- Dan on DNF Photography
- Edu on I/O Error: Cannot run program “javac”: CreateProcess error=2
- MaryD on iOS5 create custom ringtone for iPhone
Tags
Advertising
Archives
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- September 2009
- July 2009
- May 2009