Question

[紧急]mysql数据库查询太多怎么办？

# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:57:32
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:57:37
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:57:49
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 1 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:58:15
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:58:35
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:58:41
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 11:58:46
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 2 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
到底有什么好办法啊？我都快郁闷死了
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='0';
# Time: 100928 12:24:30
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 1 Rows_sent: 132358 Rows_examined: 132358
select * from jieqi_system_users` where uid='131584';
加什么代码啊，告诉我啊
是查询MYSQL
///////////////
我补充下问题:
要么在表名前面加上` 要么把表名后面的`去掉
不然where条件无效
如果这样做,会不会被SQL主入呢?

Answer 1

MYSQL是不能承载那么多数据的列表显示的，如果一下子查那么多数据，不是死机就是等待时间过长，不管是MYSQL数据，其它数据库也一样。你查询的方面要做一些转变，可以去掉*号，查询库表的某一列或几列，不要全表查询，或者你可以采取分页查询，其实你一下子查询100000多条数据你也看不完， 如果分页，则选择10000或者150000这样分页，就可以了。切记不要做数据量大的全表查询，想要知道表有多少条数据可以这样查询。selec count(*) from jieqi_system_users 。

Answer 2

你安装MySql的时候应该有Mysql Server Instance Config Wizad这个吧。进去这个重新配置sql就可以了。

如果对您有帮助，请记得采纳为满意答案，谢谢！祝您生活愉快！

vaela

Answer 3

select * from jieqi_system_users` where uid='0';

要么在表名前面加上` 要么把表名后面的`去掉
不然where条件无效

select * from `jieqi_system_users` where uid='0';
或者
select * from jieqi_system_users where uid='0';

Answer 4

上面那些输出 是哪里来的？

Answer 5

静态就可以了啊

Answer 6

不知道你要查什么。如果你只要输出1条

select * from jieqi_system_users` where uid='131584' limit 1；