Re: importing a table
| From: | David Robley | Date: | Fri, 14 Sep 2001 00:40:48 +0000 |
| Subject: | Re: importing a table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67289@lists.php.net to get a copy of this message | ||
On Fri, 14 Sep 2001 00:40, Peter wrote:
> Hi,
>
> This may be more of an Mysql question than a PHP question.
>
> I am hoping that I can export an Address Book table from my Access
> Database and then import that table into Mysql. I am hoping that I can
> then use PHP to carry out queries on the information in the table.
>
> I was wondering is there a command in Mysql that can import tables?
>
> I just need to import one table, not an entire database.
>
>
> Thanks.
>
> Peter
There is mysqlimport from the command line, and there is the LOAD DATA
INFILE syntax.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Meow... SPLAT... Ruff... SPLAT... (Raining cats & dogs)