Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 11th, 2012  |  syntax: SQL  |  size: 0.92 KB  |  hits: 18  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. INSERT INTO summaries
  2.  
  3.   (PublicId, Text, Content, DateCreated, DateModified,
  4.  
  5.   OwnerId, LANGUAGE, IsPublished, DatePublished)
  6.  
  7.   VALUES
  8.  
  9.   ( NAME_CONST('$publicId',_utf8'b92fa4c7-a7d9-48ff-af7a-82121f1eec3f' COLLATE 'utf8_general_ci'),  NAME_CONST('$text',_utf8'BLOM Development Bank Best Islamic Bank of Lebanon' COLLATE 'utf8_general_ci'),  NAME_CONST('$content',_utf8'BLOM Development Bank has won the Best Islamic Bank in Lebanon for 2012, from Global Finance Magazine, awards to be distributed in Tokyo City.' COLLATE 'utf8_general_ci'), COALESCE( NAME_CONST('$dateCreated',_binary'2012-05-16 17:16:57' COLLATE 'binary'), now()),
  10.  
  11.   COALESCE( NAME_CONST('$dateCreated',_binary'2012-05-16 17:16:57' COLLATE 'binary'), now()),
  12.  
  13.    NAME_CONST('$ownerId',12498),  NAME_CONST('$language',1),  NAME_CONST('$isPublished',_binary'' COLLATE 'binary'),  NAME_CONST('$datePublished',_binary'2012-05-15' COLLATE 'binary'))
  14. /*!*/;
create a new version of this paste RAW Paste Data