Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table contacts (
- contact_id int(8) not null auto increment, #primary key
- pid int(8) not null, #personal id
- contakt_time datetime, #time of contact
- )
- SELECT * FROM contacts where pid = 1201;
- contact pid contact_time
- -----------------------------------
- 10530 1201 2014-01-04 14:33:00
- 11475 1201 2014-01-13 18:16:00
- 13460 1201 2014-02-03 12:23:00
- 14220 1201 2014-02-10 16:55:10
- 15599 1201 2014-02-24 21:03:34
- 16488 1201 2014-03-06 12:45:00
- 16499 1201 2014-03-06 14:55:00
- 16900 1201 2014-03-10 11:18:00
- 19108 1201 2014-04-02 10:40:00
- 20954 1201 2014-04-22 17:24:00
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement