RosettaCodeData/Task/Table-creation-Postal-addresses/Run-BASIC/table-creation-postal-addresses.basic

11 lines
264 B
Text
Raw Permalink Normal View History

2023-07-01 11:58:00 -04:00
sqliteconnect #mem, ":memory:" ' make handle #mem
mem$ = "
CREATE TABLE address (
addrID INTEGER PRIMARY KEY AUTOINCREMENT,
addrStreet TEXT NOT NULL,
addrCity TEXT NOT NULL,
addrState TEXT NOT NULL,
addrZIP TEXT NOT NULL
)"
#mem execute(mem$)