Tutorial by Examples: l

Current updates the branch on the remote repository that shares a name with the current working branch. git config push.default current Simple pushes to the upstream branch, but will not work if the upstream branch is called something else. git config push.default simple Upstream pushes to t...

This is the basic way to insert data from another table with the SELECT statement. INSERT INTO `tableA` (`field_one`, `field_two`) SELECT `tableB`.`field_one`, `tableB`.`field_two` FROM `tableB` WHERE `tableB`.clmn <> 'someValue' ORDER BY `tableB`.`sorting_clmn`; You can...

Drop Table is used to delete the table from database. Creating Table: Creating a table named tbl and then deleting the created table CREATE TABLE tbl( id INT NOT NULL AUTO_INCREMENT, title VARCHAR(100) NOT NULL, author VARCHAR(40) NOT NULL, submission_date DATE, PRIMARY K...

Each group ends with a line separator. If each item in your menu has its own group you will achieve the desired graphical output. It will work only if your different groups have different android:id. Also, in menu.xml remember to mention android:checkable="true" for single item and android...

When using the interactive interpreter, you might want to reload a module. This can be useful if you're editing a module and want to import the newest version, or if you've monkey-patched an element of an existing module and want to revert your changes. Note that you can't just import the module ag...

To hide the blinking caret, you need to override caretRectForPosition of a UITextField and return CGRectZero. Swift 2.3 < public override func caretRectForPosition(position: UITextPosition) -> CGRect { return CGRectZero } Swift 3 override func caretRect(for position: UITextPositio...

We can change the style of the placeholder by setting attributedPlaceholder (a NSAttributedString). var placeholderAttributes = [String: AnyObject]() placeholderAttributes[NSForegroundColorAttributeName] = color placeholderAttributes[NSFontAttributeName] = font if let placeholder = textField.p...

If you need to clean the build: ndk-build clean

Reflection is useful but fragile. Consider this: let mi = typeof<System.String>.GetMethod "StartsWith" The problems with this kind of code are: The code doesn't work because there are several overloads of String.StartsWith Even if there wouldn't be any overloads right now la...

Starting a File Chooser Activity public void showFileChooser() { Intent intent = new Intent(Intent.ACTION_GET_CONTENT); // Update with mime types intent.setType("*/*"); // Update with additional mime types here using a String[]. intent.putExtra(Intent.EXTRA_M...

Detailed instructions on getting docusignapi set up or installed.

Sometimes you need to determine the target of a symlink. os.readlink will do this: print(os.readlink(path_to_symlink))

os.chmod(path, mode) where mode is the desired permission, in octal.

A lambda closure is created when a lambda expression references the variables of an enclosing scope (global or local). The rules for doing this are the same as those for inline methods and anonymous classes. Local variables from an enclosing scope that are used within a lambda have to be final. Wit...

To improve performance one might want to add indexes to columns ALTER TABLE TABLE_NAME ADD INDEX `index_name` (`column_name`) altering to add composite (multiple column) indexes ALTER TABLE TABLE_NAME ADD INDEX `index_name` (`col1`,`col2`)

Middleware (also called pre and post hooks) are functions which are passed control during execution of asynchronous functions. Middleware is specified on the schema level and is useful for writing plugins. Mongoose 4.0 has 2 types of middleware: document middleware and query middleware. Document mid...

SELECT is used to retrieve rows of data from a table. You can specify which columns will be retrieved: SELECT Name, Position FROM Employees; Or just use * to get all columns: SELECT * FROM Employees;

This query will return all columns from the table sales where the values in the column amount is greater than 10 and the data in the region column in "US". SELECT * FROM sales WHERE amount > 10 AND region = "US" You can use regular expressions to select the columns you wan...

A compound literal is an unnamed object which is created in the scope where is defined. The concept was first introduced in C99 standard. An example for compound literal is Examples from C standard, C11-§6.5.2.5/9: int *p = (int [2]){ 2, 4 }; p is initialized to the address of the first ele...

Download and install, either via Homebrew, or from website. For Brew, brew install git-lfs git lfs install Often you will also need to do some setup on the service that hosts your remote to allow it to work with lfs. This will be different for each host, but will likely just be checking a box sa...