SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: mysql

  1. #1
    SitePoint Zealot honging's Avatar
    Join Date
    Jan 2001
    Location
    Chapel Hill, NC
    Posts
    160
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql

    is there a command that will update all entries in a specific row to a specific entry ... delete all current ones and replace it with a new one?

    thanks!

  2. #2
    What? Maelstrom's Avatar
    Join Date
    Oct 2001
    Location
    Whistler BC originally from Guelph Ontario
    Posts
    2,175
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Replace....it uses the exact syntax of insert. I don't know abouts its performance but I find it works well

    http://www.mysql.com/doc/R/E/REPLACE.html

    Hopefully thats what you are asking for
    Maelstrom Personal - Apparition Visions
    Development - PhP || Mysql || Zend || Devshed
    Unix - FreeBSD || FreeBsdForums || Man Pages
    They made me a sitepoint Mentor - Feel free to PM me or Email me and I will see if I can help.


Bookmarks

Posting Permissions

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