5 items | 1 visits
These links provide various basic syntax, techniques and examples on obtaining information and knowledge from MySQL databases
Updated on Nov 05, 09
Created on Nov 05, 09
Category: Computers & Internet
URL:
"SQL UNION allows you to combine two or more result sets from select statements into a single result set. The usage of using SQL UNION is as follows:"
"Skip Navigation Links » MySQL Tutorial » Aggregate Functions
MySQL Aggregate Functions
In some cases, the information we need is not actually stored in the database but we can retrieve it by computing in some ways from stored data."
"SQL LIKE allows you to perform pattern matching in your characters column in a database table. SQL LIKE is often used with SELECT statement in WHERE clause. MySQL provides you two wildcard characters for use with LIKE, the percentage % and underscore _. "
"SQL BETWEEN allows you to retrieve values within a specific range. The usage of SQL BETWEEN is as follows:"
"SQL IN allows you to select values which match any one of a list of values. The usage of SQL IN is as follows:"
5 items | 1 visits
These links provide various basic syntax, techniques and examples on obtaining information and knowledge from MySQL databases
Updated on Nov 05, 09
Created on Nov 05, 09
Category: Computers & Internet
URL: