Search Result: exams - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 5 of about 5 for exams (0.002 sec.)

EXPLAIN: Inspect Query Plans – DuckDB 11104: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... r physical plan. To demonstrate, see the below example: CREATE TABLE students ( name VARCHAR , sid INTEGER ); CREATE TABLE exams ( eid INTEGER , subject VARCHAR , sid INTEGER ); INSERT INTO students VALUES ( 'Mark' , 1 ), ( 'Joe' , 2 ), ( 'Matthew' , ... 3 ); INSERT INTO exams VALUES ( 10 , 'Physics' , 1 ), ( 20 , 'Chemistry' , 2 ), ( 30 , 'Literature' , 3 ); EXPLAIN ANALYZE SELECT name FROM stude ... nts JOIN exams USING ( sid ) WHERE name LIKE 'Ma%' ; ┌─────────────────────────────┐ │┌───────────────────────────┐│ ││ Physical Plan ││ ...; https://man.mtool.work/duckdb/1.3/guides/meta/explain.html

EXPLAIN ANALYZE: Profile Queries – DuckDB 11104: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... ow is an example of running EXPLAIN ANALYZE on a query: CREATE TABLE students ( name VARCHAR , sid INTEGER ); CREATE TABLE exams ( eid INTEGER , subject VARCHAR , sid INTEGER ); INSERT INTO students VALUES ( 'Mark' , 1 ), ( 'Joe' , 2 ), ( 'Matthew' , ... 3 ); INSERT INTO exams VALUES ( 10 , 'Physics' , 1 ), ( 20 , 'Chemistry' , 2 ), ( 30 , 'Literature' , 3 ); EXPLAIN ANALYZE SELECT name FROM stude ... nts JOIN exams USING ( sid ) WHERE name LIKE 'Ma%' ; ┌─────────────────────────────────────┐ │┌───────────────────────────────────┐│ ││ T ...; https://man.mtool.work/duckdb/1.3/guides/meta/explain_analyze.html

Profiling – DuckDB 9652: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... TRA_INFO , OPERATOR_CARDINALITY , and OPERATOR_TIMING . CREATE TABLE students ( name VARCHAR , sid INTEGER ); CREATE TABLE exams ( eid INTEGER , subject VARCHAR , sid INTEGER ); INSERT INTO students VALUES ( 'Mark' , 1 ), ( 'Joe' , 2 ), ( 'Matthew' , ... 3 ); INSERT INTO exams VALUES ( 10 , 'Physics' , 1 ), ( 20 , 'Chemistry' , 2 ), ( 30 , 'Literature' , 3 ); PRAGMA enable_profiling = 'json' ; PRA ... false", "EXTRA_INFO": "true", "OPERATOR_CARDINALITY": "true", "OPERATOR_TIMING": "true"}' ; SELECT name FROM students JOIN exams USING ( sid ) WHERE name LIKE 'Ma%' ; The file's content after executing the query: { "extra_info" : {}, "query_name" : "S ...; https://man.mtool.work/duckdb/1.3/dev/profiling.html

Constraints – DuckDB 7023: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... s ( 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 subjects ( id ), student_id INTEGER REFERENCES students ( id ... rade 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: Violates foreign key constraint ...; https://man.mtool.work/duckdb/1.3/sql/constraints.html

Information Schema – DuckDB 7023: This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview ... nt_schema Name of the schema that contains the constraint. VARCHAR 'main' constraint_name Name of the constraint. VARCHAR 'exams_exam_id_fkey' table_catalog Name of the database that contains the table that contains the column that is restricted by th ... aint. VARCHAR 'main' table_name Name of the table that contains the column that is restricted by this constraint. VARCHAR 'exams' column_name Name of the column that is restricted by this constraint. VARCHAR 'exam_id' ordinal_position Ordinal position ... nt_schema Name of the schema that contains the constraint. VARCHAR 'main' constraint_name Name of the constraint. VARCHAR 'exams_exam_id_fkey' table_catalog Name of the database that contains the table (always the current database). VARCHAR 'my_db' ta ...; https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work