47SQL.1 - HoloCure Collabs tool, using Postgres and SQL

Published: 01 October 2023
on channel: WesleySon
14
1

This time, using SQL to make the collabs tool.
Which means I first have to make a database, and tables.

Where to download Postgres and pgAdmin
https://www.postgresql.org/
https://www.pgadmin.org/


00:00 Download Postgres and pgAdmin
00:24 Looking at the CSV data-file
00:48 Create a new database
01:05 Create table through the GUI
02:50 Table SQL
03:37 Making the unlocks-table
04:59 Insert Into-method
08:13 Part 1
08:30 Show all weapon names
09:17 Show all collab names
10:24 All collabs + information
12:14 Using min on both weapon columns (bad)
12:45 Look up a collab
13:02 Variables
15:45 There's no '* but exclude these collumns'
16:47 Look up a weapon


Watch video 47SQL.1 - HoloCure Collabs tool, using Postgres and SQL online without registration, duration hours minute second in high quality. This video was added by user WesleySon 01 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14 once and liked it 1 people.