Skip to content

Instantly share code, notes, and snippets.

@Sherpard

Sherpard/sql-export-test.sql

Last active November 5, 2020 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Sherpard/114e762a9c57ae30638917c5eb583e39 to your computer and use it in GitHub Desktop.
Save Sherpard/114e762a9c57ae30638917c5eb583e39 to your computer and use it in GitHub Desktop.
Download ZIP
Test Schema
Raw
sql-export-test.sql
CREATE DATABASE `test-schema`
create table if not exists `testTable`
(
`testId` int auto_increment,
`testFlag` bit not null,
constraint `table_pk`
unique (`testId`)
);
INSERT INTO `test-schema`.testTable (testId, testFlag) VALUES (1, true);
INSERT INTO `test-schema`.testTable (testId, testFlag) VALUES (2, true);
INSERT INTO `test-schema`.testTable (testId, testFlag) VALUES (3, false);
INSERT INTO `test-schema`.testTable (testId, testFlag) VALUES (4, false);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment