Tutorial by Examples: nd

By default stored procedures and functions or not generated by mysqldump, you will need to add the parameter --routines (or -R): mysqldump -u username -p -R db_name > dump.sql When using --routines the creation and change time stamps are not maintained, instead you should dump and reload the ...

#include <stddef.h> /* for offsetof() */ #include <stdlib.h> /* for exit() */ #include <stdio.h> /* for perror() */ #include <string.h> /* for strcmp() */ #include <unistd.h> /* for close(), unlink() */ #include <fcntl.h> /* for open() */ #incl...

import java.time.LocalTime; import java.time.ZoneId; import java.time.temporal.ChronoUnit; public class Test { public static void main(String[] args) { ZoneId zone1 = ZoneId.of("Europe/Berlin"); ZoneId zone2 = ZoneId.of("Brazil/East"); ...

Always encode from unicode to bytes. In this direction, you get to choose the encoding. >>> u'🐍'.encode('utf-8') '\xf0\x9f\x90\x8d' The other way is to decode from bytes to unicode. In this direction, you have to know what the encoding is. >>> b'\xf0\x9f\x90\x8d'.decode('...

This set of example show how to execute commands stored in strings or script files, without the need of the interactive prompt. This is especially useful to when a shell script needs to interact with a database. Execute command from a string $ mysql -uroot -proot test -e'select * from people' +...

Suppose you have a DataFrame of numerical values, for example: df = pd.DataFrame(np.random.randn(1000, 3), columns=['a', 'b', 'c']) Then >>> df.corr() a b c a 1.000000 0.018602 0.038098 b 0.018602 1.000000 -0.014245 c 0.038098 -0.014245 1.000000...

Emacs' documentation uses a consistent notation for all key bindings, which is explained here: Key chords A "key chord" is obtained by pressing two or more keys simultaneously. Key chords are denoted by separating all keys by dashes (-). They usually involve modifier keys, which are put ...

Create example table Employee: CREATE TABLE Employee ( Id INT, EmpName VARCHAR(25), EmpGender VARCHAR(6), EmpDeptId INT ) Creates stored procedure that checks whether the values passed in stored procedure are not null or non empty and perform insert operation in Employee ta...

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...

php bin/magento setup:upgrade

IIS / .NET version Requirements: See here SignalR 2+ Install the NuGet package Microsoft.AspNet.SignalR (this is the whole SignalR solution) and it will ask you to install any dependencies for other packages. Accept the terms and install them as well. Now that we've got the .dlls and clie...

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

In order to begin using WebRTC you need to get camera and microphone permission.For that you need following things: adapter.js, you can get it from here A html webpage with a video tag and little bit of js code The adapter.js is a JavaScript shim for WebRTC, maintained by Google with help fro...

If the web page a contains phone number you can make a call using your phone's dialer. This code checks for the url which starts with tel: then make an intent to open dialer and you can make a call to the clicked phone number: public boolean shouldOverrideUrlLoading(WebView view, String url) { ...

The NSTimeInterval value of this property indicates the seconds from which the date picker in countdown-timer mode counts down. If the mode of the date picker is not CountDownTimer, this value is ignored. Maximum value is 86,399 seconds (23:59) let datePicker = UIDatePicker(frame: CGRect(x: 0, y: 0...

This code uses the top level Application object to minimize the main Excel window. Sub MinimizeExcel() Application.WindowState = xlMinimized End Sub

Capabilities of the Canvas Canvas lets you programmatically draw onto your webpage: Images, Texts, Lines and Curves. Canvas drawings can be extensively styled: stroke width, stroke color, shape fill color, opacity, shadowing, linear gradients and radial gradients, font face, font ...

Private Sub Get_Last_Used_Row_Index() Dim wS As Worksheet Set wS = ThisWorkbook.Sheets("Sheet1") Debug.Print LastCol_1(wS) Debug.Print LastCol_0(wS) End Sub You can choose between 2 options, regarding if you want to know if there is no data in the worksheet :...

appendToFile: Append single src, or multiple srcs from local file system to the destination file system. Also reads input from stdin and appends to destination file system. Keep the as - hdfs dfs -appendToFile [localfile1 localfile2 ..] [/HDFS/FILE/PATH..] cat: Copies source paths to stdout. ...

The command pattern encapsulates parameters to a method, current object state, and which method to call. It is useful to compartmentalize everything needed to call a method at a later time. It can be used to issue a "command" and decide later which piece of code to use to execute the comma...