データベースをエクスポートする

CodeGen
CSV
CSV for MS Excel
JSON
LaTex
MediaWiki Table
Microsoft Word 2000
OpenDocument Spreadsheet
OpenDocument Text
PDF
PHP array
SQL
Texy! text
YAML

-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- ホスト: localhost
-- 生成日時: 2021-07-06 11:54:37
-- サーバのバージョン： 8.0.25
-- PHP のバージョン: 8.0.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- データベース: `personal`
--
CREATE DATABASE IF NOT EXISTS `personal` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `personal`;

-- --------------------------------------------------------

--
-- テーブルの構造 `friends`
--

CREATE TABLE `friends` (
  `id` int NOT NULL,
  `name` varchar(20) NOT NULL,
  `age` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- テーブルのデータのダンプ `friends`
--

INSERT INTO `friends` (`id`, `name`, `age`) VALUES
(1, 'Suzuki', 27),
(2, 'Takahashi', 21),
(3, 'Honda', 34),
(4, 'Endou', 18),
(5, 'Kojima', 25),
(6, 'Yasuda', 40);

-- --------------------------------------------------------

--
-- テーブルの構造 `works`
--

CREATE TABLE `works` (
  `id` int NOT NULL,
  `name` varchar(20) NOT NULL,
  `company` varchar(20) NOT NULL,
  `old` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- テーブルのデータのダンプ `works`
--

INSERT INTO `works` (`id`, `name`, `company`, `old`) VALUES
(1, 'Yamaoka', 'Yama Inc.', 34),
(2, 'Uchiyama', 'ABC Inc.', 28),
(3, 'Takahashi', 'Moter Inc.', 40);

--
-- ダンプしたテーブルのインデックス
--

--
-- テーブルのインデックス `friends`
--
ALTER TABLE `friends`
  ADD PRIMARY KEY (`id`);

--
-- テーブルのインデックス `works`
--
ALTER TABLE `works`
  ADD PRIMARY KEY (`id`);

--
-- ダンプしたテーブルの AUTO_INCREMENT
--

--
-- テーブルの AUTO_INCREMENT `friends`
--
ALTER TABLE `friends`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- テーブルの AUTO_INCREMENT `works`
--
ALTER TABLE `works`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

"id","name","age"
"1","Suzuki","27"
"2","Takahashi","21"
"3","Honda","34"
"4","Endou","18"
"5","Kojima","25"
"6","Yasuda","40"
"id","name","company","old"
"1","Yamaoka","Yama Inc.","34"
"2","Uchiyama","ABC Inc.","28"
"3","Takahashi","Moter Inc.","40"

[
{"type":"header","version":"5.1.1","comment":"Export to JSON plugin for PHPMyAdmin"},
{"type":"database","name":"personal"},
{"type":"table","name":"friends","database":"personal","data":
[
{"id":"1","name":"Suzuki","age":"27"},
{"id":"2","name":"Takahashi","age":"21"},
{"id":"3","name":"Honda","age":"34"},
{"id":"4","name":"Endou","age":"18"},
{"id":"5","name":"Kojima","age":"25"},
{"id":"6","name":"Yasuda","age":"40"}
]
}
,{"type":"table","name":"works","database":"personal","data":
[
{"id":"1","name":"Yamaoka","company":"Yama Inc.","old":"34"},
{"id":"2","name":"Uchiyama","company":"ABC Inc.","old":"28"},
{"id":"3","name":"Takahashi","company":"Moter Inc.","old":"40"}
]
}
]