MySQL logical operators are easy

  Рет қаралды 27,156

Bro Code

Bro Code

Күн бұрын

Пікірлер: 16
@BroCodez
@BroCodez Жыл бұрын
SELECT * FROM employees WHERE hire_date > '2023-01-05' AND job = “cook”; SELECT * FROM employees WHERE job = 'Cook' OR job = 'Cashier'; SELECT * FROM employees WHERE NOT job = 'Manager'; SELECT * FROM employees WHERE NOT job = 'Manager' AND NOT job = 'Asst. Manager'; SELECT * FROM employees WHERE hire_date BETWEEN '2023-01-04' AND '2023-01-07'; SELECT * FROM employees WHERE job IN ("cook", "cashier", "janitor");
@nikilnikki18
@nikilnikki18 Жыл бұрын
Bro can you make a general video of roadmap of programming... I am very new to this ..... I don't know what is SQL i don't even know whether i should learn it or not... How to perceive programming for different fields .....
@alcor6814
@alcor6814 2 ай бұрын
NOTE FOR LEARNERS - the Ctrl+Shift+Enter keyboard shortcut executes your commands (either just the selected ones, or all of them). Bro's clicking on the execute button manually so that we have a visual guide, but the keyboard shortcut does the same job.
@DrinkCola
@DrinkCola Жыл бұрын
You are one and only 💕💕🧡🧡💕💕🧡🧡
@Sonnen-e7j
@Sonnen-e7j Жыл бұрын
Like your videos🎉
@nanaarhin5567
@nanaarhin5567 Жыл бұрын
Hi Bro, I have been studying SQL with your videos and I think I am getting a hand of the commands now. What I wanted to ask about this video is that, in a company with many employees, can you select more than one employee_id after the WHERE command? Just so we can assign a job to more than one employee at a go.
@ilirgerguri3340
@ilirgerguri3340 Жыл бұрын
can you post more about Java please?
@Quindecim453
@Quindecim453 Жыл бұрын
bro can you make C++ module tutorial, i have problem using it in vs, it's doesn't work
@dankprogrammingmemes7807
@dankprogrammingmemes7807 Жыл бұрын
Great video, but why is there null at the bottom of every query
@Artur931030
@Artur931030 Жыл бұрын
It's a place for inserting new rows.
@demnaqoridze3956
@demnaqoridze3956 8 ай бұрын
thanks
@JDM625
@JDM625 10 ай бұрын
who is that liking🤨🤨
@FactManiacForYou
@FactManiacForYou Жыл бұрын
first
@enriquepasa
@enriquepasa Жыл бұрын
Nice avatar, mate. Heavy - one of my favorite TF2 classes... ech, this long gone golden age of gaming
@FactManiacForYou
@FactManiacForYou Жыл бұрын
@@enriquepasa heavy is the best
@enriquepasa
@enriquepasa Жыл бұрын
@@FactManiacForYou 4 sure
MySQL wild cards are easy
4:18
Bro Code
Рет қаралды 28 М.
MySQL: JOINS are easy (INNER, LEFT, RIGHT)
5:04
Bro Code
Рет қаралды 426 М.
DID A VAMPIRE BECOME A DOG FOR A HUMAN? 😳😳😳
00:56
World‘s Strongest Man VS Apple
01:00
Browney
Рет қаралды 67 МЛН
버블티로 부자 구별하는법4
00:11
진영민yeongmin
Рет қаралды 20 МЛН
Learn JSON in 10 Minutes
12:00
Web Dev Simplified
Рет қаралды 3,2 МЛН
Dependency Injection, The Best Pattern
13:16
CodeAesthetic
Рет қаралды 853 М.
Logical Database Design and E-R Diagrams
32:23
Brian Green
Рет қаралды 377 М.
MySQL: FOREIGN KEYS are easy (kind of)
8:17
Bro Code
Рет қаралды 227 М.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 81 М.
Learn SQL Basics in Just 15 Minutes!
16:57
Kenji Explains
Рет қаралды 160 М.
SQL Case When Statement | Use Cases | #SQL Course #8
36:19
Data with Baraa
Рет қаралды 4,3 М.
DID A VAMPIRE BECOME A DOG FOR A HUMAN? 😳😳😳
00:56