Re: Date format question

[Robert Gehrig]

Assign all dates to have a day of 01

Store in a date field, use DATE_FORMAT to just extract the MM and .

As you don't have the real day information it doesn't matter what day is used, 
so long as it present in all months.

Hope this helps

Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: [EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Missing information Search

[Robert Gehrig]

Hi

I have two tables that are structured like so:

Table 1:
ID  int
K_Code  int

Table 2
K_Code  int
K_Desc  char

Table 2 has been corrupted and may be missing some records.

What I need to be able to do is find any values of K_Code in table 1 that don't 
appear in table 2.

Thanks

Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: [EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Help

[Robert Gehrig]

I have a table like so:

ID  int
val1int
val2int

I can have multiple records where id is the same. e.g:

ID  val1val2
1   1   2
1   1   1
2   2   2
2   1   1
2   2   2

I need to find which id has the most records.

Thanks

Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: [EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Help

[Robert Gehrig]

Thanks that got it.


Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: [EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Problem

[Robert Gehrig]

Hi all

I have a detail table that has multiple records associated with an ID number
Both fields are integers

E.G.

Id  Code
4   23
4   27
34  23
34  45
34  28

What I need to find is the Id where the code is 23 and 45 for the same Id (the result 
in this case would be 34)

How do I do this with a SQL query

Thanks

Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: [EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php