Table creation: Difference between revisions
Content added Content deleted
m (Rearranged some language entries into alphabetical order.) |
Thundergnat (talk | contribs) (Rename Perl 6 -> Raku, alphabetize, minor clean-up) |
||
Line 372: | Line 372: | ||
SIMPLEBASE |
SIMPLEBASE |
||
</lang> |
</lang> |
||
=={{header|Mathematica}}== |
=={{header|Mathematica}}== |
||
<lang Mathematica>Needs["DatabaseLink`"];conn = OpenSQLConnection[JDBC["mysql", |
<lang Mathematica>Needs["DatabaseLink`"];conn = OpenSQLConnection[JDBC["mysql", |
||
Line 441: | Line 442: | ||
m[1,] = ["Barack", "Obama", 20500]; |
m[1,] = ["Barack", "Obama", 20500]; |
||
\\ ...</lang> |
\\ ...</lang> |
||
⚫ | |||
⚫ | In Perl 6, there is no 'database' type built in, so it is somewhat ambiguous when specifying 'create a database table'. Perl 6 offers bindings to most common databases through its DBIish module but mostly abstracts away the differences between the underlying databases, which hides many of the finer distinctions of what may be stored where. The actual data types and options available are properties of the database used. |
||
⚫ | |||
⚫ | |||
⚫ | Perl 6 offers two broad categories of collective container types; those that do the Positional role and those that do Associative. Positional objects are collective objects that access the individual storage slots using an integer index. Associative objects use some sort of other pointer (typically string) to access their storage slots. |
||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
=={{header|Phix}}== |
=={{header|Phix}}== |
||
Line 576: | Line 547: | ||
-- varchar(#): variable length text field up to # |
-- varchar(#): variable length text field up to # |
||
-- text: not limited</lang> |
-- text: not limited</lang> |
||
=={{header|Python}}== |
=={{header|Python}}== |
||
Line 624: | Line 594: | ||
(define postal (sqlite3-connect #:database "/tmp/postal.db" #:mode 'create)) |
(define postal (sqlite3-connect #:database "/tmp/postal.db" #:mode 'create)) |
||
</lang> |
</lang> |
||
⚫ | |||
(formerly Perl 6) |
|||
⚫ | In Perl 6, there is no 'database' type built in, so it is somewhat ambiguous when specifying 'create a database table'. Perl 6 offers bindings to most common databases through its DBIish module but mostly abstracts away the differences between the underlying databases, which hides many of the finer distinctions of what may be stored where. The actual data types and options available are properties of the database used. |
||
⚫ | |||
⚫ | |||
⚫ | Perl 6 offers two broad categories of collective container types; those that do the Positional role and those that do Associative. Positional objects are collective objects that access the individual storage slots using an integer index. Associative objects use some sort of other pointer (typically string) to access their storage slots. |
||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
⚫ | |||
=={{header|REXX}}== |
=={{header|REXX}}== |
||
Line 720: | Line 721: | ||
The example at [[Table creation/Postal addresses#Ruby]] puts Ruby objects into the PStore. |
The example at [[Table creation/Postal addresses#Ruby]] puts Ruby objects into the PStore. |
||
=={{header|Run BASIC}}== |
=={{header|Run BASIC}}== |
||
Line 804: | Line 804: | ||
(suppliers.schema ++ coffees.schema).create |
(suppliers.schema ++ coffees.schema).create |
||
)}</lang> |
)}</lang> |
||
=={{header|SQL PL}}== |
=={{header|SQL PL}}== |
||
{{works with|Db2 LUW}} |
{{works with|Db2 LUW}} |