472,337 Members | 1,207 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,337 software developers and data experts.

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 .

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

On Mon, 21 Jul 2003, Adam Carmichael wrote:
Worked like a charm!

Thank you very much Sergei! :)


----- 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


On Jul 20, Adam Carmichael wrote:

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


__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / 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

Jul 19 '05 #1
0 3125

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Gary Lundquest | last post by:
I have an application with MS Access 2000 as the front end and MySQL as the back end. All was well until I upgraded the MySQL (Linux) server. ...
by: Gary Lundquest | last post by:
It appears to me that MySQL version 4 returns an error messge when doing an Insert that results in duplicate entries. Version 3 did NOT return an...
by: marx | last post by:
I have a bit of a problem and any help would be much appreciated. Problem: I have two dropdown list boxes with same data(all data driven). These...
by: andreas.maurer1971 | last post by:
Hi all, since a few years I use the following statement to find duplicate entries in a table: SELECT t1.id, t2.id,... FROM table AS t1 INNER...
by: sri2097 | last post by:
Hi all, I'm storing number of dictionary values into a file using the 'cPickle' module and then am retrieving it. The following is the code for it ...
by: Chris Lasher | last post by:
Hello Pythonistas! I'm looking for a way to duplicate entries in a symmetrical matrix that's composed of genetic distances. For example, suppose I...
by: Manish | last post by:
The topic is related to MySQL database. Suppose a table "address" contains the following records ...
by: teser3 | last post by:
I have my PHP inserting into Oracle 9i. But how do I prevent duplicate record entries? I only have 3 fields in the insert in the action page: ...
by: ramdil | last post by:
Hi All I have table and it have around 90000 records.Its primary key is autonumber field and it has also have date column and name, then some...
by: php_mysql_beginer911 | last post by:
Hi .. i am trying to update a table where if field contents any duplictaed entries than one of the field should be updated with random number...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.