Tutorial by Examples: n

An Explain infront of a select query shows you how the query will be executed. This way you to see if the query uses an index or if you could optimize your query by adding an index. Example query: explain select * from user join data on user.test = data.fk_user; Example result: id select_type...

The type alias keyword combination gives a new name for a type, but the type keyword in isolation declares a new type. Let's examine one of the most fundamental of these types: Maybe type Maybe a = Just a | Nothing The first thing to note is that the Maybe type is declared with a type ...

There are several sort functions for arrays in php: sort() Sort an array in ascending order by value. $fruits = ['Zitrone', 'Orange', 'Banane', 'Apfel']; sort($fruits); print_r($fruits); results in Array ( [0] => Apfel [1] => Banane [2] => Orange [3] => Zitr...

Fired when component or directive properties have been initialized. (Before those of the child directives) import { Component, OnInit } from '@angular/core'; @Component({ selector: 'so-oninit-component', templateUrl: 'oninit-component.html', styleUrls: ['oninit-component.'] }) ...

Fired when the component or directive instance is destroyed. import { Component, OnDestroy } from '@angular/core'; @Component({ selector: 'so-ondestroy-component', templateUrl: 'ondestroy-component.html', styleUrls: ['ondestroy-component.'] }) class OnDestroyComponent implements...

Fired when one or more of the component or directive properties have been changed. import { Component, OnChanges, Input } from '@angular/core'; @Component({ selector: 'so-onchanges-component', templateUrl: 'onchanges-component.html', styleUrls: ['onchanges-component.'] }) class ...

Fire after the initialization of the content of the component or directive has finished. (Right after OnInit) import { Component, AfterContentInit } from '@angular/core'; @Component({ selector: 'so-aftercontentinit-component', templateUrl: 'aftercontentinit-component.html', styl...

Fire after the view has been fully initialized. (Only available for components) import { Component, AfterContentChecked } from '@angular/core'; @Component({ selector: 'so-aftercontentchecked-component', templateUrl: 'aftercontentchecked-component.html', styleUrls: ['aftercontentc...

Fires after initializing both the component view and any of its child views. This is a useful lifecycle hook for plugins outside of the Angular 2 ecosystem. For example, you could use this method to initialize a jQuery date picker based on the markup that Angular 2 has rendered. import { Component,...

CREATE TRIGGER BooksDeleteTrigger ON MyBooksDB.Books AFTER DELETE AS INSERT INTO BooksRecycleBin SELECT * FROM deleted; GO

You can start some slow process in parallel and then collect the results when they are done: Public Sub Main() Dim results = Task.WhenAll(SlowCalculation, AnotherSlowCalculation).Result For Each result In results Console.WriteLine(result) Next End Sub Async Functio...

You can create an IEnumerable of Task by passing AddressOf AsyncMethod to the LINQ Select method and then start and wait all the results with Task.WhenAll If your method has parameters matching the previous LINQ chain call, they will be automatically mapped. Public Sub Main() Dim tasks = Enum...

Import the CoreLocation module in your classes that use CoreLocation functionality. //Swift import CoreLocation //Objective-C #import <CoreLocation/CoreLocation.h>

Check the app's authorization status with: //Swift let status: CLAuthorizationStatus = CLLocationManager.authorizationStatus() //Objective-C CLAuthorizationStatus status = [CLLocationManager authorizationStatus]; Test the status against the follow constants: //Swift switch status { case ...

(in-package #:asdf-user) (defsystem #:foo :components ((:file "foo")) :in-order-to ((asdf:test-op (asdf:load-op :foo))) :perform (asdf:test-op (o c) (uiop:symbol-call :foo-tests 'run-tests))) (defsystem #:foo-tests :name "foo-test" :compo...

ASDF provides the package ASDF-USER for developers to define their packages in.

The fmt.Stringer interface requires a single method, String() string to be satisfied. The string method defines the "native" string format for that value, and is the default representation if the value is provided to any of the fmt packages formatting or printing routines. package main ...

Notepad++ can be installed: From the installer downloaded from the project's web site From Ninite, which would download and automatically install the latest version available: https://ninite.com/notepadplusplus/ Built from sources who are available in the GitHub Repo of this project.

Background ============ WebStorm is lightweight yet powerful Integrated Development Environment (IDE) perfectly equipped for complex client-side development and server-side development, it is cross-platform and works on Windows, Mac OS X, and Linux. WebStorm features advanced support for JavaScri...

Example: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title></title> </head> <body> <textarea id="content"></textarea> <input type="button" id="copy...