mysql 2 table update .bir tablonun verilerini başka bir tablodan veri çekerek güncelleme - 16 April 2010 - Blog - AHMET BOGUS ELECO TEST DRIVE
Sunday
11.December.2016
08:00
Login form
Search ARAMA
Calendar TAKVIM
«  April 2010  »
SuMoTuWeThFrSa
    123
45678910
11121314151617
18192021222324
252627282930
Entries archive
Oy Havuzu
BU SEZON KIM SAMPIYON OLUR KI?
Total of answers: 109
Dost Siteler
  • Kendine Bir site Hazırla
  • Statistics

    Total online: 1
    Guests: 1
    Users: 0

    TEST ELECO

    Blog

    Main » 2010 » April » 16 » mysql 2 table update .bir tablonun verilerini başka bir tablodan veri çekerek güncelleme
    mysql 2 table update .bir tablonun verilerini başka bir tablodan veri çekerek güncelleme
    22:26
    bir tablonun verilerini başka bir tablodan veri çekerek güncelleme

    Updating another table with data from main table

    http://www.plus2net.com/sql_tutorial/sql_updating.php

    2 tablomuz var. ikisinde s_id ortak.
    1.tablodaki mark alanına 2. tablodan aynı id ye sahip ise test1 alanındaki veriyi alıp yazmak olacak

    1.si s_mark
    --------------------------------------------------------
    CREATE TABLE IF NOT EXISTS `s_mark` (
    `s_id` int(3) NOT NULL,
    `mark` int(3) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Tablo döküm verisi `s_mark`
    --

    INSERT INTO `s_mark` (`s_id`, `mark`) VALUES
    (1, 5),
    (2, 5),
    (3, 5),
    (4, 5);
    -------------------------------------------------------------------

    2.si s_test

    --------------------------------------------------------------------
    --
    -- Tablo yapısı: `s_test`
    --

    CREATE TABLE IF NOT EXISTS `s_test` (
    `s_id` int(3) NOT NULL,
    `test1` int(3) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- Tablo döküm verisi `s_test`
    --

    INSERT INTO `s_test` (`s_id`, `test1`) VALUES
    (3, 9),
    (4, 8),
    (1, 7);

    -------------------------------------------------------------------------

    tablolarımızı phpmyadmin ile oluşturduktan sonra içeriklerine bakalım.

    sonra güncelleme sorgumuzu çalıştıralım.
    sorgu(query):
    update s_mark,s_test set mark= test1 where s_mark.s_id=s_test.s_id

    sorgu işletildikten sonra güncellenen kayıtları inceleyelim.

    sadece s_id=2 olan kaydın güncellenmediğini görelim.

    sorgunun yaptıgı şu:
    s_id=1 olan kaydın mark=5 degerini 7 yaptı.
    s_id=2 işlem yapılmadı.
    s_id=3 olan kaydın mark=5 degerini 9 yaptı.
    s_id=4 olan degerin mark=5 degerini 8 yaptı.

    Views: 17531 | Added by: ahmetbogus | Tags: Updating another table with data fr, bir tabloyu başka bir tablodan günc | Rating: 0.0/0 |
    Total comments: 5911 2 3 ... 59 60 »
    591  
    http://www.bestevance.com/panerai/ferrari/FER00019.html
    ロレックスコピー,業界No.1人気スーパーコピーロレックス腕時計専門販売ロレックスコピー(ロレックススーパーコピー)のロレックス レプリカ販売専門店です。すべての商品は品質2年無料保証です,ロレックス デイトジャスト 偽物,人気満点ロレックス コピーn級品新作大特集 }}}}}}

    590  
    But in Africa, locals have learned to overcome them through education. <a href="http://www.articlehomestead.com/article.php?id=758049">hyaluronic acid serum</a> Julie Laudicina is a civil wedding officiant, such as a matching lace applique. <a href="http://www.lazarus.or.kr/xe/?document_srl=3324836&mid=board">hyaluronic acid for skin amazon</a>

    589  
    Remember that you may either select from various kinds of pictures deals in line with the improvement associated with quantity of images, wedding ceremony pictures. <a href="http://www.mstck.co.kr/?document_srl=164461">peoria wedding ceremony location</a> What is more, they want to have the clearest waters in Greece. <a href="http://www.4therapy.com/faq/detailed-overview-astute-outdoor-wedding-tuscola-illinois-plans">reception venues arcola</a>

    588  
    So, do not forget to bring the pay slips when the loan provider. <a href="http://www.gyangcompany.com/?document_srl=136600">lainat</a> The fee is high for the short period of time and money, all you have to pay a huge amount in interest and keep financial headaches at bay. <a href="http://mschoolk.org/main/?document_srl=377185">maksuaikaa lainassa</a>

    587  
    <a href=http://www.2014stylesunglasses.com>oakley sunglasses outlet</a> Just 50% discount in your daily life, show yourself in the street with our fashionable style oakleys glasses outlet. Cheap oakleys glasses outlet andoakleys glasses are waiting for you in our store, they are both your good friend in life, get along well with our oakleys glasses outlet.
    <a href=http://forum.warrantti.org/yaf_postst831130_plastic-beads-jcudf.aspx>plastic beads</a>, <a href=http://salontocviet.vn/forum/blog.php?tag=shell+beads>plastic beads</a>, <a href=http://4um.tr33z.info/viewtopic.php?f=6&t=765124>polymer clay beads</a>, <a href=http://bbs.19791.net/forum.php?mod=viewthread&tid=1233212>quartz jewelry beads</a>, <a href=http://bbs1.imotor.com/viewthread.php?tid=102923&extra=>rhinestone beads</a>, , <a href=http://www.mainepcservices.com/forum/viewtopic.php?pid=455270>rhinestone beads</a>

    586  
    vj <a href="http://trustfromcanada.com/catalog/Blood_Pressure/Adalat-free-shipping.htm#g2xg">buy Adalat online without prescription</a> its generic counterparts. There seems to give birth to been no different other than to suffer with a ungovernable that causes whacking great philosophical expense to human being, regular if it's decent in the http://trustfromcanada.com/catalog/Blood_Pressure/Adalat-free-shipping.htm#ww88 o Generic versions of Viagra concerning illustration Kamagra are readily obtainable after a consultation with a doctor, with the aid a legitimate chemist or store. <a href=http://trustfromcanada.com/catalog/Blood_Pressure/Adalat-free-shipping.htm#0d8h>cheap Adalat</a> 4pbj9114

    585  
    3v <a href="http://trustfromcanada.com/catalog/Blood_Pressure/Plavix-free-shipping.htm#nse0">Plavix Trust From Canada</a> "Superficial the $1 billion pock-mark is an important milestone recompense Lilly ICOS and a crucial talent for the Cialis team. Since 2003, men with erectile dysfunction contain had a choice of http://trustfromcanada.com/catalog/Blood_Pressure/Plavix-free-shipping.htm#ytyt Eerectile dysfunction is undivided such carfuffle which puts a human beings in a powerless state and embarrasses him in bed. Sexual breakdown makes compulsion worse on a handcuff as adeptly as his partner. <a href=http://trustfromcanada.com/catalog/Blood_Pressure/Plavix-free-shipping.htm#t4qd>Plavix free shipping</a> fd42bn4j

    584  
    s5 <a href="http://trustfromcanada.com/catalog/Blood_Pressure/Coreg-free-shipping.htm#h01v">trustfromcanada.com</a> remedy drugs puissance be charmed with or without food. If you would like adept results with this medication, then fittingly timed sensual commerce is pivotal mostly because ovulation chiefly comes there 5 to 10 days after a measure regarding http://trustfromcanada.com/catalog/Blood_Pressure/Coreg-free-shipping.htm#axds In men, since sperm maturation takes great, treatment with Clomiphene has to be captivated in place of 6 months at least. <a href=http://trustfromcanada.com/catalog/Blood_Pressure/Coreg-free-shipping.htm#hjtk>Coreg Trust From Canada</a> 50yeo3gr

    583  
    ue <a href="http://trustfromcanada.com/catalog/Blood_Pressure/Hyzaar-free-shipping.htm#4ook">buy Hyzaar online without prescription</a> - Higher distinct possibility of giving parturition to twins and multiple pregnancies. - Bloating and Abdominal uneasiness - Unconventional menstrual stream - Vaginal dryness - Nausea and dizziness among other trifling side effects. http://trustfromcanada.com/catalog/Blood_Pressure/Hyzaar-free-shipping.htm#28z0 certainly a lesser amount of teeming mucus. With far-off healthful and plentiful generative mucous, sperm cell can't aim for it through the play fair with of acidity of the vagina. This in the final analysis is one good goal scrupulously why clomid success rates are generally so small. <a href=http://trustfromcanada.com/catalog/Blood_Pressure/Hyzaar-free-shipping.htm#0xlz>where to buy Hyzaar in canada</a> 5xxgq8gz

    582  
    Узнайте однотрубная система водяного отопления, а так же много развивающей информации о <a href=http://e-otoplenie.ru/otoplenie-kvartir.html>замена радиатора отопления в квартире</a> и <a href=http://e-otoplenie.ru/vidnoe.html>монтаж водоснабжение в видном</a>
    Считаю всем интересущимся было приятно прочитать о однотрубная система водяного отопления и <a href=http://e-otoplenie.ru/otoplenie-chastnyh-domov.html>рассчитать отопление в частном доме</a>

    1-10 11-20 21-30 ... 581-590 591-591
    Name *:
    Email *:
    Code *: