Tutorial by Examples: u

INSERT INTO `table_name` (`index_field`, `other_field_1`, `other_field_2`) VALUES ('index_value', 'insert_value', 'other_value') ON DUPLICATE KEY UPDATE `other_field_1` = 'update_value', `other_field_2` = VALUES(`other_field_2`); This will INSERT into ta...

Merges two collections to create a distinct collection using the default equality comparer int[] numbers1 = { 1, 2, 3 }; int[] numbers2 = { 2, 3, 4, 5 }; var allElement = numbers1.Union(numbers2); // AllElement now contains 1,2,3,4,5 Live Demo on .NET Fiddle

The easiest way to create a multiline string is to just use multiple lines between quotation marks: address = "Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.&quot...

virtualenv is a tool to build isolated Python environments. This program creates a folder which contains all the necessary executables to use the packages that a Python project would need. Installing the virtualenv tool This is only required once. The virtualenv program may be available through yo...

Normally you would want to avoid using cursors as they can have negative impacts on performance. However in some special cases you may need to loop through your data record by record and perform some action. DECLARE @orderId AS INT -- here we are creating our cursor, as a local cursor and only a...

public class DatabaseHelper extends SQLiteOpenHelper { private static final String DATABASE_NAME = "Example.db"; private static final int DATABASE_VERSION = 3; // For all Primary Keys _id should be used as column name public static final String COLUMN_ID = "_id&q...

A struct can be used to bundle multiple return values: C++11 struct foo_return_type { int add; int sub; int mul; int div; }; foo_return_type foo(int a, int b) { return {a + b, a - b, a * b, a / b}; } auto calc = foo(5, 12); C++11 Instead of assignment to indi...

A module is a file containing Python definitions and statements. Function is a piece of code which execute some logic. >>> pow(2,3) #8 To check the built in function in python we can use dir(). If called without an argument, return the names in the current scope. Else, return an alph...

Just execute lsb_release -a. On Debian: $ lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux testing (stretch) Release: testing Codename: stretch On Ubuntu: $ lsb_release -a No LSB modules are available. Distributor ID: Ubun...

UIAlertView and UIActionSheet are Deprecated in iOS 8 and Later. So Apple introduced a new controller for AlertView and ActionSheet called UIAlertController , changing the preferredStyle, you can switch between AlertView and ActionSheet. There is no delegate method for it because all button events a...

NSDictionary *inventory = @{ @"Mercedes-Benz SLK250" : @(13), @"BMW M3 Coupe" : @(self.BMWM3CoupeInventory.count), @"Last Updated" : @"Jul 21, 2016", @"Next Update" : self.nextInventoryUpdateString };

NSDictionary *inventory = [NSDictionary dictionaryWithObjectsAndKeys: [NSNumber numberWithInt:13], @"Mercedes-Benz SLK250", [NSNumber numberWithInt:22], @"Mercedes-Benz E350", [NSNumber numberWithInt:19], @"BMW M3 Coupe", [NSNumber numberWithInt:16],...

You can open the VB editor in any of the Microsoft Office applications by pressing Alt+F11 or going to the Developer tab and clicking on the "Visual Basic" button. If you don't see the Developer tab in the Ribbon, check if this is enabled. By default the Developer tab is disabled. To enab...

To begin using WebDriver you will need to obtain the relevant Driver from the Selenium site: Selenium HQ Downloads. From here you need to download the driver relevant to the browser(s) and/or platform(s) you are trying to run WebDriver on, e.g. if you were testing in Chrome the Selenium site will di...

Rails provides several ways to organize your routes. Scope by URL: scope 'admin' do get 'dashboard', to: 'administration#dashboard' resources 'employees' end This generates the following routes get '/admin/dashboard', to: 'administration#dashboard' post '/admin/empl...

There are several ways to go about installing matplotlib, some of which will depend on the system you are using. If you are lucky, you will be able to use a package manager to easily install the matplotlib module and its dependencies. Windows On Windows machines you can try to use the pip package ...

XML is a syntax, which means a simple text editor is enough to get started. However, having an XML-specific editor that shows you when and where your document is not well-formed is almost indispensable for productivity. Such editors may also allow you to validate XML documents against an XML Schema...

To install the cordova command-line tool, follow these steps: Download and install Node.js. On installation you should be able to invoke node and npm on your command line. To see if Node is installed, open your CLI (command line interface). For Windows it's the Windows Command Prompt, for ...

On most GNU+Linux operating systems, PostgreSQL can easily be installed using the operating system package manager. Red Hat family Respositories can be found here: https://yum.postgresql.org/repopackages.php Download the repository to local machine with the command yum -y install https://downloa...

Ways to get Highcharts: Load directly from Highcharts CDN Download files from official website. Through npm; npm install highcharts Through bower; bower install highcharts To load the main library from vendor's CDN, simply add the following to your code: <script src="ht...