Anonymous user
Table creation/Postal addresses: Difference between revisions
added php
m (link to sqlite) |
(added php) |
||
Line 187:
{Sqlite.close DB}
end</lang>
=={{header|PHP}}+{{header|SQLite}}==
{{trans|Python}}
not tested
<lang php><?php
$db = new SQLite3(':memory:');
$db->exec("
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
addrStreet TEXT NOT NULL,
addrCity TEXT NOT NULL,
addrState TEXT NOT NULL,
addrZIP TEXT NOT NULL
)
");
?></lang>
=={{header|PostgreSQL}}==
Line 202 ⟶ 218:
<lang python>>>> import sqlite3
>>> conn = sqlite3.connect(':memory:')
>>>
▲>>> c.execute('''CREATE TABLE address (
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
addrStreet TEXT NOT NULL,
| |||