---- Original Message -----
From: "Mark Rowlands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 3:11
Subject: create table with select syntax error problem
> 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;
It would help to know what the error message is but for starters, you are
creating a column count int(10) and count is a reserved word as in
log.sajtid,count(*).
> 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
---------------------------------------------------------------------
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
