Tutorial by Topics

{{ my_date_time|my_custom_filter }} {{ my_date_time|my_custom_filter(args) }} ParameterDetailsvalueThe value passed in by Jinja, to be filteredargsExtra arguments to be passed into the filter function

The TRUNCATE statement deletes all data from a table. This is similar to DELETE with no filter, but, depending on the database software, has certain restrictions and optimizations. TRUNCATE TABLE table_name; TRUNCATE is a DDL (Data Definition Language) command, and as such there are si...

The div element in HTML is a container element that encapsulates other elements and can be used to group and separate parts of a webpage. A div by itself does not inherently represent anything but is a powerful tool in web design. This topic covers the purpose and applications of the div element. ...

MERGE (often also called UPSERT for "update or insert") allows to insert new rows or, if a row already exists, to update the existing row. The point is to perform the whole set of operations atomically (to guarantee that the data remain consistent), and to prevent communication overhead fo...

EOMONTH (start_date [, month_to_add ] ) as per https://msdn.microsoft.com/en-us/library/ms187819.aspx, DateTimes are only precise to 3ms. Rounding of datetime Fractional Second Precision datetime values are rounded to increments of .000, .003, or .007 seconds, as shown in the following ta...

display: none | inline | block | list-item | inline-list-item | inline-block | inline-table | table | table-cell | table-column | table-column-group | table-footer-group | table-header-group | table-row | table-row-group | flex | inline-flex | grid | inline-grid | run-in | ruby | ruby-base | ruby-...

ParameterDescriptionStableYesIn placeYesBest case complexityO(n)Average case complexityO(n^2)Worst case complexityO(n^2)Space complexityO(1)

Middleware is a software component that will determine how to process the request and decide whether to pass it to the next component in the application pipeline. Each middleware has a vary specific role and actions to preform on the request.

An Activity represents a single screen with a user interface(UI). An Android App may have more than one Activity, for example, An email App can have one activity to list all the emails, another activity to show email contents, yet another activity to compose new email. All the activities in an App w...

include Comparable implement the space-ship operator (<=>) ParameterDetailsotherThe instance to be compared to self x <=> y should return a negative number if x < y, zero if x == y and a positive number if x > y.

DELETE [ LOW_PRIORITY ] [ QUICK ] [ IGNORE ] FROM table [WHERE conditions] [ORDER BY expression [ ASC | DESC ]] [LIMIT number_rows]; /// Syntax for delete row(s) from single table ParameterDetailsLOW_PRIORITYIf LOW_PRIORITY is provided, the delete will be delayed until there are no proc...

CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition; ///Simple create view syntax CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = { user | CURRENT_USER }] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS sel...