Install RoR on Ubuntu 12.10 (note for myself)

Cause I am not used to BoPoMo, type in English for quickly record my process
spend over 4 hours for RoR enviroment building and Ubuntu Chinese input and something unfamiliar stuff

I follow this reference
http://developerdad.com/2012/11/20/how-to-install-ruby-on-rails-on-ubuntu-12-10/


however, the third step


pkgconfig should be pkg-config

reference:http://askubuntu.com/questions/226148/unable-to-locate-package-pkgconfig

the process not really follow the step, some error occured
but can be easily deal with by the hint
the command will show you how to install the thing you don't have

after installed rvm
do this job for using rvm function on terminal
https://rvm.io/integration/gnome-terminal/


install rails files not find:lib
reference: http://stackoverflow.com/questions/4129882/rails-3-install-error-file-not-found-lib

after all things done
type  irb can quickly calculate and execute ruby code
reference: http://www.slideshare.net/ryudoawaru/ruby1


Good tutorial i should read
https://speakerdeck.com/eddie/ruby-for-starter <<Teacher!
http://www.slideshare.net/ryudoawaru/ruby1
http://ihower.tw/rails3/index.html


=============================
some command:
back to home
cd ~ cd ..
http://hi.hiing.net/2008/11/terminal-introduction.html


stop terminal process
crel + c or z
http://ubuntuforums.org/showthread.php?t=1047348


easy, cute and funny terminal trivia skill
https://docs.google.com/viewer?a=v&q=cache:RWjCt546Xn8J:ftp://www.tmes.mlc.edu.tw/chaper8.pdf+ubuntu+%E7%B5%82%E7%AB%AF%E6%A9%9F+%E4%B8%8D%E5%8B%95&hl=zh-TW&gl=tw&pid=bl&srcid=ADGEESiaoetTL2ymQAYX4Ld0p0dIrJ0yLdHVqIQDuFQFzZL56dY45nwhM0uNfL3W0Y-dFCiXuv_YnteIYdZO8xvN9_JR_S5Mjd5Y95i507WENn-Z9UFWJ4vZMvUoXbV-lJ9yeoQfRe4c&sig=AHIEtbQ-eWzCvVDgsgaMR2KlZpTY_s-muA


===============================
Ubuntu note
VMware cannot display Ubuntu desktop Correctly
Answer: on vmware player Do "Edit virtual Machine settings" On "Hardware tab" go to "Display" Clear "Accelerate 3D graphics"
http://askubuntu.com/questions/215439/after-installing-ubuntu-12-10-the-desktop-does-not-display-correctly



1.StartX for Ubuntu GUI

2.ctrl + alt + F1 for Terminal mode
ps. but when type startx for caming back again to gui, it's empity desktop, dont know how to fix it, should take some time to research
http://ubuntuforums.org/showthread.php?t=1981250

3.ctrl + alt  T call out the terminal windows on GUI


Time for going to bed, i need more coffee tomorrow
I have to do the review job before the second class start

SQL的insert, delete 和 update

Insert

正常版本
INSERT INTO table_name (column1, column2, column3,···)
VALUES (value1, value2, value3,···);

簡化版本(但每一欄位必填)
INSERT INTO table_name
VALUES (value1, value2, value3,···);

僅輸入特定欄位
INSERT INTO customers (C_Id, Name, City)
VALUES (3, '李三', '高雄縣');

多筆輸入
INSERT INTO table_name
VALUES (value1, value2, value3,···),
(value2_1, value2_2, value2_3,···),
(value3_1, value3_2, value3_3,···),
······;

從其他table輸入資料
INSERT INTO table_name (column1, column2, column3,···)
SELECT othercolumn1, othercolumn2, othercolumn3,···
FROM othertable_name;

refrence: http://webdesign.kerthis.com/sql/sql_insert


------------------------------------------------------------

Delete
正常版本
DELETE FROM customers
WHERE Name='王二';

註：一定要加where，不然會整個資料表的資料會全清空

reference: http://webdesign.kerthis.com/sql/sql_delete


------------------------------------------------------------


Update
正常版本
UPDATE customers
SET Phone='03-87654321'
WHERE Name='王二';

註：一定要加where，不然會整個資料表的資料都會被更新

reference: http://webdesign.kerthis.com/sql/sql_update