我的程序中用到了这样的查询语句 String SchoolSql="select sid from school where sid<>;1"; ResultSet SchoolRs=aDBC.SelectDB(db,false,"",SchoolSql); if(SchoolRs!=null){ while(SchoolRs.next()){//351次循环 ResultSet stuRs = aDBC.SelectDB(db, false, "", "select count(id) from student where mphone>;='13500000000' and mphone<='13999999999' and sid in("+SI...
cpu 3.0 内存512台式机电脑. mysql> status; -------------- mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32) Connection id: 163 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.0.27-community-nt-log Protocol version: 10 Connection: localhost via TCP/IP Server characterset: ...
我先把问题描述一下,mysql不是很熟,请教各位高手了:) mysql 里有一表:(目前60个字段,有需要会动态增加,主键 reporttime,hostip ) mysql> desc QGG_Info; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | hostip | varchar(15) | |...