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,
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.0.7
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 -
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, you
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
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
From: Ken Easson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
hello,
I have
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 difference with speed,
depending on your hardware.. but you never know.
--
Brian Lindner
Tuesday, January 7, 2003, 11
it.
I forget 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's access
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 col1='const