How to Connect VSCode with MySQL database | Run SQL Queries
In this video, I will show you how to connect VSCode with MySQL database and we'll execute SQL Queries in Visual Studio Code. Step by step explanation how to connect to MySQL Database in Visual Studio Code. Learn to configure MySQL in Visual Studio Code
#vscode #mysql #vscode #visualstudiocode #sql
1: Install "MySQL by Jun Han" Extension
2: Install SQLTools from Extensions
3: Install SQLTools MySQL/MariaDB Driver
CREATE TABLE Users (
user_id INT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL
);
INSERT INTO Users (user_id, first_name, last_name, email)
VALUES
(1, 'Alice', 'Smith', '[email protected]'),
(2, 'Bob', 'Johnson', '[email protected]'),
(3, 'Charlie', 'Brown', '[email protected]');