I have spent some time in the past with mysql but am far from an
experienced database head. A while back I received a some mysql data
for a research project. The files are:
$ cd /usr/local/mysql/research1data
$ ls -lh
-rw-rw 1 mysql mysql 21G Jun 20 2003 oldreport_2002_12_08.MYD
-rw-rw
Thanks for the quick reply!
As root, I tried:
mysql> use research1data;
mysql> show tables;
+-+
| Tables_in_research1data |
+-+
| oldreports |
+-+
1 row in set (0.00 sec)
mysql> CREATE TABLE oldreport_2002_12_08
ulated copy
>
> or
>
> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports where
> 1=2;
> to create an empty copy
>
> I hope this helps
>
> Simon Windsor
> Eml: [EMAIL PROTECTED]
> Tel: 01454 617689
> Mob: 07960 321599
>
> -Origin
;>
> >> try
> >>
> >> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports;
> >> to create populated copy
> >>
> >> or
> >>
> >> mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports
&
