Tutorial by Examples: g

INSERT INTO `my_table` (`field_1`, `field_2`) VALUES ('data_1', 'data_2'), ('data_1', 'data_3'), ('data_4', 'data_5'); This is an easy way to add several rows at once with one INSERT statement. This kind of 'batch' insert is much faster than inserting rows one by one. Typically...

Java 8 provides classes called IntSummaryStatistics, DoubleSummaryStatistics and LongSummaryStatistics which give a state object for collecting statistics such as count, min, max, sum, and average. Java SE 8 List<Integer> naturalNumbers = Arrays.asList(1, 2, 3, 4, 5, 6, 7, 8, 9, 10); IntSu...

MATLAB comes with many built-in scripts and functions which range from simple multiplication to image recognition toolboxes. In order to get information about a function you want to use type: help functionname in the command line. Lets take the help function as an example. Information on how to use...

There are 5 different types (MKMapType), MKMapView can display. iPhone OS 3 .standard Displays a street map that shows the position of all roads and some road names. Swift 2 mapView.mapType = .Standard Swift 3 mapView.mapType = .standard Objective-C _mapView.mapType = MKMapTypeStandard;...

Content has been moved back to the good 'ol JSF wiki page

Just like all programming language, Matlab is designed to read and write in a large variety of formats. The native library supports a large number of Text,Image,Video,Audio,Data formats with more formats included in each version update - check here to see the full list of supported file formats and ...

The double-negation !! is not a distinct JavaScript operator nor a special syntax but rather just a sequence of two negations. It is used to convert the value of any type to its appropriate true or false Boolean value depending on whether it is truthy or falsy. !!1 // true !!0 ...

Another neat feature using slices is slice assignment. Python allows you to assign new slices to replace old slices of a list in a single operation. This means that if you have a list, you can replace multiple members in a single assignment: lst = [1, 2, 3] lst[1:3] = [4, 5] print(lst) # Out: [1...

To check for a precise number of elements in the collection def f(ints: Seq[Int]): String = ints match { case Seq() => "The Seq is empty !" case Seq(first) => s"The seq has exactly one element : $first" case Seq(first, second) => s"The...

$fruit1 = ['apples', 'pears']; $fruit2 = ['bananas', 'oranges']; $all_of_fruits = array_merge($fruit1, $fruit2); // now value of $all_of_fruits is [0 => 'apples', 1 => 'pears', 2 => 'bananas', 3 => 'oranges'] Note that array_merge will change numeric indexes, but overwrite string...

x = (1, 2, 3) x[0] # 1 x[1] # 2 x[2] # 3 x[3] # IndexError: tuple index out of range Indexing with negative numbers will start from the last element as -1: x[-1] # 3 x[-2] # 2 x[-3] # 1 x[-4] # IndexError: tuple index out of range Indexing a range of elements print(x[:-1]) # (1,...

A context manager is an object that is notified when a context (a block of code) starts and ends. You commonly use one with the with statement. It takes care of the notifying. For example, file objects are context managers. When a context ends, the file object is closed automatically: open_file = ...

Many context managers return an object when entered. You can assign that object to a new name in the with statement. For example, using a database connection in a with statement could give you a cursor object: with database_connection as cursor: cursor.execute(sql_query) File objects retur...

The null coalescing operator makes it easy to ensure that a method that may return null will fall back to a default value. Without the null coalescing operator: string name = GetName(); if (name == null) name = "Unknown!"; With the null coalescing operator: string name = GetN...

enum MyEnum { One, Two, Three } foreach(MyEnum e in Enum.GetValues(typeof(MyEnum))) Console.WriteLine(e); This will print: One Two Three

The FlagsAttribute can be applied to an enum changing the behaviour of the ToString() to match the nature of the enum: [Flags] enum MyEnum { //None = 0, can be used but not combined in bitwise operations FlagA = 1, FlagB = 2, FlagC = 4, FlagD = 8 //you must use pow...

You can use a column's number (where the leftmost column is '1') to indicate which column to base the sort on, instead of describing the column by its name. Pro: If you think it's likely you might change column names later, doing so won't break this code. Con: This will generally reduce readabilit...

Requirements: Protractor requires the following dependencies to be installed prior to installation: Java JDK 1.7 or higher Node.js v4 or higher Installation: Download and install Node.js from this URL: https://nodejs.org/en/ To see if the Node.js installation is successfull, you can go an...

A context manager is any object that implements two magic methods __enter__() and __exit__() (although it can implement other methods as well): class AContextManager(): def __enter__(self): print("Entered") # optionally return an object return "A-ins...

To raise an exception use Kernel#raise passing the exception class and/or message: raise StandardError # raises a StandardError.new raise StandardError, "An error" # raises a StandardError.new("An error") You can also simply pass an error message. In this case, the message i...