SELECT * Except One Column in SQL: How To

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

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

  • @MrPants-xy6db
    @MrPants-xy6db 2 месяца назад +2

    Good video. I find the quickest way in SQL Developer is to type 'select * from '. Provided the statement parses, there will be a squiggle under the *. Hover the mouse over that it will show you the full column list. Click to replace.

    • @DatabaseStar
      @DatabaseStar  2 месяца назад

      Oh thanks for the tip, I didn’t know you could do that.

  • @ahmetalpsamur
    @ahmetalpsamur 2 месяца назад +1

    Your database design and implementation videos are very valuable to me. They improve me a lot. Thank you sir.

    • @DatabaseStar
      @DatabaseStar  2 месяца назад

      Thanks, I'm glad they are helpful!

  • @matrixevo88
    @matrixevo88 2 месяца назад +1

    Great tips! It's amazing how helpful and time-saving these little tricks can be. Thanks for sharing.

    • @DatabaseStar
      @DatabaseStar  2 месяца назад

      Thanks! Glad this is helpful.

  • @mukhlimkurowo
    @mukhlimkurowo Месяц назад

    wonder why even giant dababase vendord do not implement it natively

    • @DatabaseStar
      @DatabaseStar  Месяц назад

      Yeah it seems strange

    • @mukhlimkurowo
      @mukhlimkurowo Месяц назад

      renungkan ini, misal di suatu tempat ada ajaran "WEDHUS UCUL", isinya yaitu:
      - memberi kambing kepada 100 fakir miskin setiap bulan dengan ikhlas karena Allah SWT
      - menyantuni 100 anak yatim dg memberi uang masing2 1 jt setiap bulan dengan ikhlas karena Allah SWT
      apakah ajaran "WEDHUS UCUL" tsb bid'ah?