Table creation/Postal addresses: Difference between revisions
Content added Content deleted
(Added Wren) |
|||
| Line 578: | Line 578: | ||
conn:close()</lang> |
conn:close()</lang> |
||
=={{header|Mathematica}}== |
=={{header|Mathematica}}/{{header|Wolfram Language}}== |
||
<lang Mathematica>TableCreation="CREATE TABLE address ( |
<lang Mathematica>TableCreation="CREATE TABLE address ( |
||
addrID INTEGER PRIMARY KEY AUTOINCREMENT, |
addrID INTEGER PRIMARY KEY AUTOINCREMENT, |
||
addrStreet TEXT NOT NULL, addrCity TEXT NOT NULL, |
addrStreet TEXT NOT NULL, addrCity TEXT NOT NULL, |
||
addrState TEXT NOT NULL, addrZIP TEXT NOT NULL )"; |
addrState TEXT NOT NULL, addrZIP TEXT NOT NULL )"; |
||
Needs["DatabaseLink`"] |
Needs["DatabaseLink`"] |
||
conn=OpenSQLConnection[ JDBC[ "mysql","databases:1234/conn_test"], "Username" -> "test"] |
conn=OpenSQLConnection[ JDBC[ "mysql","databases:1234/conn_test"], "Username" -> "test"] |
||