看了这么多帖子,有点小建议给发帖人,发帖的时候,最好能给出比较详细的信息,比如 操作系统,数据库版本 表结构 建表语句 以及部分数据 然后写出想要达到的效果
关于操作系统 就不多说了,其他相关信息的取出也很简单的,以windows为例,进入cmd后,单击鼠标右键,有个标记粘贴,可以很轻松的把命令模式下的内容粘出来,以下为实例:(横线分隔的部分为粘贴的)
------------------------------------------------------------------------
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
d:\>cd mysql
d:\mysql>cd bin
d:\mysql\bin>mysql -u root -p -h 192.168.40.101
Enter password: ****************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 6.0.7-alpha-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use kmyy
Database changed
mysql> show tables;
+----------------+
| Tables_in_kmyy |
+----------------+
| gs_dn_ll |
| gs_dn_mx |
| gys_jf |
| ms_errcode |
| pbcatcol |
| pbcatedt |
| pbcatfmt |
| pbcattbl |
| pbcatvld |
| weblog |
+----------------+
10 rows in set (0.23 sec)
mysql> desc gys_jf;
+-------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+----------------+
| ID | int(11) | NO | PRI | NULL | auto_increment |
| jfrq | date | NO | | NULL | |
| dwmc | varchar(100) | NO | | NULL | |
| je | decimal(10,0) | NO | | 0 | |
| yxq | date | NO | | NULL | |
| meno | varchar(200) | YES | | NULL | |
+-------+---------------+------+-----+---------+----------------+
6 rows in set (0.36 sec)
mysql> show create table gys_jf;
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------+
| Table | Create Table
|
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------+
| gys_jf | CREATE TABLE `gys_jf` (
`ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
`jfrq` date NOT NULL COMMENT '缴费日期',
`dwmc` varchar(100) NOT NULL COMMENT '单位名称',
`je` decimal(10,0) NOT NULL DEFAULT '0' COMMENT '缴费金额',
`yxq` date NOT NULL COMMENT '有效期',
`meno` varchar(200) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`ID`),
KEY `AK_Key_id` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COMMENT='供应商流向缴
费记录' |
+--------+----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------+
1 row in set (0.05 sec)
mysql> select id,jfrq,je,yxq from gys_jf limit 10;
+----+------------+-----+------------+
| id | jfrq | je | yxq |
+----+------------+-----+------------+
| 1 | 2008-02-26 | 0 | 2008-12-30 |
| 2 | 2008-02-27 | 300 | 2008-12-31 |
| 3 | 2008-02-27 | 300 | 2009-01-31 |
| 4 | 2008-02-27 | 0 | 2008-12-31 |
| 5 | 2008-02-28 | 300 | 2008-12-31 |
| 6 | 2008-03-18 | 300 | 2008-03-18 |
| 7 | 2008-03-27 | 0 | 2009-02-28 |
| 8 | 2008-03-04 | 300 | 2009-02-28 |
| 9 | 2008-03-04 | 0 | 2009-02-28 |
| 10 | 2008-03-11 | 0 | 2009-01-31 |
+----+------------+-----+------------+
10 rows in set (0.08 sec)
mysql>
------------------------------------------------------------------------
从上面可以清楚看到 操作系统版本,数据库版本、表结构、建表语句及数据,把这些内容提供出来,我想会方便别人测试盒回答问题。 |