Re: mysql and Access

Article View: cn.comp.database.mysql

Article #89

Back to cn.comp.database.mysql Previous Next

#89

From: HackGou
Date: Mon, 24 Jan 2005 10:48

11 lines
1342 bytes

以cvs或者\t格式导出隔开的数据到文件，然后使用
LOAD DATA LOCAL INFILE "data.txt" INTO TABLE table_name；
导入到mysql

Rey wrote:
> Plase:
> 
> How I can do import database with date and relationship from Access to 
> mysql? 
> 
>

Technical Details

Message-ID: <ct2k0e$5al$1@news.yaako.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!news.yaako.com!not-for-mail

References: <31shj0F3eikf1U1@individual.net>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114450,a67dd5cf78947333
X-Google-Attributes: gid114450,public
X-Google-Language: Chinese,UTF8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!news.yaako.com!not-for-mail
From: HackGou <HackGou@Yeah.Net.Remove>
Newsgroups: cn.comp.database.mysql
Subject: Re: mysql and Access
Date: Mon, 24 Jan 2005 18:48:25 +0800
Organization: Bentium Ltd. (CN99)
Lines: 11
Message-ID: <ct2k0e$5al$1@news.yaako.com>
References: <31shj0F3eikf1U1@individual.net>
NNTP-Posting-Host: 218.88.224.86
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news.yaako.com 1106563918 5461 218.88.224.86 (24 Jan 2005 10:51:58 GMT)
X-Complaints-To: usenet@news.yaako.com
NNTP-Posting-Date: Mon, 24 Jan 2005 10:51:58 +0000 (UTC)
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
In-Reply-To: <31shj0F3eikf1U1@individual.net>
X-Enigmail-Version: 0.89.6.0
X-Enigmail-Supports: pgp-inline, pgp-mime

Reply to Parent Message