Skip to content

Instantly share code, notes, and snippets.

@machinelearningplus
Created September 24, 2023 10:16
Show Gist options
  • Save machinelearningplus/1dc99457f541f2c0364981a05e1f03c1 to your computer and use it in GitHub Desktop.
Save machinelearningplus/1dc99457f541f2c0364981a05e1f03c1 to your computer and use it in GitHub Desktop.
-- Creating tableA
CREATE TABLE tableA (
id INT PRIMARY KEY,
name VARCHAR(255)
);
-- Inserting data into tableA
INSERT INTO tableA (id, name) VALUES
(1, 'John'),
(2, 'Jane'),
(3, 'Doe'),
(4, 'Smith'),
(5, 'Eva');
-- Creating tableB
CREATE TABLE tableB (
id INT PRIMARY KEY,
description VARCHAR(255)
);
-- Inserting data into tableB
INSERT INTO tableB (id, description) VALUES
(1, 'First ID'),
(3, 'Third ID'),
(5, 'Fifth ID');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment