Skip to content

Instantly share code, notes, and snippets.

@csalgueiro
Created October 30, 2013 11:17
Show Gist options
  • Select an option

  • Save csalgueiro/7230963 to your computer and use it in GitHub Desktop.

Select an option

Save csalgueiro/7230963 to your computer and use it in GitHub Desktop.
insertar o actualizar valores multiples
INSERT INTO contents_languages (
id_content,
id_language,
friendly,
title,
abstract,
text,
place
)
VALUES
(29,'es','prueba_uploads','prueba uploads...','Nullam ','<div>Lorem ipsum dolor sit </div>','Lugar'),
(29, 'en', '_', '', '', '', ''),
(29, 'fr', '_', '', '', '', '')
ON DUPLICATE KEY UPDATE
friendly = VALUES(friendly),
title = VALUES(title),
abstract = VALUES(abstract),
text = VALUES(text),
place = VALUES(place);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment