Tutorial by Topics: per

Wild Card with % : SELECT * FROM [table] WHERE [column_name] Like '%Value%' Wild Card with _ : SELECT * FROM [table] WHERE [column_name] Like 'V_n%' Wild Card with [charlist] : SELECT * FROM [table] WHERE [column_name] Like 'V[abc]n%' LIKE condition in WHERE clause is used...

An .htaccess file controls how Apache interacts with your site. When an .htaccess file is placed in your domain’s directory (usually root directory), the file is detected and executed by Apache. An .htaccess file is commonly used for the following: Denying specific IPs to your site Password p...

An operator is a character that represents an action. It tells the compiler/interpreter to perform specific mathematical, relational or logical operation and produce final result. PowerShell interprets in a specific way and categorizes accordingly like arithmetic operators perform operations primari...

Profiling code is a way to avoid the dreaded practice of "premature optimization", by focusing the developer on those parts of the code that actually justify optimization efforts. MATLAB documentation article titled "Measure Performance of Your Program".

ParameterDetailsos.F_OKValue to pass as the mode parameter of access() to test the existence of path.os.R_OKValue to include in the mode parameter of access() to test the readability of path.os.W_OKValue to include in the mode parameter of access() to test the writability of path.os.X_OKValue to in...

A set contains only one copy of each distinct element. Unlike some other programming languages, base R does not have a dedicated data type for sets. Instead, R treats a vector like a set by taking only its distinct elements. This applies to the set operators, setdiff, intersect, union, setequal an...

SELECT * FROM table WHERE (condition1) AND (condition2); SELECT * FROM table WHERE (condition1) OR (condition2);

NameDescriptionASCII()Return numeric value of left-most characterBIN()Return a string containing binary representation of a numberBIT_LENGTH()Return length of argument in bitsCHAR()Return the character for each integer passedCHAR_LENGTH()Return number of characters in argumentCHARACTER_LENGTH()Syno...

Android Marshmallow introduced Runtime Permission model. Permissions are categorized into two categories i.e. Normal and Dangerous Permissions. where dangerous permissions are now granted by the user at run time. From sdk 23 Android requires runtime permissions for permissions on devices runni...

A set is a collection of items which can be anything. Whatever operator we need to work on these sets are in short the set operators and the operation is also known as set operation. Basic set operation includes Union, Intersection as well as addition, subtraction, etc. Group-Object Gr...

filter: none (default value) filter: initial (defaults to none); filter: inherit (defaults to parent value); filter: blur(px) filter: brightness(number | %) filter: contrast(number | %) filter: drop-shadow(horizontal-shadow-px vertical-shadow-px shadow-blur-px shadow- - spread color) filte...

Reading Text files and performing operations on them.

JavaScript, like any language, requires us to be judicious in the use of certain language features. Overuse of some features can decrease performance, while some techniques can be used to increase performance. Remember that premature optimization is the root of all evil. Write clear, correct c...

insert(document or array of documents) insertOne( 'document', { writeConcern: 'document' } ) insertMany( { [ document 1 , document 2, ... ] }, { writeConcern: document, ordered: boolean } ) find(query, projection) findOne(query, projection) update(query, update) updateOne( query,...

An operator is something that takes one or more values (or expressions, in programming jargon) and yields another value (so that the construction itself becomes an expression). Operators can be grouped according to the number of values they take. Operators 'operate' or act on one (unary opera...