Tutorial by Examples: and

php bin/magento setup:upgrade => Setup Upgrade php bin/magento setup:di:compile => Setup: Compile php bin/magento indexer:reindex => Reindex php bin/magento cache:flush => Clear Cache php bin/magento deploy:mode:set...

This UNION ALL combines data from multiple tables and serve as a table name alias to use for your queries: SELECT YEAR(date_time_column), MONTH(date_time_column), MIN(DATE(date_time_column)), MAX(DATE(date_time_column)), COUNT(DISTINCT (ip)), COUNT(ip), (COUNT(ip) / COUNT(DISTINCT (ip))) AS Ratio ...

Dockerization of ASP.NET Application requires a Dockerfile for configuration and running it as a docker container. FROM microsoft/dotnet:latest RUN apt-get update && apt-get install sqlite3 libsqlite3-dev COPY . /app WORKDIR /app RUN ["dotnet", "restore"] ...

First of all, the problem of handling spaces in arguments is NOT actually a Java problem. Rather it is a problem that needs to be handled by the command shell that you are using when you run a Java program. As an example, let us suppose that we have the following simple program that prints the siz...

Install openfire or any chat server in your system or on server. For more details click here. Create android project and add these libraries in gradle: compile 'org.igniterealtime.smack:smack-android:4.2.0' compile 'org.igniterealtime.smack:smack-tcp:4.2.0' compile 'org.igniterealtime.smack:smac...

The default way to find installed packages with CMake is the use the find_package function in conjunction with a Find<package>.cmake file. The purpose of the file is to define the search rules for the package and set different variables, such as <package>_FOUND, <package>_INCLUDE_D...

On Unix-like operating systems, it is possible to use the pkg-config program to find and configure packages that provides a <package>.pc file. In order to use pkg-config, it is necessary to call include(FindPkgConfig) in a CMakeLists.txt. Then, there are 2 possible functions: pkg_search_mo...

This simple function will execute the specified Select SQL command and return the result as data set. Public Function ReadFromDatabase(ByVal DBConnectionString As String, ByVal SQL As String) As DataTable Dim dtReturn As New DataTable Try 'Open the connection using the connection...

Q. Why we need compilation? Ans. We need compilation for achieving higher level of efficiency of our Angular applications. Take a look at the following example, // ... compile: function (el, scope) { var dirs = this._getElDirectives(el); var dir; var scopeCreated; dirs.forEach(functi...

Sometimes a complex IF condition is needed. Let's take and example, Assuming we have the following raw data: ItemIDItem NameItem Status1Item 1Tentative1Item 1Pending1Item 1Approved The Goal is: Let's assume our business user ask to see which items are not approved and which are approved. Tentati...

$perl -d:MOD script.pl runs the program under the control of a debugging, profiling, or tracing module installed as Devel::MOD. For example, -d:NYTProf executes the program using the Devel::NYTProf profiler. See all available Devel modules here Recommended modules: Devel::NYTProf -- Powerful ...

socket_last_error can be used to get the error ID of the last error from the sockets extension. socket_strerror can be used to convert the ID to human-readable strings. function onSocketFailure(string $message, $socket = null) { if(is_resource($socket)) { $message .= ": " ....

Import Element Tree module import xml.etree.ElementTree as ET Element() function is used to create XML elements p=ET.Element('parent') SubElement() function used to create sub-elements to a give element c = ET.SubElement(p, 'child1') dump() function is used to dump xml elements. ET.dump...

Abstract base classes (ABCs) enforce what derived classes implement particular methods from the base class. To understand how this works and why we should use it, let's take a look at an example that Van Rossum would enjoy. Let's say we have a Base class "MontyPython" with two methods (jo...

You can set a character set both per table, as well as per individual field using the CHARACTER SET and CHARSET statements: CREATE TABLE Address ( `AddressID` INTEGER NOT NULL PRIMARY KEY, `Street` VARCHAR(80) CHARACTER SET ASCII, `City` VARCHAR(80), `Country` ...

Requirements MongoDB server running on port usually 27017. (type mongod on command prompt to run mongodb server) Php installed as either cgi or fpm with MongoDB extension installed(MongoDB extension is not bundled with default php) Composer library(mongodb/mongodb).(In the project roo...

The .cmdtree command allows to open a .txt file with predefined commands which you can simply double click to execute. How to create command file Create the file using this template windbg ANSI Command Tree 1.0 title {"Window title"} body {"Group Heading"} {"Name...

WPF apps targeting .NET Framework 4.6.2 and later With WPF apps targeting .NET Framework 4.6.2 (and later), the soft keyboard is automatically invoked and dismissed without any additional steps required. WPF apps targeting .NET Framework 4.6.1 and earlier WPF is not primarily touch enabled, whi...

There are many classes available in CIM and WMI which are separated into multiple namespaces. The most common (and default) namespace in Windows is root/cimv2. To find the righ class, it can useful to list all or search. List available classes You can list all available classes in the default name...

From java tutorial The dictionary definition of polymorphism refers to a principle in biology in which an organism or species can have many different forms or stages. This principle can also be applied to object-oriented programming and languages like the Java language. Subclasses of a class can ...