[quote]
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 );
[/quote]
[quote]
//查看数据库端口号
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
[/quote]
[quote]
//查看数据表信息
mysql> show tables;
+----------------------+
| Tables_in_keyblocks |
+----------------------+
| keyblock |
+----------------------+
1 row in set (0.00 sec)
mysql>
[/quote]
[quote]
//添加一列
mysql>ALTER TABLE keyblock add id int;
//删除一列
mysql>ALTER TABLE keyblock drop id;
[/quote]
[quote]
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. ....
[url]http://java.e800.com.cn/articles/2009/326/1238051257191_1.html[/url]
[/quote]
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 );
[/quote]
[quote]
//查看数据库端口号
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)
mysql>
[/quote]
[quote]
//查看数据表信息
mysql> show tables;
+----------------------+
| Tables_in_keyblocks |
+----------------------+
| keyblock |
+----------------------+
1 row in set (0.00 sec)
mysql>
[/quote]
[quote]
//添加一列
mysql>ALTER TABLE keyblock add id int;
//删除一列
mysql>ALTER TABLE keyblock drop id;
[/quote]
[quote]
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. ....
[url]http://java.e800.com.cn/articles/2009/326/1238051257191_1.html[/url]
[/quote]