SQL To JSON Converter

Online SQL To JSON Example

Below is an example of the original SQL To JSON and the result.

/**
 * Websites
 */
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `websites`
-- ----------------------------
DROP TABLE IF EXISTS `websites`;
CREATE TABLE `websites` (
  `code` char(2) NOT NULL COMMENT 'Continent code',
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of websites
-- ----------------------------
INSERT INTO `websites` VALUES ('PK', 'Pakainfo');
INSERT INTO `websites` VALUES ('YT', 'Yttags');
INSERT INTO `websites` VALUES ('AS', 'Infinityknow');
INSERT INTO `websites` VALUES ('WX', 'Webix');
INSERT INTO `websites` VALUES ('GP', 'guestpostingsites');
INSERT INTO `websites` VALUES ('IP', 'thebestiptv');
INSERT INTO `websites` VALUES ('IS', 'itsolutionstuck');
INSERT INTO `websites` VALUES ('??', NULL);

And an example of how the online SQL To JSON works.

{
  "websites": [
    {
      "code": "PK",
      "name": "Pakainfo"
    },
    {
      "code": "YT",
      "name": "Yttags"
    },
    {
      "code": "AS",
      "name": "Infinityknow"
    },
    {
      "code": "WX",
      "name": "Webix"
    },
    {
      "code": "GP",
      "name": "guestpostingsites"
    },
    {
      "code": "IP",
      "name": "thebestiptv"
    },
    {
      "code": "IS",
      "name": "itsolutionstuck"
    },
    {
      "code": "??",
      "name": null
    }
  ]
}

How to use Yttags's SQL To JSON Converter?

• Step 1: Select the Tool

• Step 2: Upload your JSON file by clicking the Choose File (or paste your SQL text into the textbox And Press The Convert Button And Check Your SQL To JSON Converter Result

1. Download the resulting CSV file when prompted
2. Open your CSV file in Excel (or Open Office)