mysql

引用

mysql> create database keyblocks;
mysql> use keyblocks;
mysql> create table keyblock(id integer, state integer, clientIP varchar(100), serverIP varchar(100));
mysql> insert into keyblock values(1,1,null, null);
mysql> select * from keyblock limit 10;

//not null的情况下,添加键
mysql> ALTER TABLE keyblock ADD PRIMARY KEY ( id );

引用

//查看数据库端口号
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.00 sec)

mysql>

引用

//查看数据表信息
mysql> show tables;
+----------------------+
| Tables_in_keyblocks  |
+----------------------+
| keyblock             |
+----------------------+
1 row in set (0.00 sec)
mysql>

引用

//添加一列
mysql>ALTER TABLE keyblock add id int;
//删除一列
mysql>ALTER TABLE keyblock drop id;

引用

eclipse 下java工程使用JDBC 连接数据库：
1. 从官方网站下载驱动： mysql-connector-java-5.1.15.tar.gz (当时的版本), 解压得到mysql-connector-java-5.1.15-bin.jar
2. 添加jar到eclipse中：Project/Properties/Java Build Path/Libraries/Add JARS/
3. ....

http://java.e800.com.cn/articles/2009/326/1238051257191_1.html