Link to this page

MYSQL Primary Key in TABLE

Submitted by rimian on Sat, 12/02/2006 - 09:19

ok...

I am creating a table with one INT field and one row.

Does it have to be a primary key?

Submitted by purserj on Sat, 12/02/2006 - 09:51.

Okay first off, does this really need to be a table all by itself?

If its only one field/one record then no it doesn't need to be a Primary key

Submitted by rimian on Sat, 12/02/2006 - 10:06.

i want to make myself a ye olde style counter. just as an exercise into this CMS.

i need to work out how to insert one row into table if a row does not exist. something like

INSERT INTO x WHERE field NOT IN (SELECT * FROM x)

or maybe

INSERT INTO x WHERE NOT EXISTS ...

or INSERT INGORE

i will find it...

maybe the config table can have another record..