Skip

332 posts tagged with mysql.
Displaying 201 through 250 of 332. Subscribe:

I just want a good time...

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

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 Command Line Client: editing lines of a multiple line statement?

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

Search and replace in MySQL

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

Other frameworks akin to Ruby on Rails?

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

XMHelp!! XML and MyPHPAdmin import problem

MySQL, PHPMyAdmin and XML imports/export problem... [more inside]
posted by SweetJesus on Jun 22, 2007 - 10 answers

name this bug

Why doesn't this code from O'Reilly's PHP and MySQL work for me? [more inside]
posted by Tuwa on Jun 16, 2007 - 16 answers

MySQL SLAVE, obey your MASTER!

MySQL, why won't you replicate properly? [more inside]
posted by ph00dz on May 29, 2007 - 6 answers

PHP Automagic

How do I put html form field values into a MySQL database and create the field if it doesn't exist, without declaring or manually updating every single variable? [more inside]
posted by IronLizard on May 12, 2007 - 14 answers

I'd like my DB to be full utf-8

help me convert a mySQL database to UTF-8. [more inside]
posted by Baud on May 12, 2007 - 3 answers

Form updates in PHP-MySQL

Rather than updating the entire table every time a user updates a form (their profile page, for instance), I'd like the quickest way to detect ONLY the edited fields, and update those accordingly. [more inside]
posted by arrowhead on May 10, 2007 - 13 answers

Does my dream email software exist?

I've been using Outlook for years, but I'm looking for a better solution to manage my email accounts and massive archive of messages. [more inside]
posted by justkevin on Apr 11, 2007 - 17 answers

Why has my hosting become so slow?

GoDaddy hosting has become intolerably slow: is it certainly their fault? If so, can I do anything about it? If it isn't their fault, what am I doing wrong? [more inside]
posted by sindark on Mar 29, 2007 - 9 answers

Building a Wiki through MYSQL

Which Wiki systems lend theirselves to allowing me to easily do an initial setup with MYSQL inserts to create the Wiki pages? [more inside]
posted by hodyoaten on Mar 12, 2007 - 4 answers

Can I Handle a PHP/MySQL site?

An 800 item database driven site in PHP and MySQL? Am I crazy? [more inside]
posted by mysterious1der on Mar 1, 2007 - 21 answers

Help a stupid noob find a good MySQL GUI program

Stupid MySQL noob question: is there a free/free (or at least free-as-in-beer) win32 MySQL frontend that will show graphical representations of tables, allow drag-and-drop editing of their relationships, actually import all of my data, and use MySQL vocabulary and syntax for its queries? [more inside]
posted by Tuwa on Feb 18, 2007 - 13 answers

Virtualization Recommendations

LAMPFilter: Which VPS solution (Virtuozzo, VMware, freeVPS, etc) is recommended for a small web-hosting company? [more inside]
posted by afx114 on Feb 16, 2007 - 6 answers

How to easily search/replace in MySQL database?

Is there an easy, preferably open source way of editing MySQL table contents? I was hoping for something which would let me use Excel (or OO Calc) to edit the live database. I need to search/replace many items in a poorly imported database. [more inside]
posted by Yavsy on Feb 6, 2007 - 10 answers

Compiling MySQL & DBD::mysql under cygwin

MySQL source vs 'devel' package quirkiness... [more inside]
posted by nomisxid on Feb 5, 2007 - 7 answers

Grant, Revoke, Grant, Revoke: Help my db

Help me restrict MySQL privileges for a particular table without screwing up access to the rest of the database. [more inside]
posted by Robert Angelo on Jan 24, 2007 - 2 answers

Programmers Block: List dates from unix timestamps w/o murdering the server.

Programmers block: I have a table in my database. It has events that occurred and the unix time stamp (seconds since the unix epoch) stored in it. I can't decide on the most efficient way (or even if there is one) to list the dates on which events have been recorded. [more inside]
posted by jcruden on Jan 24, 2007 - 3 answers

PHP MySQL database creator

There are so many ideas I can think of for websites, but don't have the full skills (or time to learn the skills) to generate the Php/Mysql code and interaction. Is there a good application that can create the coding and website for me, if I give it the right information?
posted by wibbler on Jan 13, 2007 - 11 answers

Easy PHP/MySQL Query question

PHPfilter- I need to select several records from a MySQL db, based on their audto_increment id in the db. I know the numbers, but for some (stupid for sure) reason I can't get it to pull the records. [more inside]
posted by Chuck Cheeze on Jan 7, 2007 - 6 answers

So I know HTML. What to learn next?

What web technology/language should I learn to make simple online apps and just generally enhance my bare-bones knowledge of HTML? [more inside]
posted by Robot Johnny on Dec 10, 2006 - 18 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

How can I use PHP to display a MYSQL datetime value without displaying the seconds?

How can I strip the seconds off when displaying a MYSQL datetime variable, using only PHP commands, not MYSQL commands like "DATE_FORMAT"? [more inside]
posted by Bugbread on Nov 28, 2006 - 14 answers

MFC Access Violation

