Tutorial by Examples: t

MySQL allows to specify from which table the matching rows must be deleted -- remove only the employees DELETE e FROM Employees e JOIN Department d ON e.department_id = d.department_id WHERE d.name = 'Sales' -- remove employees and department DELETE e, d FROM Emp...

Detailed instructions on getting pyspark set up or installed.

var record = nlapiCreateRecord('task'); record.setFieldValue('title', taskTitle); var id = nlapiSubmitRecord(record, true);

"MySQL Cluster" disambiguation... NDB Cluster -- A specialized, mostly in-memory, engine. Not widely used. Galera Cluster aka Percona XtraDB Cluster aka PXC aka MariaDB with Galera. -- A very good High Availability solution for MySQL; it goes beyond Replication. See individual page...

Limit root (and any other SUPER-privileged user) to GRANT ... TO root@localhost ... That prevents access from other servers. You should hand out SUPER to very few people, and they should be aware of their responsibility. The application should not have SUPER. Limit application logins to the one...

The "host" can be either a host name or an IP address. Also, it can involve wild cards. GRANT SELECT ON db.* TO sam@'my.domain.com' IDENTIFIED BY 'foo'; Examples: Note: these usually need to be quoted localhost -- the same machine as mysqld 'my.domain.com' -- a specific domain; th...

Draw stars with flexible styling (size, colors, number-of-points). // Usage: drawStar(75,75,5,50,25,'mediumseagreen','gray',9); drawStar(150,200,8,50,25,'skyblue','gray',3); drawStar(225,75,16,50,20,'coral','transparent',0); drawStar(300,200,16,50,40,'gold','gray',3); // centerX, centerY: ...

// Usage: drawLineWithArrows(50,50,150,50,5,8,true,true); // x0,y0: the line's starting point // x1,y1: the line's ending point // width: the distance the arrowhead perpendicularly extends away from the line // height: the distance the arrowhead extends backward from the endpoint // arrow...

// Usage: var p0={x:50,y:100}; var p1={x:100,y:0}; var p2={x:200,y:200}; var p3={x:300,y:100}; cubicCurveArrowHeads(p0, p1, p2, p3, 15, true, true); quadraticCurveArrowHeads(p0, p1, p2, 15, true, true); // or use defaults true for both ends with arrow heads cubicCurveArrowHeads(p0, p...

// Usage: var arc={ cx:150, cy:150, innerRadius:75, outerRadius:100, startAngle:-Math.PI/4, endAngle:Math.PI } drawArc(arc,'skyblue','gray',4); function drawArc(a,fill,stroke,strokewidth){ ctx.beginPath(); ctx.arc(a.cx,a.cy,a.innerRadius,a.startAngle,a.endAngle); ...

When Canvas draws a line it automatically adds anti-aliasing to visually heal "jaggedness". The result is a line that is less jagged but more blurry. This function draws a line between 2 points without anti-aliasing using Bresenham's_line algorithm. The result is a crisp line without the ...

Bounded type parameters allow you to set restrictions on generic type arguments: class SomeClass { } class Demo<T extends SomeClass> { } But a type parameter can only bind to a single class type. An interface type can be bound to a type that already had a binding. This is achieve...

A regex pattern where a DOTALL modifier (in most regex flavors expressed with s) changes the behavior of . enabling it to match a newline (LF) symbol: /cat (.*?) dog/s This Perl-style regex will match a string like "cat fled from\na dog" capturing "fled from\na" into Group 1....

Another example is a MULTILINE modifier (usually expressed with m flag (not in Oniguruma (e.g. Ruby) that uses m to denote a DOTALL modifier)) that makes ^ and $ anchors match the start/end of a line, not the start/end of the whole string. /^My Line \d+$/gm will find all lines that start with My...

The modifier that allows using whitespace inside some parts of the pattern to format it for better readability and to allow comments starting with #: /(?x)^ # start of string (?=\D*\d) # the string should contain at least 1 digit (?!\d+$) # the string cannot consist of digi...

This is a .NET regex specific modifier expressed with n. When used, unnamed groups (like (\d+)) are not captured. Only valid captures are explicitly named groups (e.g. (?<name> subexpression)). (?n)(\d+)-(\w+)-(?<id>\w+) will match the whole 123-1_abc-00098, but (\d+) and (\w+) won't...

A PCRE modifier that causes an error if any backslash in a pattern is followed by a letter that has no special meaning. By default, a backslash followed by a letter with no special meaning is treated as a literal. E.g. /big\y/ will match bigy, but /big\y/X will throw an exception. Inline v...

%storemagic stores variables and macros on IPython's database. To automatically restore stored variables at startup add this to ipython_config.py: c.StoreMagic.autorestore = True Example: In [1]: l = ['hello',10,'world'] In [2]: %store l In [3]: exit (IPython session is closed and started...

You may install Composer locally, as part of your project, or globally as a system wide executable. Locally To install, run these commands in your terminal. php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" # to check the validity of the downloaded installer, ch...

Dojo provides us various themes like tundra, claro etc. Load themes using link tag in your HTML page pointing to Google CDN.