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
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
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
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',
On Tue, Mar 3, 2009 at 10:53 AM, Carl c...@etrak-plus.com 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.
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
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 phpmy...@gmail.com 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
On Tue, Mar 3, 2009 at 12:35 PM, Brent Baisley brentt...@gmail.com 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.
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
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 expiration
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 davidmichaelk...@gmail.com
12 matches
Mail list logo
