When you use the UNION command, you are stacking one result set on top of another. This is slightly different from the JOIN command, and this video is here to explain what the difference is and the best way to use UNION in your own MySQL database programs.
Recently, China shut down access to Google in the country because their Propaganda Minister didn't like the results when he Googled himself. Since you probably can't do that, watch this video for tips on how you can keep information about yourself off of Google. The key: if you don't want it to be shared, don't put it online.
You can use ribbon as a tree decoration! This tutorial shows you how to take a spool of wide ribbon (use wired ribbon for best results) and use it to create a unique and eye catching holiday decoration for your Christmas tree.
Isolations are basically isolating single body parts - the hands, one leg, even one knee - to perform a dance move focused on that one body part. This means you can perform an isolation by popping your knee or gliding your arm up and down, for example.
You can of course purchase the super expensive waxes, balms, and texturizers at the store to tame frizzy, unruly hair. But why spend $20 on a teeny bottle of product when you can get the same results for about $3? All you have to do is purchase some hand cream and rub it anywhere you need extra hold.
If you have an iPad, you can hack a Kinect and connect them together so you can redefine the Kinect's planes of interest. You can even used the accelerometer in the iPad to transfer data to your Kinect and display the results on a computer screen.
The words we know and use shape the context in which we think, and changing those words in your internal processes can lead to dramatically different and better results. Watch this video to learn how words of affirmation and encouragement, spoken to yourself and to others, can change your outlook and improve every facet of your life.
In this video tutorial, we learn how to perform the "Infinity Mirror" magic trick. For more information about the trick and its execution, including detailed, step-by-step instructions, and to get started incorporating this trick into your own routines, watch this free video magic lesson.
If you're scared of curling your hair because you don't want to damage your hair through heated products like flat irons and curling irons, then here is a more eco-friendly, heat-free alternative that costs almost nothing but produces gorgeous results.
Want to get better results when you run Pro Tools on your PC? This tutorial shows you the easy step of disabling disk compression and indexing, two steps you can use to get the maximum efficiency out of real time applications like Pro Tools.
Sometimes black bars can appear on videos you have uploaded to YouTube (or any other video sharing website). This can get annoying, and is usually the result of uploading a video whose aspect ratio is not synced up with YouTube. This video shows you a couple fixes to getting rid of those bars.
The interesting thing about painting in the Chinese watercolor style is that objects, animals, and plants that look pretty simple, such as goldfish and snakes, are actually made up of a complex array of different layers and colors.
Growing your own vegetables are a cheap alternative to going out to the grocery store and buying it. Plus, it will taste much better and you will feel better about yourself as you eat them! If you're looking to grow Asparagus but aren't really sure where to start, check out this video. In it you will learn the best environment to grow them in and what the fastest way is to get the best result.
Adobe Dreamweaver CS4 gives you several tools that you can use to manage your website without having to know the PHP or MySQL programming languages. This is a great way to keep track of and manage your website without having to learn how to code!
You can certainly use Photoshop to do do freehand figure drawing! This tutorial shows you how to make a drawing, starting with a sketch, from a photograph while using Adobe Photoshop. Then add in some coloring, shading and highlights, and then use color theory to bring out the most important lines.
This makeup tutorial will help you apply a makeup look inspired by the beautiful (but recently deceased) R&B artist Aaliyah. This look is from some beauty promotional pictures that Aaliyah did before her death, and she looks absolutely gorgeous in them. Watch and learn how to apply this makeup yourself! Check out the picture results.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to sum inches and feet, expressing your result in feet.
Looking for a new card trick to add to your repetoir? Maybe you're just a spectator looking to see "how the trick works"? Welcome to "Your Name Is The Key" a fantastic card trick that involves displaying the spectators card by counting the cards for each letter in the sentence. This video goes into great detail for each step showing you how he performs the trick and various methods to getting the best results.
If you're interested in getting someone back or just would like to play a nice little prank, this next video will show you how. In this tutorial, you'll be performing a car prank involving the car's exhaust. It doesn't damage the car, but it does take power away from the car temporarily and results in a loud bang from a balloon. So check out the video above, be safe, and enjoy!
If you're new to gardening, it's important you know some of the best tricks. Not being able to do something properly can result in flowers that may soon die. One thing that is important is watering your plants just right during the summer. So in this tutorial, you'll find out how to effectively water your garden in order to beat the summer heat. Pay attention and good luck!
If you've never owned a snowboard before, this next tutorial is very useful to help ensure that it will last a long time. In this tutorial, you'll find out how to properly store your snowboard during the summer months.
One of the most commonly damaged parts of a vacuum cleaner is the brushroll. Not properly taking care of the brushroll can result in something that is useless.
If you're playing Lost Planet 2 and are looking for how you can get a nuke of your very own in multiplayer, this video will help.
It's another tutorial for the God of War-like game, Dante's Inferno. In this tutorial, you'll be finding all 30 pieces of silver throughout the game. Along with the silver, you'll be awarded with three achievements. Find ten pieces and unlock Footsteps of a Traitor, 20 awards you with Betrayed with a Kiss, and all three will result in Well Done, Judas. So good luck and have fun!
In this next achievement tutorial, you're going to be playing the hit Xbox 360 title, Mass Effect 2. In this intergalactic, space game you need to shoot and kill 20 enemies adter they;ve been knocked back by a punch. It's fairly easy to get, but if not done quickly enough will result in a great amount of damage.
When using a lathe, it's important to make sure that your tools are sharp enough to that you can get the best quality cut or groove for your project. A dull blade can result in a poor looking product and can hurt the way it looks.
Caring for your front load washer is important for ensuring that it will work for years. Improper care and maintenance will result in a constantly broken machine that will eat up your money.
If you have a really noisy washer, it's a sign that something needs to change. Not only can it be annoying, but it can cause further damage to your machine as well.
If you've recently purchased a new fridge and have hooked up the line for the water dispenser, you need to get rid of any air before trying to drink water. Having excess air in the line can result in you getting more water than you may have wanted. It's easy to do and will make things easier when trying to get water. So good luck and enjoy!
This next tutorial is one that will definitely have you using the Fal over some other weapons. This glitch video shows you how you can have an automatic fal gun. This comes in handy since this gun can be pretty powerful. It's really easy to follow and will result in a very useful weapon when the time comes. So check it out, good luck, and enjoy!
If you live in an area where it gets really cold during winter, you may or may not know the importance of protecting your pipes. Not covering them with proper insulation can result in frozen pipes that are a pain to fix and can cost you a lot of money. So in this tutorial, you'll be finding out how to properly insulate your pipes for the winter months. Good luck and enjoy!
If you want to make a movie with zombies, or the apocalypse, or the apocalypse and zombies, then you are going to have to learn how to create a really haggard-looking, disease-ridden face out of makeup. This video will show you how to do it using Rice Krispies, among other things. The end result is terrifying, and sure to scare your audiences or trick-or-treating targets into doing what you want (buying theater tickets or giving your candy, respectively).
The great thing about owning a car, is that you're able to customize almost every part of it. This can result in better performance and something that sounds cool or looks cool. In this tutorial, you'll be finding out how to install a sprintboost on a 2008 Mini Cooper S. This can give you a faster throttle response in your car and improves the performance of your vehicle significantly. So check it out and good luck!
Choosing which paint is right for your room, is easier than it is today than in the past. Instead of just using paint swatches to help determine what color your room should be, buying paint samples from the store is a great way to see quick results. There are some other methods, too, when trying to select the right wall color for your room, so check out the video to find out more. Enjoy!
When using a chainsaw, it's important to know when and if you need to add tension to your chain. Not doing so can result in a loose chain that can not only damage your machine, but cause serious injury to you or others. So in this tutorial, you'll be finding out how to add tension to your chainsaw easily. Good luck, enjoy, and be careful!
When doing woodworking projects, it's important to know how to measure things properly. Not doing so, can result in crooked pieces and unbalanced projects. So in this tutorial, you'll find out how to measure stuff without using a ruler in woodworking. Good luck, enjoy, and always play it safe!
This Halloween, why not try something that will blow your guests away? Watch this video to learn how to make an awesome jack-o'-lantern cake. Your guests will be left oohing and aahing over the results. This video will walk you through each step of the way, from cutting the cake appropriately to decorating it.
Pearls need not look stale, aged, and only appropriate for your great aunt Margaret. Add some youthfulness and pizazz to pearls by learning how to make a cute ribbon-tied pearl bracelet.
When restoring a vehicle, it's important to keep the car clean as well as protected for anything harmful. So in this auto tutorial, you'll be finding out how to keep the mohair headliner clean in a classic VW Beetle Bug. It may sound easy, but not knowing how to clean things properly can result in a big mess. So good luck and enjoy!
In this next woodworking tutorial, you'll be finding out how to make fancy raised panels for cabinets or anything else. You'll be combining two pieces of wood to create a walnut and maple sandwich. It's a little tricky to do, but n the end will result in beautiful pieces of wood. So good luck and enjoy!