---
title: "mysql och poster"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/74352-mysql-och-poster"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "jboy_87"
published: "2003-04-17T18:42:11.000Z"
updated: "2003-04-19T17:13:29.000Z"
replies: 3
views: 210
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/74352-mysql-och-poster"
---

# mysql och poster

## #1 — jboy_87, 2003-04-17T18:42Z

När jag försöker retunera alla poster i tabellen i control center så får jag följande felmess:

```
ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
```

jag har kollat i odbc inställningar och kryssat i Allow big results men funkar fortfarande inte?

 :q

Permalänk: https://www.webforum.nu/p/74352

## #2 — LarsG, 2003-04-19T15:16Z

Såg följande

> /\* Quoted from someone nice:
> 
> He means :
> 1 - go to the far left window pane labeled ""MySQL Servers"
> 2 - right-click on the server name (mine is root@localhost:3306)
> 3 - select "Edit". This brings up a window with tabs, the 2nd of which
> is
> labeled "MySQL Options"
> 4 - On this tab is the option "Automatically limit SELECT queries to"
> and
> the default = 1. (WHO thought up this default?)
> 
> I set my limit to 10000, since some of my queries return more than 1000
> records...
> 
> End quote. \*/

Permalänk: https://www.webforum.nu/p/1017190

## #3 — jboy_87, 2003-04-19T17:12Z

nähe den vill inte funka!

Bilagor:

- [myshit.gif](https://www.webforum.nu/a/1299.gif)

Permalänk: https://www.webforum.nu/p/1017239

## #4 — jboy_87, 2003-04-19T17:13Z

nu funka det när jag kryssa i Allow the use of bla bla

Permalänk: https://www.webforum.nu/p/1017240

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/74352-mysql-och-poster