no duplicate entries..

[harsh]

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
http://www.cse.iitb.ac.in/~harsh
------------------------------------------------------------------------------

On Mon, 21 Jul 2003, Adam Carmichael wrote:

Worked like a charm!

Thank you very much Sergei! :)

Adam

----- Original Message -----
From: "Sergei Golubchik" <se**@mysql.com>
To: "Adam Carmichael" <ad***@no1.com.au>
Cc: <my***@lists.mysql.com>
Sent: Sunday, July 20, 2003 10:04 PM
Subject: Re: MySQL compiletime errors with --with-debug=full

Hi!

On Jul 20, Adam Carmichael wrote:

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.

Are you sure you compiled mysys/ with -DSAFE_MUTEX ?
safe_mutex* symbols are defined in mysys/thr_mutex.c

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <se**@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***************@cse.iitb.ac.in

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw