Sam,
if you like to get help (that's one of the things this list is made
for), then you need to give us the necessary information - without it,
all you can get is wild guesses:
sam rumaizan wrote:
> How do I insert data from a drop down menu (select box) to a table
In general, any question her
I have been wrestling with this problem for a couple of weeks and have been
unable to find a solution.
The MySQL version is 5.0.37 and it is running on a Slackware Linux 11 box.
The problem:
A query that is selecting data for a report locks the files that it accesses
forcing users who are att
A SELECT will/can lock a table. It almost always does in MyISAM (no
insert/updates), almost never does in InnoDB. There is an exception to
every rule. The problem is most likely in the 107488 rows part of the
query. That's too many rows for InnoDB to keep a version history on so
it's likely just lo
Hello.
I am running MySQL 5.0.45
and have the following query and error:
SQL query:
SELECT SQL_CALC_FOUND_ROWS CONCAT( 'Edit Space' ) AS '', CONCAT( 'Edit
Status' ) AS '', space_id AS 'Space ID',
TYPE AS 'Ad Type', scheme AS 'Scheme', adman_ad_spaces.status_approved
AS 'Approval Status', adman_a
On Tue, Mar 3, 2009 at 10:53 AM, Carl wrote:
> A query that is selecting data for a report locks the files that it accesses
> forcing users who are attempting to enter transactions to wait until the
> select query is finished.
Is it an INSERT INTO...SELECT FROM? Those lock. Also, have you
ver
My sent folder shows that I sent an email on this topic before I
finished editing it, but so far it hasn't shown up on the list. If it
does, my apologies. Apparently I shouldn't have skipped watching the
company training video on how to use our new email client!
We have a script that uses m
Just recently a script that backups up
Nevermind, the problem was not with the DB :\
On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney wrote:
> Hello.
>
> I am running MySQL 5.0.45
> and have the following query and error:
>
> SQL query:
>
> SELECT SQL_CALC_FOUND_ROWS CONCAT( 'Edit Space' ) AS '', CONCAT( 'Edit
> Status' ) AS '', space
On Tue, Mar 3, 2009 at 12:35 PM, Brent Baisley wrote:
> A SELECT will/can lock a table. It almost always does in MyISAM (no
> insert/updates), almost never does in InnoDB. There is an exception to
> every rule. The problem is most likely in the 107488 rows part of the
> query. That's too many rows
Use o código de desconto NOSSOSITE e receba 10% de desconto em todas as suas
compras
Temos os melhores preços do Mercado. Se você encontrar um preço menor não
faremos o mesmo preço.
Você esta recebendo este por causa da sua relação com Gemas Brasil . Por favor
confirme o seu interesse em rec
I'm using MySQL 5.0.67-0ubuntu6.
I'm stepping through "MySQL - 4th Edition". There's a simple table called
"member" that we've just added an index to, for the "expiration" column,
which is a date column.
The current example in the book is:
mysql> EXPLAIN SELECT * FROM MEMBER
> -> WHERE expir
My guess would be that your table is too small to bother using an
index on. There's some information in the MySQL docs about when it
chooses to use an index. For small tables, using one makes the query
slower.
- Perrin
On Tue, Mar 3, 2009 at 7:58 PM, David Karr wrote:
> I'm using MySQL 5.0.67-
12 matches
Mail list logo
