# Create Database from JSON

**URL:** <https://discuss.jsonapi.org/t/create-database-from-json/2038>\
**Category:** Uncategorized\
**Created:** [August 28, 2020, 4:49pm UTC](https://discuss.jsonapi.org/t/create-database-from-json/2038 "2020-08-28T16:49:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prajaktasoftware](https://avatars.discourse-cdn.com/v4/letter/p/f19dbf/32.png) [@Prajaktasoftware](https://discuss.jsonapi.org/u/Prajaktasoftware)\
**Post date:** [August 28, 2020, 4:49pm UTC](https://discuss.jsonapi.org/t/create-database-from-json/2038/1 "2020-08-28T16:49:37Z")

</div>

Dear All

can we create database table from this

```auto
 { id: 1, title: "Thomas Williams", label: "Thomas Williams", description: "1", image: "images/photos/t.png" },
        { id: 2, title: "Mary Spencer", label: "Mary Spencer", description: "2", image: "images/photos/m.png" },
        { id: 3, title: "David Kirby", label: "David Kirby", description: "3", image: "images/photos/d.png" },
        { id: 4, title: "Brad Williams", label: "Brad Williams", description: "4", image: "images/photos/b.png" },
        { id: 5, title: "Mike Kirby", label: "Mike Kirby", description: "5", image: "images/photos/m.png" },
        { id: 6, title: "Lynette Maloney", label: "Lynette Maloney", description: "6", image: "images/photos/m.png" },
        { id: 7, title: "Sara Kemp", label: "Sara Kemp", description: "7", image: "images/photos/s.png" },
        { id: 8, title: "Leon Kemp", label: "Leon Kemp", description: "8", image: "images/photos/l.png" },
        { id: 9, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Thomas Williams", label: "Thomas Williams", description: "1", image: "images/photos/t.png" },
        { id: 10, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Mary Spencer", label: "Mary Spencer", description: "2", image: "images/photos/m.png" },
        { id: 11, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "David Kirby", label: "David Kirby", description: "3", image: "images/photos/d.png" },
        { id: 12, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Brad Williams", label: "Brad Williams", description: "4", image: "images/photos/b.png" },
        { id: 13, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Mike Kirby", label: "Mike Kirby", description: "5", image: "images/photos/m.png" },
        { id: 14, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Lynette Maloney", label: "Lynette Maloney", description: "6", image: "images/photos/m.png" },
        { id: 15, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Sara Kemp", label: "Sara Kemp", description: "7", image: "images/photos/s.png" },
        { id: 16, parents: [1, 2, 3, 4, 5, 6, 7, 8], title: "Leon Kemp", label: "Leon Kemp", description: "8", image: "images/photos/l.png" }

```

This json generates following family tree

[basicprimitives.com](http://basicprimitives.com)

Basic Primitives Diagrams

Can i create database from this JSON  
how can i do it

Reason I need this:  
this is hard coded JSON data file  
In reality ,  
I want to create from database

to do this,  
if i know the reverse of this(JSON) i.e. database table structure ,  
from database table this JSOn can be generated easily

I am using MYSQL database

advise whether I should some other database