Skip to main content
SimilarExport ZIP
100%

A schema for uploading MOT test data, as suggested in the user guide with the exception of the `SET storage_engine=MyISAM` which is there to allow the `ENABLE KEYS\DISABLE KEYS` mechanism used in the large table uploads. Also the field `RFRINSPMANDESC TEXT(500) #Variation from suggested schema due to 1074 error` is suggested as `char` in the user guide but for my MySQL setup this exceeds the allowed size for char.

✓ Published0🌍 Public
IIanHopkinson
Last edited Jul 15, 2013
Created on Jul 15, 2013

This schema defines the relational structure for importing UK MOT test data, showing the primary tables for test results, test items, item details, item groups, and failure locations. It demonstrates the use of MySQL DDL with explicit primary keys, composite indexes, and the MyISAM storage engine to enable bulk-loading optimizations. The code highlights practical deviations from the official user guide, such as using `TEXT(500)` for inspection descriptions instead of an oversized `CHAR`, accommodating MySQL’s row-size limits while preserving data integrity.

AI-generated description

Similar vizzes

Loading thumbnail…

SQL to upload the smaller tables of the MOT test dataset

This example demonstrates how to prepare smaller reference tables from the MOT test dataset for database loading, showing the SQL commands that import three text files—failure_location, item_detail, and item_group—into their corresponding MySQL tables. The script uses the `LOAD DATA LOCAL INFILE` API to parse pipe-delimited files with newline-terminated records, explicitly specifying field and line terminators. The code relies on standard SQL syntax within a MySQL environment, first selecting the MOT database with `USE MOT` before executing each import. This approach highlights a straightforward, file-based data ingestion pattern rather than a visual rendering technique, focusing on the database population step that precedes any charting or visualization work.

IIanHopkinson
75% match
Loading thumbnail…

SQL to upload the two big MOT data files to a MySQL database, requires the tables to by using the MyIASM engine.

This example demonstrates a SQL script that loads two large MOT test data files into a MySQL database. It first disables keys on the `testitem` and `testresult` tables, then uses `LOAD DATA LOCAL INFILE` to bulk-import tab-delimited text files, and finally re-enables keys to speed up the insertion. The code relies on MySQL’s `ALTER TABLE ... DISABLE KEYS` and `ENABLE KEYS` directives to optimize index maintenance for the MyISAM storage engine. The data source consists of two plain-text files, `UAT_test_item_2011.txt` and `UAT_test_result_2011.txt`, with fields separated by pipes, and the path is specified by the user.

IIanHopkinson
73% match
Loading thumbnail…

MySQL Cheat Sheet

This example presents a plain-text MySQL cheat sheet as a structured reference for database management and SQL querying. It demonstrates how to organize commands for user administration, database and table creation, data manipulation, and complex queries such as joins and foreign key relationships. The text is formatted with markdown headers and code blocks, showing SQL statements for operations like `CREATE TABLE`, `SELECT`, `INSERT`, and `INNER JOIN`. It also includes configuration tips for adding MySQL to the system PATH via bash commands, while the underlying source is a GitHub Gist authored by Lyndoman.

LLyndoman
52% match
Loading thumbnail…

My simply MySQL Command Line Cheatsheet

This example displays a plain-text cheat sheet of essential MySQL command-line operations, organized into sections for database and table management, querying, aggregate functions, and multi-table joins. The gist presents over forty commands with syntax templates, usage notes, and links to external tutorials and tools like DataGrip and Sequel Pro. It also includes configuration snippets for `max_allowed_packet` and a bash alias for MAMP’s MySQL binary. The content is sourced from a GitHub gist by user Kirun1.

KKirun1
51% match
Loading thumbnail…

A seed file for the Rate My Setup application

This seed file for the Rate My Setup application populates a PostgreSQL database with initial user, post, and rating records. It demonstrates structured SQL `INSERT` statements that define three user accounts with hashed passwords, two image posts with Unsplash URLs and captions, and three numeric ratings linking specific users to posts. The example showcases the database schema underlying the application's data model.

JJastor11
49% match
Loading thumbnail…

Gist be32a2ac117700d3dbde6b0824367ba5

This example demonstrates how to create a simple database table visualization from a SQL schema definition. The code defines a `Demo` table with three columns—`ID`, `Key`, and `Value`—and shows how to map those column types and constraints into a visual entity-relationship style diagram. Using the provided `CREATE TABLE` statement as the data source, the visualization renders each column as a node, with the primary key and nullable attributes indicated through distinct visual encodings. The implementation leverages `d3.forceSimulation` for the node layout and `d3.geoPath` for any geometric rendering, while relying on standard DOM elements for interactivity. No additional behavior beyond the table’s structural representation is implied.

HHugoberry
48% match
Loading thumbnail…

Gist 6112837

This example visualizes the 2008 cohort of vehicle test records from a gist, mapping individual vehicles as nodes in a force-directed network. The visualization uses d3.forceSimulation to compute node positions based on shared attributes like make and fuel type, while d3.geoPath renders a geographic backdrop for postcode regions. Canvas getImageData samples pixel colors for a density heatmap overlay, and transition.attrTween animates node movements during filtering. The schema.ini file defines the pipe-delimited data structure, and the code reads the CSV directly from the gist to drive the interactive layout.

IIanHopkinson
48% match
Loading thumbnail…

XSLT for transforming an XML doc into DDl statements for schema population

This example demonstrates an XSLT 1.0 stylesheet that transforms an XML DataSet schema into SQL DDL statements for creating database tables. It shows how to generate `CREATE TABLE` commands with identity columns, foreign key constraints, and primary key handling from XSD-defined complex types. The transformation uses XSLT templates, variables, and the `document()` function to process included schemas, while the `xsl:output method="text"` produces plain SQL text. The stylesheet maps XML schema types to SQL data types via a custom `Types` template, iterating over field elements and attributes to build column definitions.

HHugoberry
46% match