SQL - BETWEEN Operator Example

The following SQL statement selects all products with a price BETWEEN 10 and 20: Example SELECT * FROM ProductsWHERE Price BETWEEN 10 AND 20; Try...

SQL - IN Operator Example

The following SQL statement selects all customers with a City of "Paris" or "London": Example SELECT * FROM CustomersWHERE City IN ('Paris','London'); Try...

SQL - LIKE Operator Examples

The following SQL statement selects all customers with a City starting with the letter "s": Example SELECT * FROM CustomersWHERE City LIKE 's%'; Try...

SQL - Delete All Data

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact: DELETE FROM table_name;orDELETE * FROM table_name; Note: Be...

SQL - DELETE Example

Assume we wish to delete the customer "Alfreds Futterkiste" from the "Customers" table. We use the following SQL statement: Example DELETE FROM CustomersWHERE CustomerName='Alfreds...

SQL - Update Warning!

Be careful when updating records. If we omit the WHERE clause, ALL records will be updated: Example UPDATE CustomersSET ContactName='Juan'; Try...

SQL - UPDATE Multiple Records

In an update statement, it is the WHERE clause that determines how many records which will be updated. The WHERE clause: WHERE Country='Mexico' will...

SQL - UPDATE Multiple Columns

To update more than one column, use a comma as seperator. Assume we wish to update the customer "Alfreds Futterkiste" with a new contact person and city. We...

SQL - ORDER BY Several Columns Example 2

The following SQL statement selects all customers from the "Customers" table, sorted ascending by the "Country" and descending by the "CustomerName"...

SQL - ORDER BY Several Columns Example

The following SQL statement selects all customers from the "Customers" table, sorted by the "Country" and the "CustomerName" column: Example SELECT * FROM CustomersORDER BY Country,...

SQL - ORDER BY DESC Example

The following SQL statement selects all customers from the "Customers" table, sorted DESCENDING by the "Country" column: Example SELECT * FROM CustomersORDER BY Country DESC; Try...

SQL - ORDER BY Example

The following SQL statement selects all customers from the "Customers" table, sorted by the "Country" column: Example SELECT * FROM CustomersORDER BY Country; Try...

SQL - Combining AND & OR

You can also combine AND and OR (use parenthesis to form complex expressions). The following SQL statement selects all customers from the country...

SQL - OR Operator Example

The following SQL statement selects all customers from the city "Berlin" OR  "München", in the "Customers" table:  Example SELECT * FROM CustomersWHERE City='Berlin'OR City='München'; Try...

SQL - AND Operator Example

The following SQL statement selects all customers from the country "Germany" AND the city "Berlin", in the "Customers" table: Example SELECT * FROM CustomersWHERE Country='Germany'AND City='Berlin'; Try...

SQL - Operators in The WHERE Clause

The following operators can be used in the WHERE clause: OperatorDescription =Equal <>Not equal. >Greater than <Less than >=Greater...

SQL - Text Fields vs. Numeric Fields

SQL requires single quotes around text values (most database systems will also allow double quotes). However, numeric fields should not be enclosed...

SQL - WHERE Clause Example

The following SQL statement selects all the customers from the country "Mexico", in the "Customers" table: Example SELECT * FROM CustomersWHERE Country='Mexico'; Try...

SQL - SELECT DISTINCT Example

The following SQL statement selects only the distinct values from the "City" columns from the "Customers" table: Example SELECT DISTINCT City FROM Customers; Try...

SQL - SELECT * Example

The following SQL statement selects all the columns from the "Customers" table: Example SELECT * FROM Customers; Try it Yourself...

SQL - SELECT Column Example

The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table: Example SELECT CustomerName,City FROM Customers; Try...

SQL - Comments in Statements

To ignore just a part of a statement, use the /* */ comment. Any text between /* and */ will be ignored. Example Ignore part of a line: SELECT CustomerName, /*City,*/ Country FROM Customers; Try...

SQL - Multi-line Comments

Multi-line comments start with /* and end with */. Any text between /* and */ will be ignored. Example A multi-line comment as an explanation: /*Select...

SQL - Single Line Comments

Single line comments start with --. Any line between -- and the end of the line will be ignored (will not be executed). Example A single-line...

Some of The Most Important SQL Commands

SELECT - extracts data from a database UPDATE - updates data in a database DELETE - deletes data from a database INSERT...

HTML Form - The Submit Button

<input type="submit"> defines a button for submitting the form data to a form-handler. The form-handler is typically a server...

HTML Form - Radio Button Input

<input type="radio"> defines a radio button. Radio buttons let a user select ONE of a limited number of choices: Example <form>   <input type="radio" name="gender" value="male" checked> Male<br>   <input type="radio" name="gender" value="female"> Female<br>   <input type="radio" name="gender" value="other"> Other </form> Try...

Following tips

Friends please follow my blog to get direct updates in your mailbox. Get direct mail to you about new posts and updates. Thanking You Abhishek ...

HTML Form - Text Input

<input type="text"> defines a one-line input field for text input: Example <form>  First name:<br>  <input type="text" name="firstname"><br> ...