Canjawar SQL zuwa CSV akan layi

Mai sauya SQL zuwa CSV mafi sauki

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

Kayan aiki menene SQL zuwa CSV Converter?

Wannan SQL zuwa CSV mai juyawa yana canza bayanan SQL da fayiloli zuwa bayanan CSV da fayiloli. Wannan mai jujjuya yana ba da damar keɓance shigarwar SQL da fitarwa CSV Hakanan yana karɓar fayilolin SQL 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 CSV.

Yadda za a Convert SQL zuwa CSV?

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.

SQL Zuwa Misalin CSV

Bayanan shigarwa

CREATE TABLE peoples(
    id INTEGER PRIMARY KEY,
    name CHAR(20),
    age CHAR(2)
);

INSERT INTO peoples VALUES (1, 'name 1', '22');
INSERT INTO peoples VALUES (2, 'name 2', '33');
INSERT INTO peoples VALUES (3, 'name 3', '44');
INSERT INTO peoples VALUES (4, 'name 4', '55');

SELECT * FROM peoples

Bayanan fitarwa

id,name,age
1,name 1,22
2,name 2,33
3,name 3,44
4,name 4,55