Best Way?

If I have (2) tables. Like GROUP , CODE GRP1, AA GRP1, AB GRP1, AC GRP2, BA GRP2, BB GRP2, BC And; USER , UCODE ME, AA ME, AC YOU, AA What's the best way to query to find out if "ME" has all codes in either of the groups? In other words, I want to know if I have all

Re: view irregularities

Shawn, On Feb 13, 2008, at 9:12 AM, Shawn Green wrote: Lev Lvovsky wrote: I'm running into a difficult to reproduce problem with a view which is similar to the following: CREATE TABLE Common ( COMMON_ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, COMMON_NAME VARCHAR(50), UNIQU

Re: MySQL 5.1.23-rc compiled and max open files

Hi ALL, I have compiled MySLQ 5.1.23-rc for Linux 64bit ./configure CC=gcc CFLAGS="-DBIG_JOINS=1 -O3" CXX=g++ CXXFLAGS="-DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti -O3" --prefix=/app/mysql-5.1.23-rc --localstatedir=/app/mysql-5.1.23-rc/data --libexecdir=/app/mysql-5.1.23-rc/bin -

Re: Maria Engine and AMD and 5.1.23 binary version

Hi, Do you know an approximate date ? Thanks, Mariella --- Sergei Golubchik <[EMAIL PROTECTED]> wrote: > Hi! > > On Feb 14, Mariella Petrini wrote: > > Hi All, > > > > Is there any plan to release a binary version for > > mysql-5.1.23-maria-alpha for Linux 64 for AMD ? > > Yes. > > Regards

Re: select unique ?

Try: SELECT DISTINCT Colour FROM table; Or, if you want to do it correctly: SELECT Colour FROM table GROUP BY color; Richard wrote: Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num|Name|

Re: Maria Engine and AMD and 5.1.23 binary version

Hi! On Feb 14, Mariella Petrini wrote: > Hi All, > > Is there any plan to release a binary version for > mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen Grüssen, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]

Re: select unique ?

SELECT DISTINCT Colour FROM tablename Peter On 14/02/2008, Richard <[EMAIL PROTECTED]> wrote: > > Hello, > > I don't know if it is possible to do this with mysql alone ... > Here goes : > I've got a database list which is like to following : > > Num | Name| Colour > --

select unique ?

Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num | Name| Colour --- 1 | Harry | Red 2 | Tom | Blue 3

Master Thesis

Hi All, Am currently doing my master degree and i want to contribute to MySQL. I am planning to make my thesis in MySQL query performance and enhancing it. Can you advice me from where should I start and if this idea is great or I shouldn't waste my time on it? Regards, Haitham Kaddoura

Maria Engine and AMD and 5.1.23 binary version

Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Thanks in advance for your help, Mariella Looking for last minute shopping deals? Find them f

Re: MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...

On Thursday 14 February 2008 01:21:31 Jacob, Raymond A Jr wrote: > I apologize for asking this question. > I am somewhat confused by Microsoft's Licensing and I personally can not > justify to senior management why > MS SQL should be procured instead of procuring software more urgent > requirements

query database using an outside variable

I need to query a table (TABLE1) based on the value of an element in an XML (element email address gets stored in a variable say, EMAIL1). How do I do this query? something like SELECT * FROM leads where (email matching the variable) -- View this message in context: http://www.nabble.com/que