Why does executing a SQL query via MFC's CDatabase class always result in an access violation? [more inside]
posted by b1tr0t on Nov 25, 2006 - 12 answers

MySQLfilter

Can anyone help a n00b with a MySQL (& coldfusion) problem? [more inside]
posted by juv3nal on Nov 20, 2006 - 12 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... why won't you accept more connections?

Mysql5... why won't you accept more connections from a set of IP addresses? [more inside]
posted by ph00dz on Nov 16, 2006 - 12 answers

MD5 and the probability of collisions...

MD5 and the probability of collisions... [more inside]
posted by twine42 on Nov 7, 2006 - 17 answers

mySQL/Drupal/phpMyAdmin

mySQL/Drupal/phpMyAdmin: I've got this error in my Drupal DB, and I understand what I'm supposed to do to fix it, but I don't know how to get jiggy in my database. [more inside]
posted by sciurus on Nov 6, 2006 - 5 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

mySQL table viewers?

Stupid database question: what are some quick "viewer" applications my customers can use to work with data I'm providing locally in a mySQL database? [more inside]
posted by hodyoaten on Nov 1, 2006 - 10 answers

PHP script generator

I need a PHP script "generator" to do Change/add/delete/edit on a MySQL database. Is there a auto generator of such a script? (I use 1&1 - with ssh and a shell, and a XP machine at home) Thanks!
posted by bright77blue on Oct 22, 2006 - 8 answers

My feet are wet - now it's time to get the 'swimsuit' part into the cold water.

Now that I'm getting familiar with PHP and MySQL et al, what should I add to my portfolio to make myself hirable? [more inside]
posted by cebailey on Oct 20, 2006 - 4 answers

MySQL String to Constrain Duplicates

MySQLFilter: I'm looking for a way to display a list of recent entries from multiple blogs I have stored in a MySQL database, but allow only one entry per blog to be included in the list. What should I add to the WHERE clause? [more inside]
posted by DIYer on Oct 11, 2006 - 12 answers

Can you help me find a complex program control structure in php?

I'm writing a php/mySQL script to create new records in my GOALS table by comparing all possible combinations of one or more records from my EXPENSES table with information pulled from my ACCOUNTS table. The actual comparison and record generation should prove relatively simple, but the 'all possible combinations' bit is kicking my butt. I simply cannot fathom a control structure that will facilitate that requirement. [more inside]
posted by The Confessor on Oct 10, 2006 - 9 answers

Bootleg Trading Software?

Are there any free PHP and MySQL based apps for setting up a bootleg trading site? [more inside]
posted by SansPoint on Sep 27, 2006 - 2 answers

Help me improve my PHP and MySQL skills with useful resources on the web.

Help me improve my PHP and MySQL skills with useful resources on the web. [more inside]
posted by MetaMonkey on Sep 25, 2006 - 10 answers

MySQL performance tuning

How to improve MySQL (5.0.22-max-log, PPC) + InnoDB table performance? [more inside]
posted by Blazecock Pileon on Sep 24, 2006 - 9 answers

How to make sense of a pile of call center data?

I've been tasked with analyzing call records for a small software support call center. Neither I nor the company have ever done this kind of thing before and I'm not sure what to do. [more inside]
posted by cdavis on Sep 20, 2006 - 3 answers

MySQL, Help me search tags!

MySQL Help! I am trying to use tags on my web site. I am trying to allow users to search for tags. I want the users to do a search like "castle+moat-ducks" and return all pages that have the tags castle and moat but DO NOT have the tag duck. How can I do this? There is a single tag table, which contains 3 fields, tag_id, image_id and tag, which holds the actual text of the tag. Please help me set up the proper query! Note that I am using PHP.
posted by LoopyG on Sep 19, 2006 - 29 answers

ruby/python database tutorial?

I'm searching for a simple ruby/python database application tutorial. A long time ago, like six years ago, I came across this simple tutorial for php/mysql that showed you, from the ground up, how to put a simple database of your video collection online. Is there a similar tutorial that emphasizes creating a simple front-end for a mysql database using ruby or python, geared toward n00bs? [more inside]
posted by mecran01 on Sep 12, 2006 - 5 answers

Zip Code Radius Searches That Aren't Painful

What is the best strategy to limit using processing resources in doing a zip code radius query? (explained inside) [more inside]
posted by JakeWalker on Aug 28, 2006 - 12 answers

How can I preserve Unicode characters in `mysqdump`?

How can I make backups of a MySQL database (via mysqldump) and preserve Unicode characters (such as em dashes)? [more inside]
posted by cmyers on Aug 28, 2006 - 8 answers

Japanese PHP/Mysql development tips?

About to create a PHP/MySQL CMS and web site for a client entirely in Japanese, what do I need to know? [more inside]
posted by malphigian on Aug 28, 2006 - 7 answers

MySQL help!

Please help me create a MySQL database from a collection of images. There is of course [more inside]
posted by LoopyG on Aug 27, 2006 - 10 answers

Stop the Spam!

I am getting spam to addresses picked up from a PHP mail script - can I stop this? [more inside]
posted by jontyjago on Aug 20, 2006 - 13 answers

Page: 1 2 3 4 5 6 7
Posts