Results 1 to 2 of 2

Thread: mysgl

  1. #1
    Join Date
    Apr 2007
    Location
    kuantan
    Posts
    2
    Rep Power
    0

    Question mysgl

    hiey salam sejahtera....

    can u help me for give me coding for redundancy(tiada keberulangan data)dalam databases....kita nak tahu masa kita tekan button save/add dan kita masukkan data yang sama dan keluar message data tersebut sudah ade dalam database......please...

  2. #2
    Join Date
    Aug 2006
    Location
    Malaysia
    Posts
    1,576
    Rep Power
    185
    For the simplest method,

    the concept is as below:

    When save,
    Store 'Rasmussen' into variable1
    Store 'Storgt 67' into variable2

    INSERT INTO Persons (LastName, Address) VALUES (variable1, variable2)

    After saving, check whether the record does exist.

    Select LastName FROM Persons
    WHERE LastName = variable1 AND Address = variable2

    If there is a record returned, means that it is saved successfully

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search Engine Optimization by vBSEO 3.5.0 RC1 PL1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37