Tutorial by Topics: table

[[local] mt = ]getmetatable(t) --> retrieve associated metatable for 't' [[local] t = ]setmetatable(t, mt) --> set the metatable for 't' to 'mt' and returns 't' ParameterDetailstVariable referring to a lua table; can also be a table literal.mtTable to use as a metatable; can have ze...

The Open University (1999) Relational Database Systems: Block 2 Relational Theory, Milton Keynes, The Open University.

ALTER [IGNORE] TABLE tbl_name [alter_specification [, alter_specification] ...] [partition_options] alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX|KE...

Immutable objects have fixed state (no setters), so all state must be known at object creation time. Although not technically required, it is best practice to make all fields final. This will make the immutable class thread-safe (cf. Java Concurrency in Practice, 3.4.1). The examples show severa...

objectskeysAn array containing the values for the new dictionary.CellAn array containing the keys for the new dictionary. Each key is copied and the copy is added to the dictionary.

CREATE [TEMPORARY] [EXTERNAL] TABLE [IF NOT EXISTS] [db_name.]table_name [(col_name data_type [COMMENT col_comment], ...)] [COMMENT table_comment] [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)] [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] I...

Data.table is a package for the R statistical computing environment. It extends the functionality of data frames from base R, particularly improving on their performance and syntax. A number of related tasks, including rolling and non-equi joins, are handled in a consistent concise syntax like DT[...

ScriptableObjects with AssetBundles Pay attention when adding prefabs to AssetBundles if they contain references to ScriptableObjects. Since ScriptableObjects are essentially assets, Unity creates duplicates of them before adding them to AssetBundles, which may result in undesired behaviour dur...

The assignment of string-literals in VBA is confined by the limitations of the IDE and the codepage of the current user's language settings. The examples above demonstrate the special-cases of escaped strings, special, non-printable strings and long string-literals. When assigning string-literals...

Recursive sub-query factoring is available in Oracle 11g R2.

A data.table is an enhanced version of the data.frame class from base R. As such, its class() attribute is the vector "data.table" "data.frame" and functions that work on a data.frame will also work with a data.table. There are many ways to create, load or coerce to a data.tabl...

There are many excellent reference and example sources on the Web. Some examples and explanations are created here as a collection point for quick answers. More detailed illustrations may be linked to external content (instead of copying existing original material).

Partitioning is a functionality to split tables and indexes into smaller pieces. It is used to improve performance and to manage the smaller pieces individually. The partition key is a column or a set of columns that defines in which partition each row is going to be stored. Partitioning Overview ...

DROP TABLE table_name; DROP TABLE IF EXISTS table_name; -- to avoid pesky error in automated script DROP TABLE t1, t2, t3; -- DROP multiple tables DROP TEMPORARY TABLE t; -- DROP a table from CREATE TEMPORARY TABLE ... ParametersDetailsTEMPORARYOptional. It specifies that only tempora...