Create Table T(ID integer, datetime Integer, data integer, primary key(ID,
datetime))
________________________________
???: Andrew Stewart<mailto:AStewart at arguscontrols.com>
????: ?2015/?12/?7 23:01
???: 'SQLite mailing list'<mailto:sqlite-users at mailinglists.sqlite.org>
??: [sqlite] Making data unique
Hi,
I have a table that consists of 3 elements:
ID - integer
Date/time - integer
Data - integer
A single ID can exist multiple times.
A single Date/time can exist multiple times.
An ID & Date/time combination is unique.
What is the best way to ensure uniqueness in this table.
Thanks,
Andrew Stewart
Software Designer
Argus Controls
#101 - 18445 53 AVE
Surrey, BC V3S 7A4
t: 1-888-667-2091 ext : 108
t: 1-604-536-9100 ext : 108
f: 604-538-4728
w: www.arguscontrols.com<http://www.arguscontrols.com/>
e: astewart at arguscontrols.com<mailto:astewart at arguscontrols.com>
Notice: This electronic transmission contains confidential information,
intended only for the person(s) named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or any other use of this email is strictly prohibited. If you have received
this transmission by error, please notify us immediately by return email and
destroy the original transmission immediately and all copies thereof.
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
