Tutorial by Examples: a

Any size of INT may be used for AUTO_INCREMENT. UNSIGNED is always appropriate. Keep in mind that certain operations "burn" AUTO_INCREMENT ids. This could lead to an unexpected gap. Examples: INSERT IGNORE and REPLACE. They may preallocate an id before realizing that it won't be need...

String concatenation is when you combine two or more strings into a single string variable. String concatenation is performed with the & symbol. Dim one As String = "Hello " Dim two As String = "there" Dim result As String = one & two Non-string values will be conv...

7.0 OrElse Sub Main() Dim elements As List(Of Integer) = Nothing Dim average As Double = AverageElementsOrElse(elements) Console.WriteLine(average) ' Writes 0 to Console Try 'Throws ArgumentNullException average = AverageElementsOr(elements) Catch ex ...

using System; using System.Threading; using System.Threading.Tasks; class Program { static void Main( string[] args ) { object sync = new object(); int sum = 0; Parallel.For( 1, 1000, ( i ) => { lock( sync ) sum = sum + i; // lock is necessa...

Using the Library Database, we try to find the last book added to the database for each author. For this simple example we assume an always incrementing Id for each record added. SELECT MostRecentBook.Name, MostRecentBook.Title FROM ( SELECT Authors.Name, Books.Title, ...

As of Qt 5.1 and later you can use QQmlApplicationEngine instead of QQuickView to load and render a QML script. With QQmlApplicationEngine you do need to use a QML Window type as your root element. You can obtain the root context from the engine where you can then add global properties to the cont...

Not all objects can be converted to a JSON string. When an object has cyclic self-references, the conversion will fail. This is typically the case for hierarchical data structures where parent and child both reference each other: const world = { name: 'World', regions: [] }; world.region...

Creating a ServiceHost programmatically (without config file) in its most basic form: namespace ConsoleHost { class ConsoleHost { ServiceHost mHost; public Console() { mHost = new ServiceHost(typeof(Example), new Uri("net.tcp://localhost:9000/Example")); ...

class ClassWithAReallyLongName { public: class Iterator { /* ... */ }; Iterator end(); }; Defining the member end with a trailing return type: auto ClassWithAReallyLongName::end() -> Iterator { return Iterator(); } Defining the member end without a trailing return type: Clas...

>>> df ID Year Jan_salary Feb_salary Mar_salary 0 1 2016 4500 4200 4700 1 2 2016 3800 3600 4400 2 3 2016 5500 5200 5300 >>> melted_df = pd.melt(df,id_vars=['ID','Year'], v...

abstract class Machine { constructor(public manufacturer: string) { } // An abstract class can define methods of it's own, or... summary(): string { return `${this.manufacturer} makes this machine.`; } // Require inheriting classes to implement methods ...

Example for updating all documents where name is equal to "John": $filter = ['name' => 'John']; $document = ['name' => 'Mike']; $bulk = new \MongoDB\Driver\BulkWrite; $bulk->update( $filter, $document, ['multi' => true] ); $result = $manager->executeBu...

Example for deleting all documents where name is equal to "Peter": $bulk = new \MongoDB\Driver\BulkWrite; $filter = ['name' => 'Peter']; $bulk->delete($filter); $result = $manager->executeBulkWrite('database_name.collection_name', $bulk);

Navigation Drawers are used to navigate to top-level destinations in an app. Make sure that you have added design support library in your build.gradle file under dependencies: dependencies { // ... compile 'com.android.support:design:25.3.1' } Next, add the DrawerLayout and Navigati...

Comments are used to explain code when the basic code itself isn't clear. Python ignores comments, and so will not execute code in there, or raise syntax errors for plain english sentences. Single-line comments begin with the hash character (#) and are terminated by the end of line. Single lin...

auto can also cause problems where expression templates come into play: auto mult(int c) { return c * std::valarray<int>{1}; } auto v = mult(3); std::cout << v[0]; // some value that could be, but almost certainly is not, 3. The reason is that operator* on valarray gives yo...

Using range-base loops, you can loop over a sub-part of a given container or other range by generating a proxy object that qualifies for range-based for loops. template<class Iterator, class Sentinel=Iterator> struct range_t { Iterator b; Sentinel e; Iterator begin() const { return ...

Given a local directory with the following contents: └── dir1 ├── subdir1 └── subdir2 We want to create the same subdir1, subdir2 under a new directory dir2, which does not exist yet. import os os.makedirs("./dir2/subdir1") os.makedirs("./dir2/subdir2") R...

select * from sys.dm_resource_governor_workload_groups select * from sys.dm_resource_governor_resource_pools

First create a resource pool besides the default one CREATE RESOURCE POOL [PoolAdhoc] WITH(min_cpu_percent=0, max_cpu_percent=50, min_memory_percent=0, max_memory_percent=50) GO Create the worload group for the pool CREATE WORKLOAD GROUP [AdhocMedium] WITH(importa...