{"id":32684,"date":"2020-04-18T22:09:58","date_gmt":"2020-04-18T22:09:58","guid":{"rendered":"https:\/\/www.labeljoy.com\/?page_id=32684"},"modified":"2020-04-18T22:10:17","modified_gmt":"2020-04-18T22:10:17","slug":"chargement-de-donnes-via-une-requte-sql","status":"publish","type":"page","link":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-via-une-requte-sql\/","title":{"rendered":"Chargement de donn&eacute;es via une requ&ecirc;te SQL"},"content":{"rendered":"<div id=\"help-guide\"><!-- lj6_2584.htm -->\n<!--<link href=\"styles.css\" rel=\"stylesheet\" type=\"text\/css\" \/>-->\n<p class=\"title\">Chargement de donn&eacute;es via une requ&ecirc;te SQL<\/p>\n<p>Le langage SQL (<em>langage de requ&ecirc;te structur&eacute;<\/em>)<strong>&nbsp;est pris en charge par la majorit&eacute; des applications<\/strong>&nbsp;<strong>de gestion de donn&eacute;es. <br> Labeljoy prend en charge l'utilisation de requ&ecirc;tes SQL<\/strong>&nbsp;pour vous permettre de d&eacute;finir de mani&egrave;re personnalis&eacute;e le set de donn&eacute;es que vous souhaitez utiliser dans vos travaux d'impression.<br> Labeljoy permet l'utilisation de requ&ecirc;tes SQL pour les sources de donn&eacute;es qui le prennent en charge.<\/p>\n<p class=\"note\"><strong>Exemple <\/strong>:<br> Supposons que vous souhaitiez charger un set d'adresses &agrave; partir d'une base de donn&eacute;es qui comprend une table <em>ADDRESS<\/em>&nbsp;compos&eacute;e des champs typiques trouv&eacute;s dans ce type d'application, une requ&ecirc;te SQL similaire &agrave; la suivante peut &ecirc;tre utilis&eacute; :<br> <br> <span style='color:#003399'>SELECT last_name, first_name, address, city, zip, state, country<br> FROM ADDRESS<br> WHERE first_name LIKE 'JO%'<br> AND city = 'PHOENIX'<br> ORDER BY first_name, zip<\/span><br> <br> La requ&ecirc;te pr&eacute;c&eacute;dente chargera &agrave; partir de la table ADDRESS les champs last_name, first_name, address, city, zip, state and pays de tous les enregistrements dont le champ du pr&eacute;nom commence par JO (Johnson, John, Joel, etc.) et le champ ville d&eacute;fini sur Phoenix. Le set d'enregistrements r&eacute;sultant sera tri&eacute; par nom de famille, puis par code postal.<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":12,"featured_media":0,"parent":32494,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"page-template-left-sidebar.php","meta":{"inline_featured_image":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":{"0":"post-32684","1":"page","2":"type-page","3":"status-publish","5":"infinite-scroll-item"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/comments?post=32684"}],"version-history":[{"count":1,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32684\/revisions"}],"predecessor-version":[{"id":32685,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32684\/revisions\/32685"}],"up":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32494"}],"wp:attachment":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/media?parent=32684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}