Tutorial by Examples: l

Temporary tables could be very useful to keep temporary data. Temporary tables option is available in MySQL version 3.23 and above. Temporary table will be automatically destroyed when the session ends or connection is closed. The user can also drop temporary table. Same temporary table name can b...

Drop Temporary Table is used to delete the temporary table which you are created in your current session. DROP TEMPORARY TABLE tempTable1 DROP TEMPORARY TABLE IF EXISTS tempTable1 Use IF EXISTS to prevent an error occurring for tables that may not exist

Frequently you may want to filter structures and other complex data types. Searching an array of structs for entries that contain a particular value is a very common task, and easily achieved in Swift using functional programming features. What's more, the code is extremely succinct. struct Painter...

Changing the edit text's appearance when it's selected, pressed and not selected can be customised easily by adding creating a new style for your edit text like so <style name="EditTextTheme" parent="Theme.AppCompat.Light.DarkActionBar"> <item name="colorContr...

New Pull Request Whenever you want to create a Pull Request (let's say this is either by a recent change. But, you can also do this with an older change too!), you can go ahead and let GitHub do a lot of the heavy lifting for you and hit the green Compare & Pull Request button (NOT TO BE CONFUS...

To easily select a buffer by filename, you can use: :b [part_of_filename]<Tab><Tab><Tab>...<Enter> The first Tab will expand the word to a full filename, and subsequent Tab presses will cycle through the list of possible matches. When multiple matches are available, you ...

<C-^> will switch to and from the previous edited file. On most keyboards <C-^> is CTRL-6. 3<C-^> will switch to buffer number 3. This is very quick, but only if you know the buffer number. You can see the buffer numbers from :ls or from a plugin such as MiniBufExplorer.

THREE.CylinderGeometry build cylinders. Cylinder Continuing from the previous example, the code to create the box could be replaced with the below. //Makes a new cylinder with // - a circle of radius 5 on top (1st parameter) // - a circle of radius 5 on the bottom (2nd parameter) // - a height...

extension String { func matchesPattern(pattern: String) -> Bool { do { let regex = try NSRegularExpression(pattern: pattern, options: NSRegularExpressionOptions(rawValue: 0)) let range: NSRange = NSMakeRange(...

super keyword performs important role in three places Constructor Level Method Level Variable Level Constructor Level super keyword is used to call parent class constructor. This constructor can be default constructor or parameterized constructor. Default constructor : super(); Pa...

Label Tag Helper can be used to render label for a model property. It replaces method Html.LabelFor in previous versions of MVC. Let's say you have a model: public class FormViewModel { public string Name { get; set; } } In the view you can use label HTML element and asp-for tag helper: ...

Often one want to show the result of a command executed by root to other users. The tee command allows easily to write a file with user perms from a command running as root: su -c ifconfig | tee ~/results-of-ifconfig.txt Only ifconfig runs as root.

For null check in method Object nullableObject = methodReturnObject(); if (Objects.isNull(nullableObject)) { return; } For not null check in method Object nullableObject = methodReturnObject(); if (Objects.nonNull(nullableObject)) { return; }

In the old fashion way for collection null check List<Object> someObjects = methodGetList(); for (Object obj : someObjects) { if (obj == null) { continue; } doSomething(obj); } With the Objects.nonNull method and Java8 Stream API, we can do the above in this way: ...

Consider this example: public class ThreadTest implements Runnable { private boolean stop = false; public void run() { long counter = 0; while (!stop) { counter = counter + 1; } System.out.println("Counted " + counter);...

local t1, t2, t3, t4 = {}, {}, {}, {} -- Create 4 tables local maintab = {t1, t2} -- Regular table, strong references to t1 and t2 local weaktab = setmetatable({t1, t2, t3, t4}, {__mode = 'v'}) -- table with weak references. t1, t2, t3, t4 = nil, nil, nil, nil -- No more "strong" refe...

Suppose you have a long list of elements and you are only interested in every other element of the list. Perhaps you only want to examine the first or last elements, or a specific range of entries in your list. Python has strong indexing built-in capabilities. Here are some examples of how to achie...

What are local and global scope? All Python variabes which are accessible at some point in code are either in local scope or in global scope. The explanation is that local scope includes all variables defined in the current function and global scope includes variabled defined outside of the curren...

AUTOCOMMIT MySQL automatically commits statements that are not part of a transaction. The results of any UPDATE,DELETE or INSERT statement not preceded with a BEGIN or START TRANSACTION will immediately be visible to all connections. The AUTOCOMMIT variable is set true by default. This can be chan...

Detailed instructions on getting shopify set up or installed.