Re: Opposite selection...

Nicholas, Tuesday, February 4, 2003, 12:25:08 PM: > Ok I'm stumped on what I think should be a somewhat simple query. What I > have so far is a list of names that is in a list of projects AND in a the > main contact list by doing the following query: > SELECT p.name, p.company FROM contacts c, pro

Re: Substraction

Octavian, Sunday, January 19, 2003, 7:31:57 AM, you wrote: > Hi all, > I've tried the following query: > create table test(id int unsigned); > insert into test values(10); > select 15 - id from test; > The result is 18446744073709551611 instead of -5. I ran this.. and it worked for me MySql 4

Re[2]: Whats the best way to manage 'generic two-way relationships'?

oops small mistake in my prev post.. I meant to say (f -> b b-> c,d,e, Kk-> l,m) in my example NOT f->b,k b->c,d,e lol.. got a little confused with all those insert examples ;) Friday, January 17, 2003, 2:01:22 PM, you wrote: > Geoffrey, > Friday, January 17, 2003, 12:01:20 PM

Re: Whats the best way to manage 'generic two-way relationships'?

Geoffrey, Friday, January 17, 2003, 12:01:20 PM, you wrote: > I couldn't think of a better term for what I want to do... > I am building a CMS for news stories. Often news stories are related to each > other, or need to be grouped by content. I need a simple way to manage > storyId relationships

Re: Will PhpMyAdmin run on Linux-Apache-MySQL box ?

Will, Thursday, January 16, 2003, 6:14:11 PM, you wrote: > I installed PhpMyAdmin on a Windows box using EasyPhp... > Will PhpMyAdmin run on a Linux/Apache/MySQL server? (I've got one on my desk > up & > running) Yes.. > If so which version should I download? phpMyAdmin-2.3.3pl1 is the latest

Re: how do i retrieve distinct rows using IN

just querieng for the wrong information .. but since i dont know what you are trying to do, i cant say more right now. Id need more information.. Brian Lindner -- Original Message - Subject: how do i retrieve distinct rows using IN Date: Wed, 15 Jan 2003 15:12:37 -0400

Re[2]: Weird WHERE clause possible?

will use indexes properly or it may be slower than just a LASTNAME LIKE "Smith".. You would have to test for performance. If your users are used to the autocomplete type of features.. speed probably will be a big issue to them. Your data may be too small in size right now to notice a big

Re[2]: Access control lists on rows?

if mysql is planning on having db View objects anytime but until then, yes, you would have to control this in application code.. -- Brian Lindner Saturday, January 4, 2003, 5:44:19 PM, you wrote: > At 14:39 -0800 1/4/03, Steven Nakhla wrote: >>I know I can restrict a user'

Re: Order by does not use an index when it should.

weg_5 will be used for the where (the 3 col) and the new index will be for the orderby Hope that helps -- Brian Lindner Friday, January 3, 2003, 8:05:05 PM, you wrote: > Hello, > I am trying to get a sort to use an index. The query is very simple: > select nr from mytable where co