Changes between Version 4 and Version 5 of NCHCCloudCourse100928_MYSQL

Timestamp:

Apr 25, 2011, 1:57:30 PM (13 years ago)

Author:

waue

Comment:

--

NCHCCloudCourse100928_MYSQL

@@ -11 +11 @@
 = 說明 =
 
- * 需先安裝 hadoop 0.20 , apache2 , MySQL 5 server & client 
+ * 需先安裝 hadoop 0.20 , apache2 , MySQL 5 server & client , phpmyadmin
+ * 需將 [http://dev.mysql.com/downloads/connector/j/ mysql-connector-java-*.jar] 放到 lib 目錄下
+
+{{{
+DROP TABLE IF EXISTS `school`.`teacher`;
+CREATE TABLE  `school`.`teacher` (
+  `id` int(11) default NULL,
+  `name` char(20) default NULL,
+  `age` int(11) default NULL,
+  `departmentID` int(11) default NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+}}}
 
  * MySQL 內，先建立一個school 的資料庫，內含 teacher 的table ，並新增一些資料，如下：