Skip to content

Instantly share code, notes, and snippets.

@rafaeltedesco

rafaeltedesco/create_table_from_another.sql

Last active April 28, 2023 20:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rafaeltedesco/00a924756d1d2213d8105cf0244fdf44 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rafaeltedesco/00a924756d1d2213d8105cf0244fdf44 to your computer and use it in GitHub Desktop.
Download ZIP
Create TABLE based on Another TABLE filtered
Raw
create_table_from_another.sql
-- CREATE A TABLE BASED ON ANOTHER
CREATE DATABASE people_by_name;
CREATE TABLE people_by_name.people_with_p
AS SELECT * FROM main_db.people WHERE first_name LIKE 'p%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment