want to import CSV file to mysql, so I have to create a table first? - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - want to import CSV file to mysql, so I have to create a table first?

相关主题
● How to split a column into several rows?	● database triggers
● a simple question about insert	● MySQL怎么远程地set Text或Blob column?
● input into access	● mysql maximum columns <=1000?
● MapReduce 请教：key 能用pair value吗？比如 (转载)	● 请教一个mysql 排序问题。
● 请教个数据管理的问题	● mysql query question
● How to use an *.csv file in SAS?	● In MySQL, 如何在procedure里create trigger？谢谢了？
● 请大家给我推荐一下SSIS的书	● 高手请指点： How to query specific data in all columns efficiently
● Import data from excel into sql server 2000	● MySQL Server 2k Question again!

相关话题的讨论汇总
话题: csv话题: create话题: table话题: import话题: first

进入Database版参与讨论

1

(共1页)

s*******r 发帖数: 769	1 It seems I need to create a table, setup the columns like in the csv file first, and then import. Is this correct?
a*******a 发帖数: 1240	2 you can load these data through a programming language such as Java or any one that you are familiar with.
C********g 发帖数: 1548	3 Yes. you will have to create a table first.

1

(共1页)

进入Database版参与讨论

相关主题
● MySQL Server 2k Question again!	● 请教个数据管理的问题
● How to install mysql server on Linux?	● How to use an *.csv file in SAS?
● About domain in Mysql	● 请大家给我推荐一下SSIS的书
● 急，mysql create database fail	● Import data from excel into sql server 2000
● How to split a column into several rows?	● database triggers
● a simple question about insert	● MySQL怎么远程地set Text或Blob column?
● input into access	● mysql maximum columns <=1000?
● MapReduce 请教：key 能用pair value吗？比如 (转载)	● 请教一个mysql 排序问题。

相关话题的讨论汇总
话题: csv话题: create话题: table话题: import话题: first

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)