472,139 Members | 1,636 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,139 software developers and data experts.

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 1794

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.