RosettaCodeData/Task/Table-creation-Postal-addresses/Run-BASIC/table-creation-postal-addresses.basic
2023-07-01 13:44:08 -04:00

10 lines
264 B
Text

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$)