Table creation/Postal addresses: Difference between revisions
→{{header|Phix}}
m (→{{header|Kotlin}}: Minor correction to preamble.) |
|||
Line 797:
)
STATEMENT</lang>
=={{header|Phix}}==
{{libheader|SQLite}}
<lang Phix>include pSQLite.e
constant sqlcode = """
CREATE TABLE address (
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
addrStreet TEXT NOT NULL,
addrCity TEXT NOT NULL,
addrState TEXT NOT NULL,
addrZIP TEXT NOT NULL)"""
sqlite3 db = sqlite3_open("address.sqlite")
integer res = sqlite3_exec(db,sqlcode)
if res=SQLITE_OK then
sqlite3_close(db)
else
-- can show eg "sqlite3_exec error: 1 [table address already exists]"
printf(1,"sqlite3_exec error: %d [%s]\n",{res,sqlite_last_exec_err})
end if</lang>
=={{header|PHP}}+SQLite==
| |||