Tutorial by Examples: s

A subquery is a query within another SQL query. A subquery is also called inner query or inner select and the statement containing a subquery is called an outer query or outer select. Note Subqueries must be enclosed within parenthesis, An ORDER BY cannot be used in a subquery. The image type ...

Uname is the short name for unix name. Just type uname in console to get information about your operating system. uname [OPTION] If no OPTION is specified, uname assumes the -s option. -a or --all - Prints all information, omitting -p and -i if the information is unknown. Example: > unam...

Open a Command Prompt window and run the following commands: adb kill-server set ADB_TRACE=sockets adb nodaemon server 2>&1 | for /f "usebackq tokens=7*" %a in (`findstr /c:"): '"`) do @echo %a %b >> %USERPROFILE%\Desktop\adb_host_log.txt Now you can run your A...

To run the unit tests for a package, use the Pkg.test function. For a package named MyPackage, the command would be julia> Pkg.test("MyPackage") An expected output would be similar to INFO: Computing test dependencies for MyPackage... INFO: Installing BaseTestNext v0.2.2 INFO: Te...

Unit tests are declared in the test/runtests.jl file in a package. Typically, this file begins using MyModule using Base.Test The basic unit of testing is the @test macro. This macro is like an assertion of sorts. Any boolean expression can be tested in the @test macro: @test 1 + 1 == 2 @test...

0.5.0 In version v0.5, test sets are built into the standard library Base.Test module, and you don't have to do anything special (besides using Base.Test) to use them. 0.4.0 Test sets are not part of Julia v0.4's Base.Test library. Instead, you have to REQUIRE the BaseTestNext module, and add u...

Exceptions encountered while running a test will fail the test, and if the test is not in a test set, terminate the test engine. Usually, this is a good thing, because in most situations exceptions are not the desired result. But sometimes, one wants to test specifically that a certain exception is ...

What's the deal with the following? julia> @test 0.1 + 0.2 == 0.3 Test Failed Expression: 0.1 + 0.2 == 0.3 Evaluated: 0.30000000000000004 == 0.3 ERROR: There was an error during testing in record(::Base.Test.FallbackTestSet, ::Base.Test.Fail) at ./test.jl:397 in do_test(::Base.Test....

Powershell allows multiple assignment of variables and treats almost everything like an array or list. This means that instead of doing something like this: $input = "foo.bar.baz" $parts = $input.Split(".") $foo = $parts[0] $bar = $parts[1] $baz = $parts[2] You can simply...

php bin/magento setup:upgrade

You can see list with all environment variables with: Get-Childitem env:

$env:COMPUTERNAME

A PowerShell profile is used to load user defined variables and functions automatically. PowerShell profiles are not automatically created for users. To create a PowerShell profile C:>New-Item -ItemType File $profile. If you are in ISE you can use the built in editor C:>psEdit $profile An ...

#requires -version 4 After trying to run this script in lower version, you will see this error message .\script.ps1 : The script 'script.ps1' cannot be run because it contained a "#requires" statement at line 1 for Windows PowerShell version 5.0. The version required by the script do...

4.0 #requires -RunAsAdministrator After trying to run this script without admin privileges, you will see this error message .\script.ps1 : The script 'script.ps1' cannot be run because it contains a "#requires" statement for running as Administrator. The current Windows PowerShell s...

Node.js npm install bluebird Then: var Promise = require("bluebird"); Browsers There are many ways to use bluebird in browsers: Direct downloads Full build bluebird.js Full build minified bluebird.min.js Core build bluebird.core.js Core build minified bluebird.core.min.js...

Detailed instructions on getting jsf-2 set up or installed. Requirements: JDK 1.6+ Java Servlet 2.5 Installing jsf-2 on Tomcat Installing jsf-2 on Glassfish

An expression template is a compile-time optimization technique used mostly in scientific computing. It's main purpose is to avoid unnecessary temporaries and optimize loop calculations using a single pass (typically when performing operations on numerical aggregates). Expression templates were init...

The Java programming language (and its runtime) has undergone numerous changes since its release since its initial public release. These changes include: Changes in the Java programming language syntax and semantics Changes in the APIs provided by the Java standard class libraries. Changes in ...

To install Cucumber for use with Ruby simply use the command gem install cucumber Alternatively, if you are using bundler, you can add the following line to your Gemfile gem 'cucumber' And then run bundler bundle install [I think this belongs in its own topic, Installation. I created tha...