*** 220,225 **** --- 220,234 ---- _: "More than one primary key" is an oxymoron when you're talking about the relational data model. By definition, a primary key uniquely identfies a row. What's the real problem you're trying to solve? + _:: A combined primary key is possible in SQLite, for example: + + CREATE TABLE strings ( + string_id INTEGER NOT NULL, + language_id INTEGER NOT NULL, + string TEXT, + PRIMARY KEY (string_id, language_id) + ); + *:UPDATE t1, t2 SET t1.f1 = value WHERE t1.f2 = t2.fa *:SHOW TABLES and DESCRIBE [tablename] would be nice - not sure if they're standard, but they are a
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|