i'm quite a beginner at this stuff.. right now i have a very basic database: 2 tables:
Table 1: Handheld_tags: 2 columns
Column 1: tag_in varchar(16)
Column 2: time_in timestamp
Table 2: Registered_tags: 2 columns
Column 1: tag_reg varchar(16)
Column 2: time_reg timestamp
1. Now I'm loading the Registered_tags table with a text file that has tag_reg
data but need the timestamp to be put automatically when the row is added to
The query is:
load data infile "expected.txt" into table registered_tags lines
But all the timestamp values i get in the table are 0000-00-00 00:00:00
I've tried putting in NOW() and NULL for the field value in the text file but
2. I need to compare the "tag_in" column in Handheld_tags table with
the "tag_reg" column in Registered_tags table...
- To see the common entries in these two columns..
- To see whats in tag_in column and not in tag_reg and vice versa..
How do i go about this ?
Thnak you for your help..
September 22, 2005 9:28 AM
September 22, 2005 10:01 AM