mysql_connect() is deprecated function. Try using mysql_real_connect().
I've used and haven't experience any problems with it.
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql
_real_connect
Sean
-Original Message-
From: Rahul Amaram-RollNo.286 [mailto:rah
Hi,
In a previous job I had the (mis)fortune to develop software exclusively on
DB2. While doing so I would often use FETCH to examine a certain number of
records. Example:
SELECT * from table FETCH FIRST 10 ROWS ONLY.
When I use this particular syntax in any mysql interface (I've used 2) I g
I seem to have run into a rather peculiar problem. I was attempting to load
data into a table from a file. I checked with the online documentation and
found the following syntax:
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
I used this format exactly (with my own file and table names of co
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think that might be too convoluted for your needs.
-
