Re: whats wrong with my where clause?
Posted by:
Jim Babcock
Date: September 08, 2004 01:19PM
never-bloody-mind :)
the ticks a actually in the database because the script I wrote to populate the database uses them when building the csv... which works in Oracle (and access, I think)) but I guess not MySQL.
select * from fs where machine = '''CDS''';
Does the job because the csv is being built as:
'2004-08-04 11:00:00','CDS','1','/home2/spmaster/ram'
*grumble* guess I'll have to rebuilt the whole database :(
Subject
Written By
Posted
September 08, 2004 10:35AM
Re: whats wrong with my where clause?
September 08, 2004 01:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.