Use SQLite Studio and its SQL Editor

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

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

  • @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

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

      Is it working from File menu?

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

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

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

      same for me

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

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

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

      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 10 หลายเดือนก่อน +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.

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

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

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

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

    • @GDNetworkingNewbie
      @GDNetworkingNewbie  5 หลายเดือนก่อน

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

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

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

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

    thanks

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

    Easy to follow

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

    Excellent Sir

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

    How can I put a password to the database?

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

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