#MySQL #tutorial #course
You can copy and paste all of the following statements if you would like to follow along in this video.
P.S. Make sure you have a customers table if you’re linking the foreign key on customer_id.
------------------------------------------------------------
DROP TABLE IF EXISTS transactions;
CREATE TABLE transactions (
transaction_id INT PRIMARY KEY AUTO_INCREMENT,
amount DECIMAL(5, 2),
customer_id INT,
order_date DATE,
FOREIGN KEY (customer_id)
REFERENCES customers(customer_id)
);
INSERT INTO transactions
VALUES (1000, , 3, “2023-01-01“),
(1001, , 2, “2023-01-01“),
(1002, , 3, “2023-01-02“),
(1003, , 1, “2023-01-02“),
(1004, , NULL, “2023-01-03“),
(1005, , 4, “2023-01-03“),
(1006, , NULL, “2023-01-03“);
SELECT * FROM transactions;
------------------------------------------------------------
00:00:00 intro
00:00:16 data for this demo
00:00:00 GROUP BY
00:03:19 HAVING
00:04:36 conclusion
1 view
561
136
11 months ago 03:00:00 1
MySQL Full Course for free 🐬 (2023)
11 months ago 02:37:21 1
2. Базы данных. Модификация и выборка данных | Технострим
11 months ago 01:49:38 1
7. Базы данных. Репликация, полнотекстовый поиск, JSON | Технострим
11 months ago 02:02:36 1
4. Базы данных. Транзакции. Триггеры и хранимые процедуры | Технострим
11 months ago 01:57:27 4
1. Базы данных. Введение
11 months ago 02:34:25 1
3. Базы данных. Выборка данных (продолжение)
11 months ago 02:16:29 1
9. Базы данных. MySQL и сравнение с PostgreSQL
11 months ago 01:20:55 1
ПОЛНЫЙ КУРС по SQL БАЗАМ ДАННЫХ | От Начального до Среднего уровня [1 ЧАС]
11 months ago 00:24:31 1
Базы данных SQL уроки для начинающих. SELECT, JOINS, GROUP BY, INSERT, UPDATE, WHERE
12 months ago 00:21:06 1
College Library Management System in PHP MySQL | Free Download Source Code
12 months ago 00:29:32 7
HackTheBox - PC
12 months ago 00:12:12 2
SQL для тестировщика — SELECT, LIKE, GROUP и др.
1 year ago 00:02:06 1
SQL query: Search data by year and month in SQL Server
1 year ago 00:26:50 1
For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL | Citus Con 2023
1 year ago 00:23:31 1
Spring Boot File Upload and Download REST API | Spring Data JPA | JavaTechie
1 year ago 00:01:41 7
Code copy table from one database to another database in sql server
1 year ago 00:05:54 1
Self-learning | Ryan Lee | TEDxHongKongED
1 year ago 05:25:39 21
SQL Tutorial for Beginners (and Technical Interview Questions Solved)
1 year ago 00:04:47 1
sql tutorial for beginners: How to avoid duplicate values in SQL Server update query