Anonymous user
Table creation/Postal addresses: Difference between revisions
→{{header|Mathematica}}
m (→{{header|Ruby}}: permanent => persistent) |
|||
Line 121:
Of course J can connect external databases too, using e.g. [[j:Studio/ODBC%20Basics|ODBC]]. See the [[j:DB|list of J database topics]].
=={{header|Mathematica}}==
<lang Mathematica>TableCreation="CREATE TABLE address (
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
addrStreet TEXT NOT NULL, addrCity TEXT NOT NULL,
addrState TEXT NOT NULL, addrZIP TEXT NOT NULL )";
Needs["DatabaseLink`"]
conn=OpenSQLConnection[ JDBC[ "mysql","databases:1234/conn_test"], "Username" -> "test"]
SQLExecute[ conn, TableCreation]</lang>
=={{header|MySQL}}==
| |||