Advertisement

02.13.2007 at 04:24AM PST, ID: 22292983
[x]
Attachment Details

How do I get none exist data from a db

Asked by YossiBa in MySQL

Hi experts,
Lets say I have a Product table:
ID  Num
1  1111
2  2222
3  3333
4  4444
5  5555

and I have a list of numbers in a file:
1111
2222
7777
8888

Can I run a query that will deliver numbers 7777,8888 as the ones that not exist in the db?

Thanks a bunch

YossiStart Free Trial
 
Keywords: How do I get none exist data from a db
Title
1 db connect error
2 Union in stored proc with cursor
3 php mysql_num_rows
4 Need help with OLE DB Query to FoxPr…
5 db ip range
6 DB with Browser like MSN
 
Loading Advertisement...
 
[+][-]02.13.2007 at 05:15AM PST, ID: 18522283

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.13.2007 at 06:55AM PST, ID: 18522933

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MySQL
Sign Up Now!
Solution Provided By: Memorix
Participating Experts: 2
Solution Grade: A
 
 
[+][-]02.13.2007 at 07:11AM PST, ID: 18523052

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32