Anyone use Mysql FRONT?.. Please help

[jag5311]

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

[jofa]

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)

[jag5311]

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.

[jofa]

I see, I have 2.4

[jag5311]

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

[CompiledMonkey]

I would imagine it's used to delete a large number of rows at once.

[Hierophant]

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.

[jag5311]

I agree, in fact, I tried it.

How do you set a primary key in FRONT?

[Hierophant]

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.

[jag5311]

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?

[Hierophant]

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.

[jag5311]

whats the difference between having no value and a non-empty value