{"id":189790,"date":"2023-02-21T15:48:17","date_gmt":"2023-02-21T15:48:17","guid":{"rendered":"https:\/\/datascientest.com\/?p=189790"},"modified":"2023-11-09T13:53:57","modified_gmt":"2023-11-09T13:53:57","slug":"ouvrir-un-fichier-sql-tutoriel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel","title":{"rendered":"Ouvrir un fichier SQL : Tutoriel complet"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"189790\" class=\"elementor elementor-189790\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b54ee27 e-flex e-con-boxed e-con\" data-id=\"b54ee27\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-010eeba elementor-widget elementor-widget-heading\" data-id=\"010eeba\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Les fichiers SQL (Structured Query Language) contiennent du code d\u00e9finissant la structure et le contenu d\u2019une base de donn\u00e9es. Ouvrir un fichier SQL permet d\u2019ex\u00e9cuter du code et de modifier le contenu de cette base de donn\u00e9es. Le fichier SQL contient \u00e9galement des instructions pour cr\u00e9er le contenu, ins\u00e9rer, supprimer, fractionner ou mettre \u00e0 jour des donn\u00e9es. Ouvrir un fichier SQL est rapide en utilisant MySQL ou un \u00e9diteur de texte.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b5bd866 e-flex e-con-boxed e-con\" data-id=\"b5bd866\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45e456e elementor-widget elementor-widget-heading\" data-id=\"45e456e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utiliser MySQL ou un \u00e9diteur de texte pour ouvrir un fichier SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-825f1b6 elementor-widget elementor-widget-text-editor\" data-id=\"825f1b6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Pour ouvrir un <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">fichier SQL<\/a><\/span><span style=\"font-weight: 400;\">, vous devez poss\u00e9der un logiciel adapt\u00e9. Pour ce faire, ce ne sont pas les choix qui manquent ! La solution \u00e0 privil\u00e9gier reste \u00e9videmment d\u2019<\/span><b>installer<\/b> <a href=\"https:\/\/datascientest.com\/mysql-tout-comprendre\">MySQL<\/a><span style=\"font-weight: 400;\"> de mani\u00e8re s\u00e9curis\u00e9e. La seconde solution \u00e0 privil\u00e9gier est d\u2019ouvrir ce type de fichier \u00e0 l\u2019aide d\u2019un \u00e9diteur de texte : Notepad pour un ordinateur Windows et TextEdit pour un Mac.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">N\u00e9anmoins, il existe de nombreuses solutions sur le march\u00e9 pour ouvrir un fichier SQL :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">RazorSQL<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DatabaseSpy<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Microsoft Visual Studio<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sublime Text<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FileMaker Pro<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">BBEdit<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SQLEditor<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Et bien d\u2019autres encore.\u00a0<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec2ff86 elementor-widget elementor-widget-text-editor\" data-id=\"ec2ff86\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Choisissez le logiciel que vous connaissez le mieux ou que vous avez d\u00e9j\u00e0 install\u00e9 sur votre machine. Pour les experts SQL, notez qu\u2019il est \u00e9galement possible d\u2019ouvrir un fichier SQL et de visualiser le contenu de la <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">base de donn\u00e9es<\/a><\/span><span style=\"font-weight: 400;\">\u00a0avec un logiciel comme phpMyAdmin ou SQL Server Management Studio.<\/span><\/p><p><span style=\"font-weight: 400;\">Une fois le logiciel install\u00e9, il vous suffit d\u2019effectuer un clic droit, choisir \u00ab\u00a0Ouvrir avec\u00a0\u00bb puis s\u00e9lectionner l\u2019application de votre choix.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-319c4ba elementor-widget elementor-widget-image\" data-id=\"319c4ba\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"874\" height=\"511\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql1.jpg\" class=\"attachment-full size-full wp-image-189796\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql1.jpg 874w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql1-300x175.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql1-768x449.jpg 768w\" sizes=\"(max-width: 874px) 100vw, 874px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a22134 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9a22134\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Tout apprendre de SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-114db34 e-flex e-con-boxed e-con\" data-id=\"114db34\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6528c5a elementor-widget elementor-widget-heading\" data-id=\"6528c5a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment v\u00e9rifier l\u2019\u00e9tat de son fichier SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6dc5970 elementor-widget elementor-widget-text-editor\" data-id=\"6dc5970\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si votre fichier ne s\u2019ouvre pas, commencez par v\u00e9rifier que votre fichier comporte bien <\/span><b>l\u2019extension \u00ab\u00a0.sql\u00a0\u00bb<\/b><span style=\"font-weight: 400;\">. Si ce n\u2019est pas le cas, t\u00e9l\u00e9chargez de nouveau votre document. Si ce document a \u00e9t\u00e9 transmis par un tiers, demandez-lui de vous fournir une copie de ce document avec la bonne extension.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Le fichier en question peut \u00eatre contamin\u00e9 par un virus. Effectuez une <\/span><b>v\u00e9rification \u00e0 l\u2019aide d\u2019un antivirus ou d\u2019un syst\u00e8me d\u2019analyse de fichier<\/b><span style=\"font-weight: 400;\">. Si le fichier a \u00e9t\u00e9 partiellement t\u00e9l\u00e9charg\u00e9, est endommag\u00e9 ou corrompu, il est pr\u00e9f\u00e9rable de demander un nouveau fichier SQL.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1d5a9e1 e-flex e-con-boxed e-con\" data-id=\"1d5a9e1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9dafbea elementor-widget elementor-widget-heading\" data-id=\"9dafbea\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment v\u00e9rifier la mise \u00e0 jour du logiciel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fbf1c0e elementor-widget elementor-widget-text-editor\" data-id=\"fbf1c0e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Enfin, le dernier point pour assurer l\u2019ouverture des fichiers Structured Query Language Data Format est de <\/span><b>v\u00e9rifier la version du logiciel install\u00e9<\/b><span style=\"font-weight: 400;\">. Quelle que soit la solution choisie pour l\u2019ouverture de votre fichier, v\u00e9rifiez que l\u2019application est bien \u00e0 jour.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">De m\u00eame, pensez \u00e0 d\u00e9finir ce logiciel comme l\u2019application par d\u00e9faut pour l\u2019ouverture d\u2019un fichier SQL. Pour ce faire, cochez simplement la case \u00ab\u00a0Toujours utiliser ce programme pour ouvrir la bo\u00eete de fichiers SQL\u00a0\u00bb sur Windows ou \u00ab\u00a0cette modification sera appliqu\u00e9e \u00e0 tous les fichiers avec l\u2019extension SQL\u00a0\u00bb sur Mac.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fc390c2 e-flex e-con-boxed e-con\" data-id=\"fc390c2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1874b6e elementor-widget elementor-widget-heading\" data-id=\"1874b6e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36f6c0b elementor-widget elementor-widget-text-editor\" data-id=\"36f6c0b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b>Il est possible d\u2019ouvrir un fichier SQL avec un \u00e9diteur de texte ou un outil comme MySQL<\/b><span style=\"font-weight: 400;\">. Si le fichier ne s\u2019ouvre pas, pensez \u00e0 v\u00e9rifier les mises \u00e0 jour de votre outil, l\u2019extension \u00ab\u00a0.sql\u00a0\u00bb et le bon \u00e9tat du fichier gr\u00e2ce \u00e0 un logiciel antivirus. Vous pouvez toujours essayer de l\u2019ouvrir \u00e0 l\u2019aide d\u2019un autre logiciel de la liste ci-dessus.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a4e63c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"8a4e63c\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9marrer une formation sur SQL <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-26be8f3 e-flex e-con-boxed e-con\" data-id=\"26be8f3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5390776 elementor-widget elementor-widget-html\" data-id=\"5390776\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment v\u00e9rifier la mise \u00e0 jour du logiciel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Enfin, le dernier point pour assurer l\u2019ouverture des fichiers Structured Query Language Data Format est de v\u00e9rifier la version du logiciel install\u00e9. Quelle que soit la solution choisie pour l\u2019ouverture de votre fichier, v\u00e9rifiez que l\u2019application est bien \u00e0 jour.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment v\u00e9rifier l\u2019\u00e9tat de son fichier SQL ?\u200b\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Si votre fichier ne s\u2019ouvre pas, commencez par v\u00e9rifier que votre fichier comporte bien l\u2019extension \\\".sql\\\". Si ce n\u2019est pas le cas, t\u00e9l\u00e9chargez de nouveau votre document. Si ce document a \u00e9t\u00e9 transmis par un tiers, demandez-lui de vous fournir une copie de ce document avec la bonne extension.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Les fichiers SQL (Structured Query Language) contiennent du code d\u00e9finissant la structure et le contenu d\u2019une base de donn\u00e9es. Ouvrir un fichier SQL permet d\u2019ex\u00e9cuter du code et de modifier le contenu de cette base de donn\u00e9es. Le fichier SQL contient \u00e9galement des instructions pour cr\u00e9er le contenu, ins\u00e9rer, supprimer, fractionner ou mettre \u00e0 jour [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":189792,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ouvrir un fichier SQL : Tutoriel complet | DataScientest.com<\/title>\n<meta name=\"description\" content=\"Comment ouvrir rapidement un fichier SQL ? Avec MySQL ou tout autre \u00e9diteur de texte. D\u00e9couvrez comment faire.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ouvrir un fichier SQL : Tutoriel complet\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-21T15:48:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:53:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1060\" \/>\n\t<meta property=\"og:image:height\" content=\"503\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel\",\"url\":\"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel\",\"name\":\"Ouvrir un fichier SQL : Tutoriel complet | DataScientest.com\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-02-21T15:48:17+00:00\",\"dateModified\":\"2023-11-09T13:53:57+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"Comment ouvrir rapidement un fichier SQL ? Avec MySQL ou tout autre \u00e9diteur de texte. D\u00e9couvrez comment faire.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Ouvrir un fichier SQL : Tutoriel complet | DataScientest.com","description":"Comment ouvrir rapidement un fichier SQL ? Avec MySQL ou tout autre \u00e9diteur de texte. D\u00e9couvrez comment faire.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel","og_locale":"fr_FR","og_type":"article","og_title":"Ouvrir un fichier SQL : Tutoriel complet","og_url":"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-02-21T15:48:17+00:00","article_modified_time":"2023-11-09T13:53:57+00:00","og_image":[{"width":1060,"height":503,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/02\/ouvrir-fichier-sql.jpg","type":"image\/jpeg"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel","url":"https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel","name":"Ouvrir un fichier SQL : Tutoriel complet | DataScientest.com","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-02-21T15:48:17+00:00","dateModified":"2023-11-09T13:53:57+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"Comment ouvrir rapidement un fichier SQL ? Avec MySQL ou tout autre \u00e9diteur de texte. D\u00e9couvrez comment faire.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/ouvrir-un-fichier-sql-tutoriel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/189790"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=189790"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/189790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/189792"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=189790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=189790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=189790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}