CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select
log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon =
5 group by log.sajtid;
the create table on its own works, the select statement works, there is a
similar example in the sql manual that works, but this doesnt :-(. Can antone
help a newbie?
The actual problem, is to calculate the percentage number of records less
than a value. So I want to create this temp table with the total count of
records and then count the no of records that are less than x and link to
this table to calculate the percentage. or am I barking up the wrong tree?
Mysql 3.22 and 3.23 for those interested but it has to work on both.
---------------------------------------------------------------------
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
