TSV Zuwa SQL Converter yana taimaka muku canza TSV zuwa SQL akan layi.
Mai sauya TSV zuwa SQL mafi sauki
Wannan kayan aiki na kan layi kyauta yana ba ku damar canza fayil ɗin TSV zuwa fayil ɗin SQL. Kawai liƙa TSV ɗ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 TSV zuwa SQL Converter?
Wannan mai canza TSV zuwa SQL yana canza bayanan TSV da fayiloli zuwa bayanan SQL da fayiloli. Wannan mai jujjuya yana ba da damar keɓance shigarwar TSV da fitarwa SQL Hakanan yana karɓar fayilolin TSV 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 za a Convert TSV 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 TSV zuwa SQL
TSV
a b c
1 2 3
4 5 6SQL
/* INSERT QUERY NO: 1 */
INSERT INTO table_name (a, b, c) VALUES (1, 2, 3);
/* INSERT QUERY NO: 2 */
INSERT INTO table_name (a, b, c) VALUES (4, 5, 6);
/* UPDATE QUERY NO: 1 */
UPDATE table_name SET a = 1, b = 2, c = 3 WHERE a = 1;
/* UPDATE QUERY NO: 2 */
UPDATE table_name SET a = 4, b = 5, c = 6 WHERE a = 4;/* DELETE QUERY NO: 1 */
DELETE FROM table_name WHERE a = 1;
/* DELETE QUERY NO: 2 */
DELETE FROM table_name WHERE a = 4;