10 Most Popular Amazon AWS Storage and Database Services If you are new to Amazon AWS, and looking at their offerings, it can be bit confusing, as they have lot of services. If you are just looking to launch a virtual server on the cloud, it is relatively straight forward, and you can use Amazon’s EC2 service. But, when it comes to storage and database for your virtual instance on the cloud, Amazon has multiple choices. In this tutorial, we have listed the most popular storage and database services available from Amazon. 1....

25 Essential MySQL Select Command Examples

Essential MySQL Select Command Examples If you are using MySQL database, it is essential that you become comfortable with mysql command line. In this tutorial we’ll explain how to use the MySQL select command with several practical examples. 1. Basic Select command Example First, to connect to MySQL command line, do the following from your operating system prompt. # mysql -u root -p Password: Next, view all available databases. mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema...

12 Essential MySQL Insert Command Examples

Essential MySQL Insert Command Examples One of the common MySQL operation is to insert records into a table. This tutorial explains how to use MySQL insert command with several practical and useful examples. The following example will connect to devdb database with username devuser and password mysecretpwd # mysql -u devuser -pmysecretpwd devdb mysql> For this tutorial, we’ll insert values into employee table. This is the structure of the employee table. mysql> desc employee; +--------+-------------+------+-----+---------+----------------+ |...

11 Essential MySQL Update Command Examples

Essential MySQL Update Command Examples One of the most common MySQL operation is to change an existing value of a record in a table. In this article, we’ll explain how to use MySQL update command along with some helpful examples. The following are covered in this tutorial: Update All Rows Update Only Selected Rows Update Column Value with Expression DEFAULT keyword usage in Update Update Multiple Columns at the Same Time Using LIMIT clause in Update Multiple Table Update (using Inner Join) Multiple Table Update (Using Left Join) Return...