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 on Aug 19, 2008 - 6 answers
I'd like to reconstitute a years-defunct wiki I used to collaborate on. I've contacted the principals, & our searches for the database backup have come up empty so far. Without having the original database, the simplest path appears to be taking the html & transforming it into, say, an sql dump. So - how do I do that? Are there any MediaWiki, database, or Perl trails to follow?
posted on Aug 6, 2008 - 10 answers
I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted on May 29, 2008 - 4 answers 
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 on May 4, 2008 - 12 answers
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 on May 2, 2008 - 8 answers
How much SQL normalization is too much? [more inside]
posted on Apr 25, 2008 - 21 answers
SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted on Feb 21, 2008 - 6 answers
Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch? [more inside]
posted on Jan 23, 2008 - 11 answers
What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted on Jan 15, 2008 - 3 answers
Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted on Nov 19, 2007 - 12 answers
Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted on Nov 15, 2007 - 7 answers
ColdFusion MX 7 and Microsoft SQL Server 2005. There's a lot of unvalidated parameters in our CFQUERYs. But, I'm told that putting the parameters in single-quotes will prevent injection attacks, because of the way ColdFusion escapes single-quotes. Is this foolproof, or do I have to go in and validate everything with CFQUERYPARAM tags?
posted on Oct 22, 2007 - 3 answers
Can I, should I, make a career change into database design? [more inside]
posted on Sep 25, 2007 - 16 answers
Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
posted on Sep 25, 2007 - 4 answers
What is the prefered way to represent status changes over time in a relational database? [more inside]
posted on Sep 4, 2007 - 17 answers
Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations. [more inside]
posted on Aug 15, 2007 - 25 answers
Need some help with MS SQL text replacement. [more inside]
posted on Jun 18, 2007 - 15 answers
What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted on Jun 10, 2007 - 3 answers
Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted on Jun 6, 2007 - 5 answers
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted on Apr 18, 2007 - 9 answers
Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help. [more inside]
posted on Jan 31, 2007 - 20 answers
How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted on Jan 24, 2007 - 5 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted on Dec 13, 2006 - 3 answers
mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted on Dec 5, 2006 - 10 answers
SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside. [more inside]
posted on Nov 21, 2006 - 14 answers
What is the easiest way to get this data into a MySQL database? [more inside]
posted on Nov 2, 2006 - 19 answers
SQLServer Express remote connection problems. Please hope me! [more inside]
posted on Nov 2, 2006 - 9 answers
SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted on Oct 21, 2006 - 4 answers
Help! Stumped by an SQL problem. [more inside]
posted on Oct 21, 2006 - 21 answers
I have a question about finding the longest sequence in a set of numbers. [more inside]
posted on Sep 2, 2006 - 13 answers
MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted on Jul 19, 2006 - 12 answers
How can I increment a value directly using SQL? [more inside]
posted on Jul 17, 2006 - 3 answers
I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted on Jul 14, 2006 - 14 answers
Calling all SQL / DBA / code monkey brainiac's! Please help me understand what is happening in this mess .... [more inside]
posted on Jul 3, 2006 - 8 answers
SQL WTH: various examples given on websites and in a small stack of books don't work. [more inside]
posted on Apr 15, 2006 - 9 answers
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted on Apr 7, 2006 - 6 answers
I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students?
[more inside]
posted on Mar 17, 2006 - 6 answers
How can I import selected fields from one database into another database? [more inside]
posted on Mar 16, 2006 - 6 answers
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports. [more inside]
posted on Feb 15, 2006 - 31 answers
What is the best alternative interface for an SQL server? [more inside]
posted on Jan 12, 2006 - 6 answers
How do I write arbitrary SQL queries in Ruby on Rails? [more inside]
posted on Dec 13, 2005 - 9 answers
SQL: Virtual Grouping? [more inside]
posted on Dec 13, 2005 - 9 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted on Dec 9, 2005 - 9 answers
I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted on Nov 29, 2005 - 18 answers
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 on Sep 30, 2005 - 2 answers
Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
posted on Apr 17, 2004 - 15 answers
