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
I'm trying to run a MySQL query that returns rows in order by a value stored in a string (but it will also include the non-matching strings). This is not as easy as I would hope. Code inside!
[more inside]
posted by EduTek
on Apr 9, 2008 -
15 answers
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
What is the easiest (and free) method of exporting a MySQL database and getting it (intact) into Access ?
[more inside]
posted by Pogo_Fuzzybutt
on Apr 3, 2008 -
3 answers
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 best way to work databases like we does with version control (Subversion or CVS) for the source files?
I was researching but probably I'm not using the right words or there's some special way to work.
posted by Leech
on Mar 12, 2008 -
19 answers
Help me price out a server. I have a 10GB dataset from a company that I want to run SQL queries against. Right now on my MacBook they're taking ~12 hours to complete. Faster hardware is definitely needed!
[more inside]
posted by sbutler
on Mar 12, 2008 -
17 answers
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
I need to code a form to gather contact information from visitors to my website, and I'm looking for alternatives to mySQL.
[more inside]
posted by fvox13
on Feb 18, 2008 -
10 answers
Network admin / geek question:
I'm in the process of building a small cluster of servers for my quickly growing wallpaper website, but I've never charted those waters before. I found a nice article on TorrentFreak about
Mininova's server setup, and found it quite intriguing. My question is, are there any other big-ish sites like Mininova that are open about their hardware infrastructure? Googling around yielded few results. I'd be interested to see the setup for a site like Digg, MeFi, or Flickr. Thanks in advance.
[more inside]
posted by hmaugans
on Feb 16, 2008 -
5 answers
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
Is there a simple way to convert an XML feed into a MYSQL database?
[more inside]
posted by alse
on Jan 21, 2008 -
6 answers
How do you use a single authentication system for different kind of servers, systems, and workstations?
[more inside]
posted by remi
on Jan 11, 2008 -
6 answers
How do I query data from one MySQL table, but I also need to get a single piece of data from a second table too? Should I be doing a JOIN, or a separate query?
[more inside]
posted by gramcracker
on Jan 7, 2008 -
9 answers
Hi, I would like some recommendations for (preferably open source or inexpensive) web based software that I can implement for my church. Everyone takes turns bringing refreshments, playing songs, etc... and there are waaaaay too many "Who can do it on Sunday the 16th? on Sunday the 26th?" e-mails going around and it gets very confusing to keep track.
[more inside]
posted by apark
on Dec 12, 2007 -
10 answers
I've been trying to get a 600 record Excel database into MySQL, and failed at every turn. There must be a way!
[more inside]
posted by lemonfridge
on Dec 5, 2007 -
15 answers
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
MySQL monster query is timing out. Anything I can do about it? (Long question, possible a cure for insomnia.)
[more inside]
posted by maxwelton
on Nov 19, 2007 -
16 answers
Sum of data for all months, including months with no rows, in MySQL?
[more inside]
posted by tmcw
on Nov 15, 2007 -
7 answers
I'm determined to do this in one query. I sure I can, I KNOW you can.
Writing a tooltip retrieval system for a site with multiple versions of the same module. I want to supply a generic tip for each version level that can be overridden for a specific module. Diagrams = word x 10^3
[more inside]
posted by handybitesize
on Nov 12, 2007 -
9 answers
How do I dump a heavy-loaded 800MB MySQL table without affecting anything? I have a MySQL database serving data for a business-critical popular website. I need to grab the data from one of the tables, but cannot affect the website's performance in any way. I don't mind if it takes days to do it, as long as it affects absolutely nothing.
posted by lpctstr;
on Nov 9, 2007 -
17 answers
Where can I have a huge MySQL database hosted? My current host only allows databases of up to 100Mb in size, but I have one of just over 1Gb - anyone know a web host that will allow such a thing? (I'm in the UK if that matters.) Cheaply, of course!
posted by hatmandu
on Nov 2, 2007 -
5 answers
I have an idea for yet another hairbrained social networking website (which paradoxically might hit it big :-) ). I've coded most of it up on a linux server using apache, php, mysql at softlayer.com. The hostname is registered at godaddy (which I can change if desirable). What's the minimum I need to do the following (I'd rather work on the website application logic and learn as little as possible about mail server administration for now):
[more inside]
posted by realpseudonym
on Oct 23, 2007 -
8 answers
I've got the skills and knowledge, mostly, but I'd like to get a better workflow with PHP/MySQL development.
[more inside]
posted by tmcw
on Oct 11, 2007 -
15 answers
Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience?
[more inside]
posted by anonymous
on Sep 18, 2007 -
6 answers
Without access to PHP, MySQL, or any other fancy server-side stuff I still need to have dynamic pages. What are my options?
[more inside]
posted by genial
on Sep 12, 2007 -
11 answers
PHP/TransactionFilter: Designing a web application where users will have actual monetary accounts. What is the best way to approach this?
[more inside]
posted by ReiToei
on Sep 10, 2007 -
8 answers
I am going to be creating a website that tracks events, and I'd like the user experience to be easy and configurable. Can you recommend an event management software?
[more inside]
posted by al_fresco
on Sep 6, 2007 -
1 answer
Does anyone know of a good open source alternative to Navicat for MySQL?
[more inside]
posted by vitrum
on Sep 5, 2007 -
8 answers
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
How to do separation of public and private data on the web with PHP/MySQL? I'm creating a website for a business, with 2 sections - public and admin (staff). The admin section is secured with .htaccess and is intended to be used by office staff to enter customer requirements as they come in, and edit product listings. However, I worry about the security and suspect there is probably a better way.
[more inside]
posted by BishopsLoveScifi
on Aug 28, 2007 -
8 answers
MYSQL question: I want to develop simple input form for our internal office MYSQL. We need to attach files to our product information. I'm using OO, but it doesn't deal with BLOBs what other software could I use to create forms to our database?
[more inside]
posted by Yavsy
on Aug 20, 2007 -
6 answers
DATETIME, TIMESTAMP, TIME, DATE. Which should I use for general-purpose date storage in a recent MySQL version?
[more inside]
posted by tmcw
on Aug 20, 2007 -
16 answers
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
Very very
very stupid MySQL command line client question: how do I edit an earlier line of a multiple line statement?
[more inside]
posted by Lentrohamsanin
on Jul 27, 2007 -
8 answers
MySQL: How do I search and replace a value in a table under certain conditions:
[more inside]
posted by signal
on Jul 19, 2007 -
5 answers
What are the best database-driven Web application development frameworks out there right now? More specifically, please orient me to toolsets you know of that are similar to Ruby on Rails.
[more inside]
posted by killdevil
on Jul 6, 2007 -
17 answers
