All pastes #984653 Raw Edit

Someone

public text v1 · immutable
·published 2008-04-14 13:52 UTC
rendered paste body
mysql> select n.email, n.type from NWR_Database n, CandidatesList c 
    -> where n.email = c.email and 
    -> n.type = 'CONTRACT' 
    -> or n.type = 'ADHOC CONTRACT'
    -> and 
    -> c.preference = 'SAP' 
    -> OR c.preference = 'ORACLE' 
    -> OR c.preference = 'ORACLE CLINICALS' 
    -> OR c.preference = 'ORACLE DBA' 
    -> OR Preference = 'ORACLE DEVELOPER' 
    -> OR c.preference = 'ORACLE FINANCIALS' 
    -> OR c.preference = 'ERP' 
    -> OR c.preference = 'ERP/CRM/BAAN/PSOFT/JDE' 
    -> OR c.preference = 'CRM' 
    -> OR c.preference = 'UNIX' 
    -> OR c.preference = 'UNIX ADMINISTRATOR' 
    -> OR c.preference = 'SIEBEL';
mysql: Out of memory (Needed 3616652 bytes)
ERROR 2008 (HY000): MySQL client ran out of memory