MySQL - The Basics // Learn SQL in 23 Easy Steps
Why Stack Overflow recommends it
Stack Overflow users cite it as the tutorial they were following when they hit setup problems with MySQL, the SQLTools VS Code extension, and logging in to the server.
Recommended by 0 people across 0 different months, 2021 to 2023.
What it is
A 17-minute beginner tutorial from Fireship that walks through relational database basics and MySQL by recreating an Airbnb-style schema in raw SQL. It covers installing MySQL, creating tables, inserting and querying data, filtering, indexes, and joins, using the SQLTools extension in VS Code.
What people said
Cites Lord Dewi · 2021-05 · Stack Overflow · on “How can I fix the error "Cannot destructure property 'name' of 'undefined' as it is undefined" using MySQL, VSCode and SQLTools with basic queries?”
Some basics... I have MySQL installed using the latest version of WAMP and it works fine. MySQL v5.7.31 I use the latest version of VSCode, v1.56.2 I Installed the SQLTools Extension for VSCode, v0.23.0 by Matheus Teixeira I installed the SQLTools MySQL/MariaDB Driver for SQLTools, v0.2.0 I started watching a tutorial, [this video] which helped me install SQLTools. It worked at first but as I progressed I got the above error. "Cannot destructure property 'name' of 'undefined' as it is undefined" Sometimes the query still works, like with INSERT INTO, but not with SELECT FROM. On GIT this was reported back on 10/28/2020 and has not been resolved there. I see a lot of articles here about that error
Cites Trev347 · 2022-07 · Stack Overflow · on “Why will my file open in the terminal, but won't open when I double click on it?”
I just downloaded mysql community server [LINK] . I was watching a [this video] (at time 5:36) and in order to open up the mysql application file you have to open it in the terminal and provide a username and password. When I found the same mysql application file in my computer files (C:\Program Files\MySQL\MySQL Server 8.0\bin/mysql) and tried to open it by double clicking, it instantly closes out of the app and nothing happens. I'm curious why can't I double click to open the application? Why do I need to open it in terminal with a provided username / password? I'm curious because if I wasn't watching a Youtube video that shows me exactly how to open mysql I would have never even guessed to ope
Cites William V. West · 2023-10 · Stack Overflow · on “MySQL - Error fetching records. Access denied for user 'Save password'@'localhost'”
I am a beginner in MySQL. I use VsCode on Windows and copied the code at 9:23 on this Youtube tutorial: [youtube] ( [this video] ) Here is the code: CREATE TABLE Users( id INT PRIMARY KEY AUTO_INCREMENT, email VARCHAR(255) NOT NULL UNIQUE, bio TEXT, country VARCHAR(2) ); When run, I am met with this error: Error fetching records. Access denied for user 'Save password'@'localhost' (using password: YES) Source: SQLTools (Extension) The output bar returns this message: [1697130812674] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1697130812675] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1697130812676] INFO (ls): REQUEST RECEIVED => connection/ConnectRequest [1697130