On Fri, Feb 25, 2000 at 05:45:48PM +0200, sinisa@stripped wrote:
> Paul Comber writes:
> > Dear All,
> > This create statement below doesn't work. As a select statement it is fine.
> > The debug says that deliveryPostcode, name and tel are duplicate column
> > names. Am I right in thinking that the AS clause is ignored in create table
> > implementation of the select statement? If so how I can I get around this
> > without renaming the table column names so that attributes are unique
> > throughout the database schema?
> > CREATE TABLE TODAYSORDERS
> > CR.deliveryPostcode AS deliveryPostcode1
> > ,CR.deliveryPostcode AS deliveryPostcode2
> > ,PU.tel AS CollectionPhoneNo
> > ,C.tel AS deliveryPhoneNo
> > ,S.name as supplier
> > ,M.name as merchant
> > FROM etc etc etc
> > WHERE etc etc
> > thanking you in advance,
> > Thanks, Paul
> What you need is CREATE from SELECT, available since 3.23.0.
> Please, do note that CREATE TABLE syntax has nothing to do with SELECT
> syntax !
Similar sort of question: A client here is trying to run Supermall.
1) How do I grant him priveleges re: the database
2) How do I get him to set up tables?