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
