Redaisy
commented
5 years ago Sort of solution guide to anyone figuring out these commands on sql server:
CREATE DATABASE pets_database GO
USE pets_database GO
CREATE TABLE cats (id INTEGER PRIMARY KEY NOT NULL, name TEXT NULL, age INTEGER NULL, breed TEXT NULL, owner_id INTEGER NULL) GO
INSERT cats (id, name, age, breed, owner_id) VALUES (1, 'Maru', 3, 'Scottish Fold', 1) INSERT cats (id, name, age, breed, owner_id) VALUES (2, 'Hana', 1, 'Tabby', 1) INSERT cats (id, name, age, breed) VALUES (3, "Lil’ Bub", 5, 'American Shorthair') INSERT cats (id, name, age, breed) VALUES (4, 'Moe', 10, 'Tabby') INSERT cats (id, name, age, breed) VALUES (5, 'Patches', 2, 'Calico') INSERT cats (id, breed) VALUES (6, “Tabby”) GO
to set column width
:setvar SQLCMDMAXVARTYPEWIDTH 30 :setvar SQLCMDMAXFIXEDTYPEWIDTH 30
TOP replaces LIMIT in SQL Server
SELECT TOP 1 * FROM cats ORDER BY age DESC GO
in order to use COUNT on breed column
ALTER TABLE cats ALTER COLUMN breed VARCHAR(MAX) GO SELECT breed, COUNT(breed) FROM cats GROUP BY breed GO
This readme doesn't help Windows users figure out powershell- the commands are different. I tried Powershell but it was pretty different from what we learned. It was easier for me to install SQL Server (free: https://www.microsoft.com/en-us/sql-server/sql-server-downloads), and use SQLCMD and T-SQL. Here's a nice link to directions for Windows users on SQLCMD: https://docs.microsoft.com/en-us/sql/t-sql/lesson-1-creating-database-objects?view=sql-server-2017#create-a-table. To create a SQLCMD terminal, just type sqlcmd after opening your command prompt.