Use SQLite Studio and its SQL Editor

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 พ.ย. 2024

ความคิดเห็น • 24

  • @sof_coelho
    @sof_coelho ปีที่แล้ว +6

    Hello. The green "+" button does not appear in order for me to create the database. Can you help me? Thank you

    • @NetworkingNewbies
      @NetworkingNewbies  ปีที่แล้ว

      Is it working from File menu?

    • @sof_coelho
      @sof_coelho ปีที่แล้ว

      @@NetworkingNewbies no, everything is just like the video, except for the green “+” button :(

    • @nicas901
      @nicas901 ปีที่แล้ว +1

      same for me

    • @sof_coelho
      @sof_coelho ปีที่แล้ว

      @@nicas901 I still haven’t found out how to fix this :(

    • @felixluna4184
      @felixluna4184 ปีที่แล้ว +7

      I have that same problem, tried looking for a while I couldnt figure out how to fix that. However, I did figure how to make a new database. Just click the folder icon, and in the it brings up the file system. Name the database in the filename box. Then just click enter. If you just hit enter, it be created as a file, and if you add .db it will make it a sqlite file. Dont know which one you will need. Not yet.

  • @najobsodar7528
    @najobsodar7528 11 หลายเดือนก่อน +2

    This is helpful video, many thanks...

  • @Damiee-nr8yc
    @Damiee-nr8yc ปีที่แล้ว +2

    Sir, please how can I add primary key on two different columns. It only allows it on one.

    • @NetworkingNewbies
      @NetworkingNewbies  ปีที่แล้ว

      Here is some discussion, it may be helpful.
      stackoverflow.com/questions/734689/sqlite-primary-key-on-multiple-columns

  • @sen7826
    @sen7826 6 หลายเดือนก่อน

    Could you do a "DB Browser vs SQLite Studio" video, or point me to some such video/article which compares the two tools?

    • @NetworkingNewbies
      @NetworkingNewbies  6 หลายเดือนก่อน

      I would simply google for its difference; I will try to make a video on it. Thanks for your comment

    • @sen7826
      @sen7826 6 หลายเดือนก่อน

      @@NetworkingNewbies that would be great, thank you. I actually installed both, liked both, kept both. Each has a small memory footprint so I don't mind. If I have to choose one though, I would choose SQLite Studio, for 2 reasons:
      1. The latest version of it is more recent than that of DB Browser for SQLite, which was released in 2021 or something.
      2. I like the SQLite Studio interface more, and it gives me more (configurable) keyboard shortcuts unlike DB.
      If you do make a video, maybe this information could help. Thanks again.

  • @mdaminulislam6315
    @mdaminulislam6315 4 วันที่ผ่านมา

    perfect!

  • @roshanlakhani1360
    @roshanlakhani1360 ปีที่แล้ว

    Excellent Sir

  • @xyzme1217
    @xyzme1217 ปีที่แล้ว +1

    Easy to follow

  • @rasheedrasheed6502
    @rasheedrasheed6502 ปีที่แล้ว +1

    How can I put a password to the database?

    • @NetworkingNewbies
      @NetworkingNewbies  ปีที่แล้ว +1

      stackoverflow.com/questions/1381264/password-protect-a-sqlite-db-is-it-possible

  • @hi-vw1rm
    @hi-vw1rm 2 หลายเดือนก่อน +1

    thanks