Tutorial by Examples

Examples of what happens when NULL and 'bad-value' are stored into nullable and not nullable columns. Also shows usage of casting to numeric via +0. CREATE TABLE enum ( e ENUM('yes', 'no') NOT NULL, enull ENUM('x', 'y', 'z') NULL ); INSERT INTO enum (e, enull) VA...

The time for Scheduler Tasks are measured in Ticks. Under normal conditions, there are 20 ticks per second. Tasks scheduled with .scheduleSyncRepeatingTask will be run on the Main Thread Bukkit.getScheduler().scheduleSyncRepeatingTask(plugin, new Runnable() { @Override public void run(...

One can initialize a Julia array by hand, using the square-brackets syntax: julia> x = [1, 2, 3] 3-element Array{Int64,1}: 1 2 3 The first line after the command shows the size of the array you created. It also shows the type of its elements and its dimensionality (int this case Int64 ...

In Julia, Arrays have types parametrized by two variables: a type T and a dimensionality D (Array{T, D}). For a 1-dimensional array of integers, the type is: julia> x = [1, 2, 3]; julia> typeof(x) Array{Int64, 1} If the array is a 2-dimensional matrix, D equals to 2: julia> x = [1 2 ...

The Java SE Development Kit (JDK) 7 Update 10 (or later) or JDK 8 is required to install NetBeans IDE. You can download the latest update of JDK 7 and JDK 8 at http://www.oracle.com/technetwork/java/javase/downloads. The PHP and C/C++ NetBeans bundles only require the Java Runtime Environment (JRE)...

You might want to import and export your database for bacukups for example. Dont forget about the permissions. public void exportDatabase(){ try { File sd = Environment.getExternalStorageDirectory(); File data = Environment.getDataDirectory(); String currentD...

Here is an example of inserting large chunks of data at once. All the data you want to insert is gathered inside of a ContentValues array. @Override public int bulkInsert(Uri uri, ContentValues[] values) { int count = 0; String table = null; int uriType = IChatContract.MessageColu...

It may become necessary to traverse the elements of a series or the rows of a dataframe in a way that the next element or next row is dependent on the previously selected element or row. This is called path dependency. Consider the following time series s with irregular frequency. #starting pytho...

If you have multiple libraries in the same solution, you can add local (project) references between them: { "dependencies": { "NETStandard.Library": "1.6.0", "MyOtherLibrary": { "target": "project" } }...

Detailed instructions on getting theano set up or installed.

Spring Data is a project consisting of a number of subprojects. The most common ones are Spring Data JPA, Spring Data MongoDB, Spring Data Elasticsearch, Spring Data Neo4J, Spring Data Cassandra and Spring Data Redis. Unless you are developing your own subproject based upon Spring Data, it is highl...

function test($x) { return $x; } $server = new SoapServer(null, array('uri' => "http://test-uri/")); $server->addFunction("test"); $server->handle();

:qa!

The summation 1/1 + 1/2 + 1/3 + 1/4 + ... + 1/n is equal to the nth harmonic number, denoted Hn. The nth harmonic number obeys the inequalities ln (n + 1) ≤ Hn ≤ (ln n) + 1 and therefore Hn = Θ(log n). The harmonic numbers often arise in the analysis of algorithms, with randomized quicks...

The summation 1/1 + 1/4 + 1/9 + 1/16 + ... out to infinity converges to π2 / 6, and therefore any summation of the form 1/1 + 1/4 + 1/9 + 1/16 + ... + 1/n2 is Θ(1).

ABCD1penred5002penblue-503penred04pencilblue175pencilgreen-1.5 To sort by column D with "order by": =QUERY("A1:D6","select * order by D desc",1)

ABCD1penred5002penblue-503penred04pencilblue175pencilgreen-1.5 To only return "pencil" data: =QUERY("A1:D6","select * where B='pencil' ",1) To only return rows that contain "pen" (all rows): =QUERY("A1:D6","select * where B contains 'pen' ...

Create an empty directory somewhere ... mkdir HelloWorld cd HelloWorld Then use the built in scaffolding technology to create a Hello World sample dotnet new console -o This command creates two files: HelloWorld.csproj describes the project dependencies, settings, and Target Framework ...

You can add hours, minutes, seconds and nanoseconds: LocalTime time = LocalTime.now(); LocalTime addHours = time.plusHours(5); // Add 5 hours LocaLTime addMinutes = time.plusMinutes(15) // Add 15 minutes LocalTime addSeconds = time.plusSeconds(30) // Add 30 seconds LocalTime addNanoseconds = ti...

This basic example shows how an application can instantiate a classloader and use it to dynamically load a class. URL[] urls = new URL[] {new URL("file:/home/me/extras.jar")}; Classloader loader = new URLClassLoader(urls); Class<?> myObjectClass = loader.findClass("com.exampl...