{"id":917,"date":"2020-02-10T21:09:00","date_gmt":"2020-02-10T18:09:00","guid":{"rendered":"http:\/\/www.aydiner.gen.tr\/?p=917"},"modified":"2023-04-23T20:34:08","modified_gmt":"2023-04-23T17:34:08","slug":"sql-insert-komutu-ile-veritabanina-kayit-ekleme","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2020\/02\/10\/sql-insert-komutu-ile-veritabanina-kayit-ekleme\/","title":{"rendered":"Sql Insert Komutu ile Veritaban\u0131na Kay\u0131t Ekleme"},"content":{"rendered":"

\"\"<\/a>Insert deyimi, veritaban\u0131na kay\u0131t eklemek i\u00e7in kulland\u0131\u011f\u0131m\u0131z temel sql komutlar\u0131ndan bir tanesidir. Bu yaz\u0131mda en basit insert komutu kullan\u0131m\u0131ndan ba\u015flayarak, \u00f6rnekler \u00fczerinden detaylar\u0131yla konuyu anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m. \u00d6rnekler i\u00e7in a\u015fa\u011f\u0131daki\u00a0musteriler<\/strong>\u00a0tablosunu olu\u015fturdum.<\/p>\n

\"m\u00fc\u015fteriler<\/a>
\u00d6rnek M\u00fc\u015fteriler Tablosu
\nhttps:\/\/www.kodlamamerkezi.com\/<\/figcaption><\/figure>\n

Tabloya Bir Kayd\u0131n Eklenmesi<\/h2>\n

Yukar\u0131daki tablomuza bir kay\u0131t eklemek i\u00e7in;<\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n
2<\/div>\n<\/div>\n<\/td>\n
\n
\n
insert <\/span>into <\/span>musteriler<\/span> (<\/span>tcno<\/span>,<\/span>isim<\/span>,<\/span>soyisim<\/span>,<\/span>yas<\/span>,<\/span>telefon<\/span>,<\/span>adres<\/span>,<\/span>kayittarihi<\/span>)<\/span><\/div>\n
values<\/span>(<\/span>‘12345678901’<\/span>,<\/span>‘Kutlay’<\/span>,<\/span>‘I\u015f\u0131k’<\/span>,<\/span>28<\/span>,<\/span>‘0232-1234567’<\/span>,<\/span>‘Torbal\u0131’<\/span>,<\/span>‘20141116’<\/span>)<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Yukar\u0131da ki sorgu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda kay\u0131t a\u015fa\u011f\u0131daki gibi tablomuza eklenecektir.<\/p>\n

\"sql<\/a>
Sorgu Sonucu Eklenen Kay\u0131t<\/figcaption><\/figure>\n

Bir insert sorgusu yazarken a\u015fa\u011f\u0131daki hususlara dikkat etmemiz gerekir.<\/p>\n

    \n
  • Tablo i\u00e7erisindeki hangi kolonlara veri eklenecekse o kolonlar\u0131n adlar\u0131 aralara virg\u00fcl konularak yaz\u0131l\u0131r.<\/li>\n
  • Varchar tipindeki veriler \u2018tek_tirnak\u2019 aras\u0131na yaz\u0131l\u0131r.<\/li>\n
  • Date, datetime t\u00fcr\u00fcndeki veriler \u2018tek_t\u0131rnak\u2019 aras\u0131na \u2018yyyymmdd\u2019 gibi tarih format\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclebilecek formatta yaz\u0131l\u0131r.<\/li>\n
  • Kolon say\u0131s\u0131yla girilecek verilerin say\u0131s\u0131 ayn\u0131 olmal\u0131d\u0131r.<\/li>\n
  • Veritaban\u0131 olu\u015fturulurken\u00a0Allow Null<\/strong>\u00a0se\u00e7ene\u011fi i\u015faretlenmi\u015f s\u00fctunlara veri girme i\u015flemi kullan\u0131c\u0131n\u0131n iste\u011fine b\u0131rak\u0131lm\u0131\u015ft\u0131r.<\/li>\n
  • Primary Key<\/strong>\u00a0olarak belirlenmi\u015f alana ayn\u0131 kay\u0131t tekrar eklenemez. Kar\u0131\u015f\u0131kl\u0131\u011f\u0131 \u00f6nlemek i\u00e7in bu alanlar\u0131n de\u011feri otomatik olarak artt\u0131r\u0131labilir.<\/li>\n<\/ul>\n

    Default De\u011ferleri Tabloya Ekleme<\/h2>\n

    Insert i\u015flemi s\u0131ras\u0131nda baz\u0131 kolonlara veri girme i\u015flemini tabloyu olu\u015ftururken belirledi\u011fimiz default(varsay\u0131lan) de\u011fer olarak girmek isteyebiliriz. Yukar\u0131daki tablomuzda\u00a0kayittarihi<\/em>\u00a0alan\u0131na varsay\u0131lan olarak bug\u00fcn\u00fcn tarihini atamak istersek;<\/p>\n