If I have two similar tables, with identical columns how would I
select rows that are not duplicated between both tables? Any easy way
to do this?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
Thanks! Worked perfectly. And also thanks to the other people who
responded. Being unfamiliar with how MySQL seems to handle time your
responses really helped!
-Chris
On Jun 27, 2005, at 1:16 PM, [EMAIL PROTECTED] wrote:
That would have worked if TIME values weren't converted to numbers
I have a table that has the following structure:
mysql> describe time_sheet;
+--+---+--+-+
++
| Field| Type | Null | Key | Default|
Extra |
+--+---+--+-+---
Hello list-
I am programing both in Java and PHP. Can anyone point me to sample
code for either on saving an image to a table?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the quick response. The times are stored in TIME format. If I
do the following:
SELECT *, time_out-time_in as job_time from time_sheet;
the job_time column gives me the right time, but is not formatted, for
example:
time_in = 11:00
time_out = 13:15
job_time= 21500
Any pointers?
Hello,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times are stored in a mysql database with 2
columns - time_in and time_out. What I need to do is subtract these to
columns
