yep, spot on, also I didn't even need to specifically create the fields at
all.....the Select clause does it for me...thanks very much for the help....I
can get on with the hard (for me) stuff now :-)
On Thursday 17 May 2001 03:22, Rolf Hopkins wrote:
> ---- 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
---------------------------------------------------------------------
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
