Join 3,418 readers in helping fund MetaFilter (Hide)

42 posts tagged with sql and mysql. (View popular tags)
Displaying 1 through 42 of 42. 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

Am I SQL to the task?

I'm a full-time freelance web designer and developer for a wide variety of clients. One of my clients just asked me to build a web site them but it turns out that what they really want instead is a user registration system that has a rewards component. Can I beg, borrow or steal something that's already built, or should I get out now before I get in too deep? [more inside]
posted by lgandme0717 on May 14, 2012 - 1 answer

i need a database!

[Python/database filter] I wrote a script in python for a class and I want to challenge myself now to make it attached to a database... [more inside]
posted by handbanana on Aug 26, 2011 - 8 answers

What do I need to know to fill in the gaps?

Looking for books and articles on programming, design patterns, information architecture, and whatever else. Clear information on Things To Do and Things To Avoid, with a smattering of theory and opinion, would be great. [more inside]
posted by jsturgill on Aug 23, 2011 - 5 answers

How do I collect dictionary definitions for ~350 words to put into a database?

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

Database diagram -> sql

Help me find a program (Windows / preferably free) that draws database diagrams and then creates the relevant SQL... [more inside]
posted by sodium lights the horizon on Jan 26, 2011 - 5 answers

CALL ask_metafilter();

I think MySQL procedures and temporary tables are the bee's knees - am I Doing It Wrong? [more inside]
posted by Dr Dracator on Oct 17, 2010 - 12 answers

SQL JOINs are driving me crazy

Help me dig myself out of an SQL hole involving crazy multiple joins. [more inside]
posted by le morte de bea arthur on Sep 1, 2010 - 14 answers

Teaching MySQL to Total Beginners?

I've just been put in charge of teaching two executives in my company how to use MySQL. Oh dear God, please help me! [more inside]
posted by fogster on Apr 16, 2010 - 14 answers

How to compile WordPress author stats from a database

Where to find WordPress post view stats. [more inside]
posted by thelastenglishmajor on Mar 25, 2010 - 6 answers

What interesting statistical information can I dig out of this medical billing data?

What interesting statistical information can I dig out of this medical billing data? [more inside]
posted by neilkod on Nov 19, 2009 - 8 answers

SQL Query Question

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

Copy-Down in SQL

Is there a GUI SQL editor that emulates a spreadsheet-style "copy down"? If not, is there a technique I should learn? [more inside]
posted by rokusan on Apr 14, 2009 - 10 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

Upsize Access database?

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

SQL puzzle

SQL puzzle, MySQL in particular. [more inside]
posted by xmutex on Feb 10, 2009 - 15 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

Database suggestions

Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted by spakto on Aug 19, 2008 - 6 answers

SQL statement that returns table and field names in MySQL

Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)? [more inside]
posted by joemako on Jul 7, 2008 - 8 answers

PerHaPs SeQuentiaLly?

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted by prophetsearcher on May 4, 2008 - 12 answers

SQL sorting when sort field is null

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted by dnash on May 2, 2008 - 8 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 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

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

How is Facebook doing its queries?

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted by bonaldi on Feb 4, 2008 - 27 answers

Tricky SQL for a simple function

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted by arrowhead on Nov 23, 2007 - 14 answers

All months, now.

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

Need SQL help to fetch data, with some tricky conditions

From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted by arrowhead on Sep 3, 2007 - 10 answers

This sql query should be simple...

I'm trying to merge simple contact data from a bunch of single tables into one big text (csv) dump. The problem is that not all fields are present for each user. e.g. one user may be missing an email. Because of the missing field, my current (big and ugly) sql query will not return all the rows. [more inside]
posted by kamelhoecker on Aug 2, 2007 - 13 answers

MySQL query query

Help with troublesome MySQL query? [more inside]
posted by cdavis on Dec 6, 2006 - 8 answers

How to get mySQL to ignore "A, An, & The" when presenting alphabetized book titles

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted by Wild_Eep on Dec 5, 2006 - 10 answers

Know any dead trees that can teach me about php and MySQL?

Recommendations for a book to teach myself php and MySQL? [more inside]
posted by dripdripdrop on Nov 20, 2006 - 8 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

No, no—*million* with an M.

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted by disillusioned on Jul 19, 2006 - 12 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

PHP/MySQL question on search / sort

I'm writing a small app to store my contacts. There's a little tool to search for names. When I search for "Jo", the results should display all names starting with "jo", followed by those with "jo" in the middle: 1. Joanna 2. John 3. Jonathan 4. Marjorie 5. Mojo How do I do this using a single SQL statement?
posted by arrowhead on Mar 9, 2006 - 14 answers

Easy Interface for SQL

What is the best alternative interface for an SQL server? [more inside]
posted by benjh on Jan 12, 2006 - 6 answers

Need SQL lessons

I need to learn SQL, presumably mySQL. [more inside]
posted by captainscared on Jan 4, 2006 - 22 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

Can FileMaker have hooks into MySQL?

I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
posted by mark7570 on Sep 30, 2005 - 2 answers

PhProblems

myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI] [more inside]
posted by twine42 on Nov 4, 2004 - 8 answers

MySQL

mysqlfilter: I'm in the midst of installing phpwiki on OS X panther and, because I am following the steps drone-like and have no idea what I am doing. . . [more inside]
posted by mecran01 on Sep 13, 2004 - 8 answers

Page: 1