no duplicate entries..

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • harsh

    no duplicate entries..


    Hi all,
    How do i do this ?
    i have a table with one of the column named uid,
    Now i want to insert a new row,only if no other
    row exist with the uid i m trying to insert.
    I hope its clear.

    thanks for any reply .

    harsh


    ------------------------------------------------------------------------------
    Linux? If y a moins bien,mais c'est plus cher
    --Not by harsh

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

    On Mon, 21 Jul 2003, Adam Carmichael wrote:
    [color=blue]
    > Worked like a charm!
    >
    > Thank you very much Sergei! :)
    >
    > Adam
    >
    > ----- Original Message -----
    > From: "Sergei Golubchik" <serg@mysql.com >
    > To: "Adam Carmichael" <adamc@no1.com. au>
    > Cc: <mysql@lists.my sql.com>
    > Sent: Sunday, July 20, 2003 10:04 PM
    > Subject: Re: MySQL compiletime errors with --with-debug=full
    >
    >[color=green]
    > > Hi!
    > >
    > > On Jul 20, Adam Carmichael wrote:[color=darkred]
    > > > Hello,
    > > >
    > > > I am trying to report a bug, and I would like to compile mysql with
    > > > debugging enabled to provide further information, but I receive
    > > > compile errors. I would like to resolve the compile errors before I
    > > > report the possible bug I have discovered.
    > > >
    > > > I am running FreeBSD 4.8, and I attempt to compile mysql-4.0.13 with
    > > > the following configure command: ./configure --with-vio --with-openssl
    > > > --with-debug=full (the initial bug I wanted to report is related to
    > > > openssl so compiling with the ssl and vio options is essential).
    > > >
    > > > I then try running 'make' but I get a lot of undefined reference
    > > > errors - so I have piped the STDOUT and STDERR to a file available for
    > > > download at: http://www.no1.com.au/~adamc/makeoutput.txt hoping that
    > > > someone with more C/C++ knowledge than myself can offer some insight.[/color]
    > >
    > > Are you sure you compiled mysys/ with -DSAFE_MUTEX ?
    > > safe_mutex* symbols are defined in mysys/thr_mutex.c
    > >
    > > Regards,
    > > Sergei
    > >
    > > --
    > > __ ___ ___ ____ __
    > > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@mysql.com >
    > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
    > > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
    > > <___/ www.mysql.com
    > >[/color]
    >
    > --
    > MySQL General Mailing List
    > For list archives: http://lists.mysql.com/mysql
    > To unsubscribe: http://lists.mysql.com/mysql?unsub=harsh@cse.iitb.ac.in
    >[/color]


    --
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql
    To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Working...