seems to me that the first query uses your primary key index. Since you have
specified qualifications on crcid and tag in both aliases, it will resolve
to a small number of rows in each alias table. The second query will join
your aliases on the crcid index, and then the tag qualifications will
last_insert_id is a function. It will return a value for each row in the
table. You want to run:
select last_insert_id() as lid;
instead of selecting from a table.
-Original Message-
From: Graeme B. Davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 3:17 PM
To: [EMAIL
isn't this the expected behavior?
(1008306000-988344000)/86400 = 231.04
select mod(231.04,7);
0
231.04 mod 7 is .04, rounded down to 0. 7*33=231
the mod function rounds the result - that's expected, right? Other than that
I don't see what the problem is.
braxton
-Original Message-
I think this is an interesting question. Note the following:
count(col1) will tell you the number of non-null occurrences of col1
col1=value will return 1 is col1=value, 0 if col1value
1/0 will return null
thus,
count(1/(col1=value)) will tell you the number of occurences of value in
col1.
howzabout
SELECT Table1.id, Table1.name, count(1/(Table2.offon = 'off')) AS NOFF
FROM Table1 , Table2
WHERE Table1.id = Table2.id
GROUP BY Table1.id, Table1.name
HAVING NOFF=0;
works for me:
mysql create table Table1 (id int, name varchar(10));
Query OK, 0 rows affected (0.01 sec)
mysql
if you are using tcsh:
set docroot='path to your html root directory'
find $docroot -name *.html allhtml.list
foreach FILE (`cat allhtml.list`)
echo $FILE outhtml.list
grep 'link' $FILE outhtml.list
end
you can get more sophisticated than this, but this will work. then look
through
Andrzej,
As I understand it,
MySQL does not have the concept of tablespaces like in Oracle. Databases are
subdirectories underneath the /var/lib/mysql directory and files are tables
within those subdirectories, so you can put an entire database or individual
files on a different disk by
why are you using distinct(ref1)?
also count(*) is ambiguous in this case. should be count(a.*).
you have a ref1 column in both tables, but you don't join them on it. that's
kind of confusing but won't cause the problem. member_id is the primary key
on the members table, right? Otherwise you
I think your problem is at the netscapeapache level, not the mysql level.
Can you view static html pages served by your local apache with netscape?
since netscape, opera, and IE all connect to apache, and then apache calls
perl to connect to mysql, I doubt your problem has anything to do with
you want a function that prepends the letter a to the category/subcategory
names that are not other. then you order by that function, but do not
display it.
select category,subcategory from foo2
order by if(category=
'other','zz',concat('a',category));
i.e. everything except other begins with
Robbason
Cc: Mysql
Subject: Re: max FULLTEXT index size?
Hi!
On Apr 19, Braxton Robbason wrote:
Hi all,
I'm creating a fulltext index on a 400MB table, and the creation process
gets very slow. It's fast for the first 50MB of the index, and then it
grinds to what seemed like a halt after days. My
Hi all,
I'm creating a fulltext index on a 400MB table, and the creation process
gets very slow. It's fast for the first 50MB of the index, and then it
grinds to what seemed like a halt after days. My question is - is there
anyone who's created fulltext indexes on this much data who can assure
select word, count(word) as total
from search_words
where word is not null
group by word
order by total desc
limit 20
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Correct syntax?
Thanks for help
John,
I don't think anyone can say for sure which is 'better'. MySQL is used in a
different kind of environment than Oracle. Oracle is designed for an
enterprise environment, where many different applications are used
simultaneously to add or retrieve data from a central data store. MySQL is
I thought I read that was in the plan for 4.0. I can't find where that's
stated in the docs though - all I see is the stuff about boolean operators.
Does anyone have experience with using the AOL PLS package for text
searching? I am thinking of using it.
Braxton
-Original Message-
http://www.mysql.com/doc/M/a/Mathematical_functions.html
describes how to do this using the RAND() function.
-Original Message-
From: Alec Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 6:27 PM
To: [EMAIL PROTECTED]
Subject: How to structure a random query
I'm just
16 matches
Mail list logo