MySQL logical operators are easy

Поделиться
HTML-код
  • Опубликовано: 31 июл 2024
  • #MySQL #course #tutorial
    00:00:00 intro
    00:01:39 AND
    00:02:45 OR
    00:03:30 NOT
    00:04:29 BETWEEN
    00:05:11 IN
    00:05:42 conclusion

Комментарии • 15

  • @BroCodez
    @BroCodez  Год назад +7

    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 Год назад +7

    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 .....

  • @user-xq7ij2sb8d
    @user-xq7ij2sb8d Год назад +1

    Like your videos🎉

  • @DrinkCola
    @DrinkCola Год назад +2

    You are one and only 💕💕🧡🧡💕💕🧡🧡

  • @demnaqoridze3956
    @demnaqoridze3956 6 месяцев назад

    thanks

  • @Quindecim453
    @Quindecim453 Год назад

    bro can you make C++ module tutorial, i have problem using it in vs, it's doesn't work

  • @nanaarhin5567
    @nanaarhin5567 11 месяцев назад

    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?

  • @dankprogrammingmemes7807
    @dankprogrammingmemes7807 Год назад

    Great video, but why is there null at the bottom of every query

    • @Artur931030
      @Artur931030 11 месяцев назад

      It's a place for inserting new rows.

  • @FactManiacForYou
    @FactManiacForYou Год назад +3

    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

  • @JDM625
    @JDM625 8 месяцев назад +1

    who is that liking🤨🤨