SQL olarak da bilinen Yap\u0131land\u0131r\u0131lm\u0131\u015f Sorgu Dili, tablolara veri ekleme konusunda b\u00fcy\u00fck esneklik sa\u011flar. \u00d6rne\u011fin, VALUES anahtar s\u00f6zc\u00fc\u011f\u00fcyle tek tek veri sat\u0131rlar\u0131n\u0131 belirtebilir, SELECT sorgular\u0131yla mevcut tablolardan t\u00fcm veri k\u00fcmelerini kopyalayabilir ve s\u00fctunlar\u0131, SQL'in bunlara otomatik olarak veri eklemesini sa\u011flayacak \u015fekilde tan\u0131mlayabilirsiniz.<\/p>\n
Bu k\u0131lavuzda, bu y\u00f6ntemlerin her biriyle tablolara veri eklemek i\u00e7in INSERT INTO SQL s\u00f6zdiziminin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 inceleyece\u011fiz.<\/p>\n
Bu k\u0131lavuzu takip etmek i\u00e7in, SQL kullanan bir t\u00fcr ili\u015fkisel veritaban\u0131 y\u00f6netim sistemine (RDBMS) sahip bir bilgisayara ihtiyac\u0131n\u0131z olacak. Bu k\u0131lavuzdaki talimatlar ve \u00f6rnekler a\u015fa\u011f\u0131daki ortam kullan\u0131larak do\u011frulanm\u0131\u015ft\u0131r:<\/p>\n
Ayr\u0131ca, veri ekleme al\u0131\u015ft\u0131rmas\u0131 yapabilece\u011finiz bir veritaban\u0131 ve tabloya da ihtiyac\u0131n\u0131z olacak. Bunlara sahip de\u011filseniz, bu k\u0131lavuzda \u00f6rneklerde kullan\u0131lan veritaban\u0131 ve tablonun nas\u0131l olu\u015fturulaca\u011f\u0131 hakk\u0131nda daha fazla bilgi i\u00e7in MySQL'e Ba\u011flanma ve \u00d6rnek Veritaban\u0131 Olu\u015fturma b\u00f6l\u00fcm\u00fcn\u00fc okuyabilirsiniz.<\/p>\n
SQL veritaban\u0131 sisteminiz uzak bir sunucuda \u00e7al\u0131\u015f\u0131yorsa, yerel makinenizden sunucunuza SSH ile ba\u011flan\u0131n:<\/p>\n
ssh sammy@your_server_ip\r\n<\/code><\/pre>\n<\/div>\nDaha sonra MySQL sunucusu istemini a\u00e7\u0131n ve Sami'yi MySQL kullan\u0131c\u0131 ad\u0131n\u0131zla de\u011fi\u015ftirin:<\/p>\n
\nmysql -u sammy -p\r\n<\/code><\/pre>\n<\/div>\ninsertDB ad\u0131nda bir veritaban\u0131 olu\u015fturun:<\/p>\n
\nCREATE DATABASE insertDB;<\/code><\/pre>\n<\/div>\nVeritaban\u0131 ba\u015far\u0131yla olu\u015fturulduysa a\u015fa\u011f\u0131daki \u00e7\u0131kt\u0131y\u0131 alacaks\u0131n\u0131z:<\/p>\n
\n\nQuery OK, 1 row affected (0.01 sec)<\/code><\/pre>\n<\/div>\n<\/div>\ninsertDB veritaban\u0131n\u0131 se\u00e7mek i\u00e7in a\u015fa\u011f\u0131daki USE ifadesini \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\nUSE insertDB;\r\n<\/code><\/pre>\n<\/div>\n\nOutput\r\nDatabase changed<\/code><\/pre>\n<\/div>\ninsertDB veritaban\u0131n\u0131 se\u00e7tikten sonra, i\u00e7inde bir tablo olu\u015fturun. \u00d6rne\u011fin, bir fabrikan\u0131z oldu\u011funu ve \u00e7al\u0131\u015fanlar\u0131n\u0131z hakk\u0131nda baz\u0131 bilgileri depolamak i\u00e7in bir tablo olu\u015fturmak istedi\u011finizi varsayal\u0131m. Bu tablo a\u015fa\u011f\u0131daki be\u015f s\u00fctundan olu\u015facakt\u0131r:<\/p>\n
\nisim<\/code>: Her \u00e7al\u0131\u015fan\u0131n ad\u0131, en fazla 30 karakter uzunlu\u011funda varchar veri t\u00fcr\u00fc kullan\u0131larak ifade edilir<\/li>\nkonum<\/code>: Bu s\u00fctun her \u00e7al\u0131\u015fan\u0131n i\u015f unvan\u0131n\u0131 saklar ve bu unvan da yine en fazla 30 karakter olmak \u00fczere varchar veri tipi kullan\u0131larak ifade edilir.<\/li>\ndepartman<\/code>: Her \u00e7al\u0131\u015fan\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 departman, varchar veri tipi kullan\u0131larak ancak en fazla 20 karakter olacak \u015fekilde ifade edilir.<\/li>\nsaatlik \u00fccret<\/code>: Her \u00e7al\u0131\u015fan\u0131n saatlik \u00fccretini kaydeden s\u00fctun, ondal\u0131k veri t\u00fcr\u00fcn\u00fc kullan\u0131r ve bu s\u00fctundaki de\u011ferler en fazla d\u00f6rt basamak uzunlu\u011fundad\u0131r ve bu basamaklardan ikisi ondal\u0131k noktas\u0131n\u0131n sa\u011f\u0131ndad\u0131r. Bu nedenle, bu s\u00fctunda izin verilen de\u011fer aral\u0131\u011f\u0131 -99,99 ile 99,99 aras\u0131ndad\u0131r.<\/li>\nba\u015flang\u0131\u00e7 tarihi<\/code>: Her \u00e7al\u0131\u015fan\u0131n i\u015fe al\u0131nd\u0131\u011f\u0131 tarih, Tarih veri t\u00fcr\u00fc kullan\u0131larak ifade edilir. Bu t\u00fcrdeki de\u011ferler YYYY-AA-GG bi\u00e7imine uygun olmal\u0131d\u0131r.<\/li>\n<\/ul>\nA\u015fa\u011f\u0131daki be\u015f s\u00fctundan olu\u015fan factoryEmployees adl\u0131 bir tablo olu\u015fturun:<\/p>\n
\nCREATE TABLE factoryEmployees (\r\nname varchar(30),\r\nposition varchar(30),\r\ndepartment varchar(20),\r\nhourlyWage decimal(4,2),\r\nstartDate date\r\n);<\/code><\/pre>\n<\/div>\nArt\u0131k rehberin geri kalan\u0131n\u0131 takip etmeye ve SQL ile veri eklemeyi \u00f6\u011frenmeye haz\u0131rs\u0131n\u0131z.<\/p>\n
Verileri manuel olarak girin<\/h2>\n
SQL'de veri eklemenin genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n
\nINSERT INTO table_name\r\n(column1, column2, . . . columnN)\r\nVALUES\r\n(value1, value2, . . . valueN);<\/code><\/pre>\n<\/div>\nBunu g\u00f6stermek i\u00e7in, factoryEmployees tablosunu tek sat\u0131r veriyle y\u00fcklemek \u00fczere a\u015fa\u011f\u0131daki INSERT INTO ifadesini \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\nINSERT INTO factoryEmployees\r\n(name, position, department, hourlyWage, startDate)\r\nVALUES\r\n('Agnes', 'thingamajig foreman', 'management', 26.50, '2017-05-01');<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 1 row affected (0.00 sec)<\/code><\/pre>\n<\/div>\n\u0130fade, INSERT INTO anahtar s\u00f6zc\u00fckleriyle ba\u015flar ve ard\u0131ndan verileri eklemek istedi\u011finiz tablonun ad\u0131 gelir. Tablo ad\u0131n\u0131n ard\u0131ndan, ifadenin verileri ekleyece\u011fi s\u00fctunlar\u0131n parantez i\u00e7inde bir listesi gelir. S\u00fctun listesinin ard\u0131ndan ise VALUES anahtar s\u00f6zc\u00fc\u011f\u00fc gelir ve ard\u0131ndan parantez i\u00e7inde ve virg\u00fclle ayr\u0131lm\u0131\u015f bir de\u011fer k\u00fcmesi gelir.<\/p>\n
S\u00fctunlar\u0131 listeleme s\u0131ran\u0131z \u00f6nemli de\u011fil. Girdi\u011finiz de\u011ferlerin s\u0131ras\u0131n\u0131n s\u00fctunlar\u0131n s\u0131ras\u0131yla e\u015fle\u015fmesi gerekti\u011fini unutmamak \u00f6nemlidir. SQL her zaman listelenen ilk s\u00fctuna verilen ilk de\u011feri, sonraki s\u00fctuna ikinci de\u011feri vb. eklemeye \u00e7al\u0131\u015f\u0131r. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki INSERT ifadesi ba\u015fka bir veri sat\u0131r\u0131 ekler, ancak s\u00fctunlar\u0131 farkl\u0131 bir s\u0131rayla listeler:<\/p>\n
\nINSERT INTO factoryEmployees\r\n(department, hourlyWage, startDate, name, position)\r\nVALUES\r\n('production', 15.59, '2018-04-28', 'Jim', 'widget tightener');<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 1 row affected (0.00 sec)<\/code><\/pre>\n<\/div>\nDe\u011ferleri do\u011fru \u015fekilde hizalamazsan\u0131z, SQL verilerinizi yanl\u0131\u015f s\u00fctunlara ekleyebilir. Ayr\u0131ca, de\u011ferlerden herhangi biri s\u00fctunun veri t\u00fcr\u00fcyle \u00e7ak\u0131\u015f\u0131rsa, bu \u00f6rnekte oldu\u011fu gibi bir hata mesaj\u0131 al\u0131rs\u0131n\u0131z:<\/p>\n
\nINSERT INTO factoryEmployees\r\n(name, hourlyWage, position, startDate, department)\r\nVALUES\r\n('Louise', 'doodad tester', 16.50, '2017-05-01', 'quality assurance');<\/code><\/pre>\n<\/div>\n\nOutput\r\nERROR 1366 (HY000): Incorrect decimal value: 'doodad tester' for column 'hourlyWage' at row 1\r\n<\/code><\/pre>\n<\/div>\nBelirtti\u011finiz her s\u00fctun i\u00e7in bir de\u011fer sa\u011flaman\u0131z gerekti\u011fini unutmay\u0131n; ancak yeni bir veri sat\u0131r\u0131 eklerken tablodaki her s\u00fctunu belirtmeniz gerekmez. Sildi\u011finiz s\u00fctunlar\u0131n hi\u00e7birinde bu durumda hataya neden olacak bir k\u0131s\u0131tlama (\u00f6rne\u011fin NOT NULL) olmad\u0131\u011f\u0131 s\u00fcrece, MySQL belirtilmemi\u015f s\u00fctunlara NULL ekleyecektir:<\/p>\n
\nINSERT INTO factoryEmployees\r\n(name, position, hourlyWage)\r\nVALUES\r\n('Harry', 'whatzit engineer', 26.50);<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 1 row affected (0.01 sec)<\/code><\/pre>\n<\/div>\nTablodaki her s\u00fctun i\u00e7in de\u011ferlerin bulundu\u011fu bir sat\u0131r ekleyecekseniz, s\u00fctun adlar\u0131n\u0131 girmenize hi\u00e7 gerek yok. Girdi\u011finiz de\u011ferlerin, tablo tan\u0131m\u0131nda s\u00fctunlar\u0131n tan\u0131mland\u0131\u011f\u0131 s\u0131rayla tutarl\u0131 olmas\u0131 gerekti\u011fini unutmay\u0131n.<\/p>\n
Bu \u00f6rnekte listelenen de\u011ferler, factoryEmployee tablosu i\u00e7in CREATE TABLE ifadesinde s\u00fctunlar\u0131n tan\u0131mland\u0131\u011f\u0131 s\u0131raya g\u00f6re hizalanm\u0131\u015ft\u0131r:<\/p>\n
\nINSERT INTO factoryEmployees\r\nVALUES\r\n('Marie', 'doodad welder', 'production', 27.88, '2018-03-29');\r\n<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 1 row affected (0.00 sec)\r\n<\/code><\/pre>\n<\/div>\nAyr\u0131ca her sat\u0131r\u0131 virg\u00fclle ay\u0131rarak birden fazla kayd\u0131 ayn\u0131 anda ekleyebilirsiniz, \u00f6rne\u011fin:<\/p>\n
\nINSERT INTO factoryEmployees\r\nVALUES\r\n('Giles', 'gizmo inspector', 'quality assurance', 26.50, '2019-08-06'),\r\n('Daphne', 'gizmo presser', 'production', 32.45, '2017-11-12'),\r\n('Joan', 'whatzit analyst', 'quality assurance', 29.00, '2017-04-29');<\/code><\/pre>\n<\/div>\n\nQuery OK, 3 rows affected (0.00 sec)\r\nRecords: 3 Duplicates: 0 Warnings: 0<\/code><\/pre>\n<\/div>\nSELECT ifadeleriyle veri kopyalama<\/h2>\n
Verileri sat\u0131r sat\u0131r belirtmek yerine, bir tablodan birden fazla veri sat\u0131r\u0131n\u0131 kopyalay\u0131p SELECT sorgusuyla ba\u015fka bir tabloya ekleyebilirsiniz.<\/p>\n
Bu t\u00fcr i\u015flemlerin s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n
\nINSERT INTO table_A (col_A1, col_A2, col_A3)\r\nSELECT col_B1, col_B2, col_B3\r\nFROM table_B;<\/code><\/pre>\n<\/div>\nBu \u00f6rnek s\u00f6zdizimi, s\u00fctun listesini VALUES anahtar s\u00f6zc\u00fc\u011f\u00fcyle takip etmek yerine, bir SELECT ifadesiyle devam eder. Bu \u00f6rnek s\u00f6zdizimindeki SELECT ifadesi yaln\u0131zca FROM ifadesini i\u00e7erir, ancak ge\u00e7erli herhangi bir sorgu i\u015fe yarayacakt\u0131r.<\/p>\n
Bunu g\u00f6stermek i\u00e7in, showroomEmployees adl\u0131 yeni bir tablo olu\u015fturmak \u00fczere a\u015fa\u011f\u0131daki CREATE TABLE i\u015flemini \u00e7al\u0131\u015ft\u0131r\u0131n. Bu tablodaki s\u00fctunlar\u0131n adlar\u0131n\u0131n ve veri t\u00fcrlerinin, \u00f6nceki b\u00f6l\u00fcmde kullan\u0131lan factoryEmployees tablosundaki \u00fc\u00e7 s\u00fctunla ayn\u0131 oldu\u011funu unutmay\u0131n:<\/p>\n
\nCREATE TABLE showroomEmployees (\r\nname varchar(30),\r\nhourlyWage decimal(4,2),\r\nstartDate date\r\n);<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 0 rows affected (0.02 sec)<\/code><\/pre>\n<\/div>\nArt\u0131k bu yeni tabloyu, daha \u00f6nce INSERT INTO ifadesine bir SELECT sorgusu ekleyerek olu\u015fturulan factoryEmployees tablosundaki baz\u0131 verilerle y\u00fckleyebilirsiniz.<\/p>\n
SELECT sorgusu hedef tablodaki s\u00fctunlarla ayn\u0131 s\u0131rada ayn\u0131 say\u0131da s\u00fctun d\u00f6nd\u00fcr\u00fcyorsa ve bunlar\u0131n e\u015fle\u015fen veri t\u00fcrleri varsa, INSERT INTO ifadesinden s\u00fctun listesini \u00e7\u0131karabilirsiniz:<\/p>\n
\nINSERT INTO showroomEmployees\r\nSELECT\r\nfactoryEmployees.name,\r\nfactoryEmployees.hourlyWage,\r\nfactoryEmployees.startDate\r\nFROM factoryEmployees\r\nWHERE name = 'Agnes';<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 1 row affected (0.01 sec)\r\nRecords: 1 Duplicates: 0 Warnings: 0<\/code><\/pre>\n<\/div>\nBu i\u015flemdeki SELECT ifadesi, sorgunun yaln\u0131zca ad s\u00fctununda Agnes de\u011feri bulunan factoryEmployees tablosundaki sat\u0131rlar\u0131 d\u00f6nd\u00fcrmesine neden olan bir WHERE ifadesi i\u00e7erir. Kaynak tabloda yaln\u0131zca bir sat\u0131r oldu\u011fundan, yaln\u0131zca bu sat\u0131r showroomEmployees tablosuna kopyalan\u0131r.<\/p>\n
Bunu do\u011frulamak i\u00e7in, showroom employees tablosundaki her kayd\u0131 d\u00f6nd\u00fcren a\u015fa\u011f\u0131daki sorguyu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\nSELECT * FROM showroomEmployees;\r\n<\/code><\/pre>\n<\/div>\n\nOutput\r\n+-------+------------+------------+\r\n| name | hourlyWage | startDate |\r\n+-------+------------+------------+\r\n| Agnes | 26.50 | 2017-05-01 |\r\n+-------+------------+------------+\r\n1 row in set (0.00 sec)<\/code><\/pre>\n<\/div>\nKaynak tablodan birden fazla sat\u0131r d\u00f6nd\u00fcren herhangi bir sorguyla birden fazla veri sat\u0131r\u0131 ekleyebilirsiniz. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki ifadedeki sorgu, factoryEmployees veritaban\u0131nda name s\u00fctunundaki de\u011fer J ile ba\u015flamayan t\u00fcm kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr:<\/p>\n
\nINSERT INTO showroomEmployees\r\nSELECT\r\nfactoryEmployees.name,\r\nfactoryEmployees.hourlyWage,\r\nfactoryEmployees.startDate\r\nFROM factoryEmployees\r\nWHERE name NOT LIKE 'J%';<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 5 rows affected (0.01 sec)\r\nRecords: 5 Duplicates: 0 Warnings: 0<\/code><\/pre>\n<\/div>\nShowroom employees tablosundaki t\u00fcm kay\u0131tlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in \u015fu sorguyu tekrar \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\nSELECT * FROM showroomEmployees;\r\n<\/code><\/pre>\n<\/div>\n\n+--------+------------+------------+\r\n| name | hourlyWage | startDate |\r\n+--------+------------+------------+\r\n| Agnes | 26.50 | 2017-05-01 |\r\n| Agnes | 26.50 | 2017-05-01 |\r\n| Harry | 26.50 | NULL |\r\n| Marie | 27.88 | 2018-03-29 |\r\n| Giles | 26.50 | 2019-08-06 |\r\n| Daphne | 32.45 | 2017-11-12 |\r\n+--------+------------+------------+\r\n6 rows in set (0.00 sec)\r\n<\/code><\/pre>\n<\/div>\nAd s\u00fctununda Agnes ile ilgili iki \u00f6zde\u015f sat\u0131r oldu\u011funu fark edin. SELECT kullanan bir INSERT INTO ifadesini her \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, SQL sorgu sonu\u00e7lar\u0131n\u0131 yeni bir veri k\u00fcmesi olarak i\u015fler. Tablonuza belirli k\u0131s\u0131tlamalar getirmedi\u011finiz veya daha hassas sorgular olu\u015fturmad\u0131\u011f\u0131n\u0131z s\u00fcrece, bu t\u00fcr veriler ekledi\u011finizde veritaban\u0131n\u0131z\u0131n yinelenen kay\u0131tlarla y\u00fcklenmesini engelleyecek hi\u00e7bir \u015fey yoktur.<\/p>\n
Bilgileri otomatik olarak ekle<\/h2>\n
Bir tablo olu\u015ftururken, RDBMS'nin bunlar\u0131 otomatik olarak verilerle doldurmas\u0131na neden olacak belirli nitelikleri s\u00fctunlara uygulayabilirsiniz.<\/p>\n
\u00d6rnek olarak, interns adl\u0131 bir tablo tan\u0131mlamak i\u00e7in a\u015fa\u011f\u0131daki ifadeyi \u00e7al\u0131\u015ft\u0131r\u0131n. Bu, \u00fc\u00e7 s\u00fctunlu interns adl\u0131 bir tablo olu\u015fturur. Bu \u00f6rnekteki ilk s\u00fctun olan internID, int t\u00fcr\u00fcnde verileri tutar. Ancak, AUTO_INCREMENT \u00f6zniteli\u011fini de i\u00e7erdi\u011fini unutmay\u0131n. Bu \u00f6znitelik, SQL'in her yeni sat\u0131r i\u00e7in varsay\u0131lan olarak 1'den ba\u015flay\u0131p sonraki her kay\u0131tta birer birer artan benzersiz bir say\u0131sal de\u011fer olu\u015fturmas\u0131na neden olur.<\/p>\n
Benzer \u015fekilde, ikinci s\u00fctun olan section, DEFAULT anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc i\u00e7erir. INSERT INTO ifadesinin s\u00fctun listesinden section'\u0131 kald\u0131r\u0131rsan\u0131z, RDBMS otomatik olarak varsay\u0131lan de\u011feri ekler - bu \u00f6rnekte "production":<\/p>\n
\nCREATE TABLE interns (\r\ninternID int AUTO_INCREMENT PRIMARY KEY,\r\ndepartment varchar(20) DEFAULT 'production',\r\nname varchar(30)\r\n);<\/code><\/pre>\n<\/div>\nBu \u00f6zellikleri g\u00f6stermek i\u00e7in, a\u015fa\u011f\u0131daki INSERT INTO ifadesini \u00e7al\u0131\u015ft\u0131rarak Stajyerler tablosunu baz\u0131 verilerle y\u00fckleyin. Bu i\u015flem yaln\u0131zca Ad s\u00fctununun de\u011ferlerini belirtir:<\/p>\n
\nINSERT INTO interns (name) VALUES ('Pierre'), ('Sheila'), ('Francois');\r\n<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 3 rows affected (0.01 sec)\r\nRecords: 3 Duplicates: 0 Warnings: 0<\/code><\/pre>\n<\/div>\nDaha sonra tablodaki t\u00fcm kay\u0131tlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in \u015fu sorguyu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n
\nSELECT * FROM interns;\r\n<\/code><\/pre>\n<\/div>\n\n\nOutput\r\n+----------+------------+----------+\r\n| internID | department | name |\r\n+----------+------------+----------+\r\n| 1 | production | Pierre |\r\n| 2 | production | Sheila |\r\n| 3 | production | Francois |\r\n+----------+------------+----------+\r\n3 rows in set (0.00 sec)<\/code><\/pre>\n<\/div>\n<\/div>\nBu \u00e7\u0131kt\u0131, s\u00fctun tan\u0131mlar\u0131ndan dolay\u0131, \u00f6nceki INSERT INTO ifadesinin, belirtilmemi\u015f olmas\u0131na ra\u011fmen hem i\u00e7 hem de d\u0131\u015f b\u00f6l\u00fcmlere de\u011fer ekledi\u011fini g\u00f6stermektedir.<\/p>\n
Bir b\u00f6l\u00fcm s\u00fctununa varsay\u0131lan de\u011ferden farkl\u0131 bir de\u011fer eklemek i\u00e7in, INSERT INTO ifadesinde o s\u00fctunu \u015fu \u015fekilde belirtmeniz gerekir:<\/p>\n
\nINSERT INTO interns (name, department)\r\nVALUES\r\n('Jacques', 'management'),\r\n('Max', 'quality assurance'),\r\n('Edith', 'management'),\r\n('Daniel', DEFAULT);<\/code><\/pre>\n<\/div>\n\nOutput\r\nQuery OK, 4 rows affected (0.00 sec)\r\nRecords: 4 Duplicates: 0 Warnings: 0<\/code><\/pre>\n<\/div>\nBu \u00f6rnekte verilen son de\u011fer sat\u0131r\u0131n\u0131n, dize de\u011feri yerine DEFAULT anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc i\u00e7erdi\u011fine dikkat edin. Bu, veritaban\u0131n\u0131n varsay\u0131lan de\u011feri ('production') eklemesine neden olur:<\/p>\n
\nSELECT * FROM interns;\r\n<\/code><\/pre>\n<\/div>\n\nOutput\r\n+----------+-------------------+----------+\r\n| internID | department | name |\r\n+----------+-------------------+----------+\r\n| 1 | production | Pierre |\r\n| 2 | production | Sheila |\r\n| 3 | production | Francois |\r\n| 4 | management | Jacques |\r\n| 5 | quality assurance | Max |\r\n| 6 | management | Edith |\r\n| 7 | production | Daniel |\r\n+----------+-------------------+----------+\r\n7 rows in set (0.00 sec)<\/code><\/pre>\n<\/div>\nSonu\u00e7<\/h2>\n
Bu k\u0131lavuzu okuyarak, VALUES anahtar s\u00f6zc\u00fc\u011f\u00fcyle tek tek veri sat\u0131rlar\u0131n\u0131 belirtmek, SELECT sorgular\u0131yla t\u00fcm veri k\u00fcmelerini kopyalamak ve SQL'in otomatik olarak veri ekleyece\u011fi s\u00fctunlar\u0131 tan\u0131mlamak dahil olmak \u00fczere, bir tabloya veri eklemenin birka\u00e7 farkl\u0131 yolunu \u00f6\u011frendiniz.<\/p>\n
Burada listelenen komutlar, SQL kullanan t\u00fcm veritaban\u0131 y\u00f6netim sistemlerinde \u00e7al\u0131\u015f\u0131r. Her SQL veritaban\u0131n\u0131n dilin kendine \u00f6zg\u00fc bir uygulamas\u0131n\u0131 kulland\u0131\u011f\u0131n\u0131 unutmay\u0131n; bu nedenle, INSERT INTO ifadesinin nas\u0131l i\u015flendi\u011fi ve bunun i\u00e7in kullan\u0131labilen se\u00e7enekler hakk\u0131nda daha kapsaml\u0131 bir a\u00e7\u0131klama i\u00e7in veritaban\u0131 y\u00f6netim sisteminizin belgelerine ba\u015fvurmal\u0131s\u0131n\u0131z.<\/p>","protected":false},"excerpt":{"rendered":"Giri\u015f Yap\u0131land\u0131r\u0131lm\u0131\u015f Sorgu Dili, daha yayg\u0131n olarak SQL olarak bilinir, b\u00fcy\u00fck esneklik sunar\u2026","protected":false},"author":1,"featured_media":15925,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","_yoast_wpseo_canonical":"","_yoast_wpseo_opengraph-description":"","_yoast_wpseo_opengraph-image":"","_yoast_wpseo_twitter-description":"","_yoast_wpseo_twitter-image":"","_yoast_wpseo_focuskeywords":"","_yoast_wpseo_primary_category":"193","footnotes":""},"categories":[193,349],"tags":[403,391],"class_list":{"0":"post-15924","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"category-database","9":"tag-data-base","10":"tag-mysql"},"yoast_head":"\n
\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL - \u0628\u0644\u0627\u06af ITPiran<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-insert-data-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647 \u0632\u0628\u0627\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647\u060c \u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0646\u0627\u0645 SQL \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-insert-data-in-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-20T16:37:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1793\" \/>\n\t<meta property=\"og:image:height\" content=\"1110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL\",\"datePublished\":\"2024-07-20T16:37:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/\"},\"wordCount\":104,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/20191826\\\/sql-insert-data.jpg\",\"keywords\":[\"data base\",\"MySQL\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/\",\"name\":\"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/20191826\\\/sql-insert-data.jpg\",\"datePublished\":\"2024-07-20T16:37:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/20191826\\\/sql-insert-data.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/20191826\\\/sql-insert-data.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/how-to-insert-data-in-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/category\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"name\":\"\u0628\u0644\u0627\u06af ITPiran\",\"description\":\"\u0627\u062e\u0628\u0627\u0631 \u0648 \u0645\u0642\u0627\u0644\u0627\u062a \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\",\"name\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"alternateName\":\"ITPIran Blog\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"width\":512,\"height\":512,\"caption\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tr\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL'e veri nas\u0131l eklenir - ITPiran Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-insert-data-in-sql\/","og_locale":"tr_TR","og_type":"article","og_title":"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647 \u0632\u0628\u0627\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647\u060c \u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0646\u0627\u0645 SQL \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627…","og_url":"https:\/\/www.itpiran.net\/blog\/tr\/tutorials\/how-to-insert-data-in-sql\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-07-20T16:37:04+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"admin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL","datePublished":"2024-07-20T16:37:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/"},"wordCount":104,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg","keywords":["data base","MySQL"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc","\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/","name":"SQL'e veri nas\u0131l eklenir - ITPiran Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg","datePublished":"2024-07-20T16:37:04+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/20191826\/sql-insert-data.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/how-to-insert-data-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itpiran.net\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0622\u0645\u0648\u0632\u0634\u06cc","item":"https:\/\/www.itpiran.net\/blog\/category\/tutorials\/"},{"@type":"ListItem","position":3,"name":"\u0646\u062d\u0648\u0647 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"\u0130ran S\u00fcrd\u00fcr\u00fclebilir Ticaret Haberleri ve Makaleleri","publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itpiran.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"S\u00fcrd\u00fcr\u00fclebilir \u0130ran \u0130\u015fletmeleri Blogu","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","contentUrl":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","width":512,"height":512,"caption":"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81","name":"y\u00f6netici","url":"https:\/\/www.itpiran.net\/blog\/tr\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/comments?post=15924"}],"version-history":[{"count":2,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15924\/revisions"}],"predecessor-version":[{"id":15927,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/posts\/15924\/revisions\/15927"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media\/15925"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/media?parent=15924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/categories?post=15924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/tr\/wp-json\/wp\/v2\/tags?post=15924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}