SitePoint Sponsor

User Tag List

Results 1 to 12 of 12
  1. #1
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Anyone use Mysql FRONT?.. Please help

    Its not urgent or anything, but when viewing DATA under a particular table, next to each row is a check box. If you want, you can check as many rows as you want, what does that mean? What does checking it do?

    Thanks
    Bryan

  2. #2
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Checkbox? Where?

    (Only thing I can see is a dot/arrowhead, and when I select more than one row and, for example, press ctrl + del, I can delete multiple rows)

  3. #3
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are looking at your table, and you choose the DATA tab, where you can edit, delete, or write data, to the left of each row, assuming you have multiple, there is a white check box. You can check it if you want. I am running FRONT 2.5, so that might be different.

  4. #4
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I see, I have 2.4

  5. #5
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    But I still don't know what the checks marks are for, UNLESS, it has to do with a mass delete of certain rows, or changes to certain rows. That might be it

  6. #6
    SitePoint Guru CompiledMonkey's Avatar
    Join Date
    Sep 2002
    Location
    Richmond, VA
    Posts
    975
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would imagine it's used to delete a large number of rows at once.

  7. #7
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    In MySQL-Front 2.5, the checkboxes allow you to select multiple records for deletion easier. It is the only thing that I can see.
    Wayne Luke
    ------------


  8. #8
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I agree, in fact, I tried it.

    How do you set a primary key in FRONT?

  9. #9
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Open the Table Properties screen and right click anywhere. Choose "Add Field or Index" then click on the indexes tab in the resulting dialog box.
    Wayne Luke
    ------------


  10. #10
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, it says that a field must be NOT NULL. What does it exactly mean to have a null field and a not null. Is Null when the colum is empty or void?

  11. #11
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Correct. If a field is marked as NULL then having no value is valid. If the field is marked NOT NULL, then it must have a non-empty value.
    Wayne Luke
    ------------


  12. #12
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    whats the difference between having no value and a non-empty value


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •