Kan layi JSON Zuwa SQL Converter

Canjawar JSON Zuwa SQL tana taimaka muku canza JSON zuwa SQL akan layi.

JSON zuwa SQL mai juyawa mafi sauƙi

Wannan kayan aikin kan layi kyauta yana ba ku damar canza fayil ɗin JSON zuwa fayil ɗin SQL. Kawai liƙa JSON ɗinku a cikin fom ɗin da ke ƙasa kuma nan take za ta canza zuwa SQL Babu buƙatar saukewa ko shigar da kowace software. Kyauta

Kayan aiki menene JSON zuwa SQL Converter?

Wannan JSON zuwa SQL mai juyawa yana canza bayanan JSON da fayiloli zuwa bayanan SQL da fayiloli. Wannan mai jujjuya yana ba da damar tsara shigarwar JSON da fitarwa SQL Hakanan yana karɓar fayilolin JSON tare da haruffan ginshiƙi na al'ada da haruffan faɗin filin. Yana goyan bayan layukan sharhi kuma kuna iya yin watsi da layukan da ba komai ba na tilas. Hakanan zaka iya canza wurare nawa don amfani da su a cikin fitarwar SQL.

Yadda ake Canza JSON zuwa SQL?

Mataki 1: Zaɓi shigarwar ku. Shigar da Bayanai.
Mataki 2: Zaɓi zaɓin fitarwa (na zaɓi) Zaɓuɓɓukan fitarwa.
Mataki 3: Samar da fitarwa.

Misalai masu juyawa JSON zuwa SQL

JSON

[
    {
        "pin": "0001",
        "time": "1524810082"
    },
    {
        "pin": "0002",
        "time": "1524810082"
    },
    {
        "pin": "0003",
        "time": "1524810082"
    },
    {
        "pin": "0004",
        "time": "1524810082"
    }
]

SQL

/* INSERT QUERY NO: 1 */
INSERT INTO table_name (pin, time) VALUES (0001, 1524810082);

/* INSERT QUERY NO: 2 */
INSERT INTO table_name (pin, time) VALUES (0002, 1524810082);

/* INSERT QUERY NO: 3 */
INSERT INTO table_name (pin, time) VALUES (0003, 1524810082);

/* INSERT QUERY NO: 4 */
INSERT INTO table_name (pin, time) VALUES (0004, 1524810082);