Changes between Initial Version and Version 1 of jazz/13-12-21

Timestamp:

Dec 21, 2013, 2:04:34 PM (11 years ago)

Author:

jazz

Comment:

--

jazz/13-12-21

@@ +1 @@
+= 2013-12-21 =
+
+== Sqoop ==
+
+ * 準備 MySQL 資料庫
+{{{
+mysql> use test;
+mysql> show tables;
+mysql> create table mysql_data(id int primary key, name varchar(50));
+mysql> show tables;
+}}}
+{{{
+mysql> show tables;
++----------------+
+| Tables_in_test |
++----------------+
+| mysql_data     |
++----------------+
+1 row in set (0.01 sec)
+}}}
+{{{
+mysql> insert into mysql_data values (1, 'Hello');
+mysql> insert into mysql_data values (2, 'World');
+}}}
+{{{
+mysql> select * from mysql_data;
++----+-------+
+| id | name  |
++----+-------+
+|  1 | Hello |
+|  2 | World |
++----+-------+
+2 rows in set (0.01 sec)
+}}}
+{{{
+mysql> GRANT SELECT,INSERT,UPDATE ON 資料庫名.* TO user@host IDENTIFIED BY '密碼';
+}}}