Re: FN-FORUM: PHP/MySQL question

date posted 10th August 2003 17:16

Adding the star should definitely work ... see example below:

---- e.g. ----
mysql> describe T_Members;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| customerid | int(11) | | | 0 | |
| name | char(21) | YES | | NULL | |
| address | char(42) | YES | | NULL | |
| acclimit | decimal(8,2) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> create table T_Temp select * from T_Members;
Query OK, 1 row affected (0.07 sec)
Records: 1 Duplicates: 0 Warnings: 0
---- /e.g. ----

If you still having problems cut and paste the following two lines into
your mysql window.
-----------------
describe T_Members;
create table T_Temp select * from T_Members;
-----------------
And post the output to the list.

Cheers,

Dave.




On Sun, 2003-08-10 at 16:35, John Anderson wrote:
> Nope. Still get the parsing error.
>
> (Curiously, the MySQL website doesn't indicate that *what* needs to be
> mentioned.)
>
> Thanks though,
>
> John
>
> ----- Original Message -----
> From: "Tony Crockford" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Sunday, August 10, 2003 4:24 PM
> Subject: RE: FN-FORUM: PHP/MySQL question
>
>
> >
> >
> > > >CREATE TABLE T_Temp SELECT FROM T_Members;
> > >
> > > T_Members exists in the database, and I'm pretty certain of
> > > the syntax.
> >
> >
> > Select *what* from T_Members?
> >
> > I'd say that's the problem.
> >
> > try CREATE TABLE T_Temp SELECT * FROM T_Members;
> >
> > if that's what you want (all of it).
> >
> > HTH
> >
> > Tony
> >
> > ==========
> > fido.net are pleased to sponsor these Freelancers messages. For all
> > your web hosting needs check out http://www.fido.net/ with hosting
> > packages starting from just 46.95 a year including VAT.
> > Free 0871 Fax2Email numbers also available online!
> > http://www.fido.net/ - the internet made simple! - 0800 1072 666
> >
> > To advertise here: http://www.freelancers.net/advertising.html
> >
> >
> ==========
> fido.net are pleased to sponsor these Freelancers messages. For all
> your web hosting needs check out http://www.fido.net/ with hosting
> packages starting from just 46.95 a year including VAT.
> Free 0871 Fax2Email numbers also available online!
> http://www.fido.net/ - the internet made simple! - 0800 1072 666
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>