Chen Log

陳洛格

Move date from CSV to MySQL (SO EASY)

leave a comment »

從mac numbers把資料移到 mysql很簡單,
主要就是要以csv匯入,
先打開numbers檔案 或是 excel檔也可以。

Screen Shot 2012 02 13 at 09 36 17

從file(檔案)選export(輸出) csv檔

Screen Shot 2012 02 13 at 09 36 28

輸入 mysql一定是用UTF-8了,如果是windows 記得使用記事本改成utf-8格式再存一次。

Screen Shot 2012 02 13 at 09 36 35

CSV檔是採用,逗點分隔為多,當然mac輸出也是採用這樣為主,
如TEXTEDIT裡面所示:
Screen Shot 2012 02 13 at 09 49 59

所以最後匯入的時候記得要把圈起來的地方作選取或修改,改成「逗點」。
Screen Shot 2012 02 13 at 09 37 02

 

Advertisements

Written by chenagw

2012/02/13 at 09:52

Posted in Uncategorized

Tagged with , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: