13 posts tagged with mysql and query.
Displaying 1 through 13 of 13. Subscribe:

Fixing an unreasonably slow MySQL query

Query and Explain output here. Query must be executed 4022 times, each with a different Strip_ID, while the script processes, adding 4+ minutes to what would otherwise be a ~90-second task. I have (separate) indices defined @ Parent_Table and Parent_ID, in addition to the table's primary key on an auto-incrementing ID. Adding combined indices for those two fields (in each order, just to be safe) did not change MySQL's analysis of the query or improve execution speed. [more inside]
posted by The Confessor on May 24, 2013 - 9 answers

MySQL: How to Selectively Update a Table from a CSV List?

MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
posted by darth_tedious on Nov 18, 2010 - 8 answers

mySql query assistance, please!

mySQL query question about calculating percentages in a table. [more inside]
posted by omnipotentq on Sep 5, 2010 - 3 answers

There's got to be a faster way to update

Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

How do I produce an inventory of my data in MySQL?

What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
posted by crapmatic on Dec 10, 2008 - 5 answers

Indexing a SQL table for efficient queries

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

What is the right combination of joins and select statements to get this information from a mysql database?

MYSQL newbie needs some help with a crazy query! (Joins, foreign keys, and bears "oh my!") [more inside]
posted by lucidreamstate on Feb 25, 2008 - 4 answers

How to count the number of times a string appears in a database field.

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers

MySQL import question

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

Converting Postrges-specific query to Mysql

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

SELECT answer FROM askmefi

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

Querying the Database

Database Query [+] [more inside]
posted by benjh on Jan 24, 2005 - 10 answers

Page: 1