Search Result: subjects - DuckDB 2.0 全文検索

Constraints 9414: In SQL, constraints can be specified for tables. Constraints enforce certain properties over data that is inserted into a table. Constraints can be specified along with the schema of the table as part of the CREATE TABLE statement . In cert ... nforces that the key exists in the other table. CREATE TABLE students (id INTEGER PRIMARY KEY, name VARCHAR); CREATE TABLE subjects (id INTEGER PRIMARY KEY, name VARCHAR); CREATE TABLE exams ( exam_id INTEGER PRIMARY KEY, subject_id INTEGER REFERENCES su ... d), student_id INTEGER REFERENCES students(id), grade INTEGER ); INSERT INTO students VALUES (1, 'Student 1'); INSERT INTO subjects VALUES (1, 'CS 101'); INSERT INTO exams VALUES (1, 1, 1, 10); INSERT INTO exams VALUES (2, 1, 2, 10); Constraint Error: Vi ...; https://man.mtool.work/duckdb/2.0/sql/constraints.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work