469,623 Members | 1,192 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Unique version record in a MySQL database.

Unique table version record
Hello,
I am using a table record to store informations about database dump,I
use this table :

CREATE TABLE dump_version(
count BIGINT unsigned NOT NULL DEFAULT 0,
timestamp TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
DEFAULT 0
);
And I added a record (INSERT INTO dump_version () VALUES();) that I
modify each time I dump the database.
The only problem is that I can't ensure that this table will contain
only a single record, is that a way to ensure a king of 'UNIQUE' record
or something?
Thank you in advance.
Regards.
Nassim.

Jul 26 '06 #1
0 1754

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Westcoast Sheri | last post: by
7 posts views Thread by Tony Clarke | last post: by
reply views Thread by nassim.bouayad.agha | last post: by
reply views Thread by Hans | last post: by
10 posts views Thread by Phil Latio | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.