Table creation/Postal addresses: Difference between revisions
Content added Content deleted
m (→{{header|Ruby}}: permanent => persistent) |
|||
| Line 121: | 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]]. |
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}}== |
=={{header|MySQL}}== |
||