MySQL flags for an image

Question

I have got a column of images in my MySQL database, but I would like to know what column flag I should use? (PK, NN, UQ, BIN, UN, ZF, AI) Or do they even matter?

Edit: maybe I should mention that it's a blob datatype

Thanks..

Hava a look at http://stackoverflow.com/questions/3663952/what-do-column-flags-mean-in-mysql-workbench — pbaldauf, Nov 14 '14 at 18:25
Huh? I have no idea what those flags mean (Primary Key? Not Nullable? etc.?). Also, Why do you think you should be storing images as blobs in a DB? 999 times out of 1000, when you see this sort of design, it is a bad idea. — Mike Brant, Nov 14 '14 at 18:26
I have seen that page, but I dont think that page will help me? Sorry for my ignorance ;) — Filip Rosén, Nov 14 '14 at 18:27
[storing-images-in-db-yea-or-nay](https://stackoverflow.com/questions/3748/) — juergen d, Nov 14 '14 at 18:27
Okey, storing as a blob was what I've been told to do, could you give me an alternative? — Filip Rosén, Nov 14 '14 at 18:28

score 1 · Accepted Answer · answered Nov 14 '14 at 18:34

First: Understand what each flag means:

PK: Primary key: Meant for primary keys (obviously, a BLOB can't be a PK)
NN: Not nullable: Is the field mandatory? If it is, use this flag
UQ: Unique: Forces a unique index on the column (again, not a good idea on a BLOB)
BIN: Binary: Stores strings as binary strings (not necesary for BLOB)
UN: Unsigned: Only non-negative numbers (could a BLOB be positive or negative?)
ZF: Zero-fill: Left-pad number values with zeros (do I really need to say anything related to BLOBs regarding this?)
AI: Auto-incremental (Do I really need to explain this?)

MySQL flags for an image

1 Answers1