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
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
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
-Original Message-
From: Cameron Ortis [mailto:[EMAIL PROTECTED]
Sent: 16 February 2004 21:35
To: Bing Du
Cc: [EMAIL
Simon Windsor
Eml: [EMAIL PROTECTED]
Tel: 01454 617689
Mob: 07960 321599
-Original Message-
From: Cameron Ortis [mailto:[EMAIL PROTECTED]
Sent: 16 February 2004 21:35
To: Bing Du
Cc: [EMAIL PROTECTED]
Subject: Re: Newbie
Thanks for the quick reply!
As root, I tried