Jump to content

fenway

Staff Alumni
  • Content Count

    16,168
  • Joined

  • Last visited

  • Days Won

    3

fenway last won the day on November 8 2015

fenway had the most liked content!

Community Reputation

20 Good

1 Follower

About fenway

  • Rank
    MySQL Si-Fu / PHP Resident Alien
  • Birthday 07/08/1979

Profile Information

  • Gender
    Male
  • Location
    Toronto, ON

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. You can do magic with SUBSTRING_INDEX and POSITION, but I'm not sure you want to.
  2. fenway

    how to search only letters and numbers in tables

    You can use REGEXP -- but it won't be very efficient.
  3. fenway

    duplicate entry with a series number

    Duplicate should be referring to individual field values, not parts of a field -- storing delimited data that you need to consider separately is likely going to bite you soon enough, if it hasn't already. There's all sorts of tomfoolery you can do with FIND_IN_SET(), but I don't recommend it.
  4. Just post the EXPLAIN and we'll see how bad it is.
  5. fenway

    php and mysql transaction issue

    Very difficult to tell what you're fererring to -- but I'm assuming that your PHP code isn't actually *making* a table -- DML vs DDL matters.
  6. fenway

    Username changes

    Great, so how I am supposed to abbreviate that? .j? CV was so much easier.
  7. fenway

    Web Host List

    I've heard nothing but horror stories about them.
  8. fenway

    PHPFreaks Tutorials Wishlist

    Well, a scalar subquery, that is.
  9. fenway

    [SOLVED] MySQL problem

    What does the error log say?
  10. fenway

    Windows GUI for MySQL

    PHPMyAdmin is just a cumbersome tool for any but very basic things... if you want to edit 7 records at the same time, that would require about 100 clicks in PHPMyAdmin. It's just a very kludgy interface.
  11. fenway

    Windows GUI for MySQL

    Well, PHPMyAdmin is totally useless for just about everything... Navicat is fantastic, though often far too powerful, and not very free. The MySQL Query Browser is fairly good as well (the old Control Center has many, many bugs). Also, I use another tool, whose name I can't recall, for DB<->DB copying / backup.
  12. fenway

    Windows GUI for MySQL

    No offence, but PHPMyAdmin totally sucks if you want to edit 3 rows at a time without having to click a thousand times. It's fine for raw queries, of course, but if you want to do anything meaningful with a result set, you're out of luck.
  13. fenway

    Windows GUI for MySQL

    Have you tried the Query Browser? Also, SQLyog is also good, though the interface takes some getting used to. Obviously, Navicat is excellent, but not free. Personally, I still use the old MySQL Control Center, but only because the Query Browser is not supported under Win98. Hope that helps.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.