NYCPHP Meetup

[Jim Hendricks]

MessageI wouldn't categorize mySQL a waste of database.

It depends on your needs.  Do you need a fast, small, cheap database which is easy to get into and use, or a advanced, expensive, database that takes months of studying to begin to utilize to it's best abilities?

Oracle, Sybase, MSSQL etc. have been available for quite some time, have many advanced features, but comes at quite a cost in money, maint, learning curve, and resources.  If you app needs high-end database functionality, then you have to be willing to part with some money, time, and resources.

mySQL on the other hand has not been around as long as the commercial products, and has at it's foundation a small footprint with the majority of the learning curve in learning SQL and has a very low price - free.  So far, mySQL has worked extremly well in many of my apps.  Sometimes I have to rethink my design because I am thinking too much in the "large db" mindset, but that's me, not mySQL.

It seems to me that you could really benefit from sitting down with the mySQL manual for a short spell, especially the part about mySQL Ansi 92 support.  It might be beneficial to also get aquanted with Oracle's proprietary aspects so you understand what features need a different solution because your assuming an Oracle feature is Ansi 92.

This would be true no matter what DB product you pick up.  I got my start in SQL with MSSQL.  When I tried to get into Oracle I was ready to call Oracle a piece of garbage because I couldn't do anything with it.  The joins were different, the allocations different, the stored procedure language different, the permissions systems different.  But after weeks of working with the product, I began to learn the Oracle way and realized my judgement of Oracle was not based on the merits/demerits of Oracle, but on my lack of knowledge of the product and what it's target audience is.

Jim
______________________________________________________________
Jim Hendricks, President, Biz Computing, Inc
Phone:  (201) 599-9380     Email: jim at bizcomputinginc.com
Web: www.bizcomputinginc.com 
Snail:  Jim Hendricks,  Biz Computing, Inc.,  255 McKinley Ave, New Milford, NJ 07646
______________________________________________________________

  ----- Original Message ----- 
  From: Phil Powell 
  To: NYPHP Talk 
  Sent: Sunday, September 21, 2003 2:17 PM
  Subject: Re: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


  I did, it seems that mySQL is becoming more and more of a waste of database!

  Can't do subqueries, can't do foreign key constraints, even the datetime field column datatype doesn't allow for the now() function as an input parameter value in INSERT?.. so tell me what GOOD is mySQL anyway????

  I rewrote the entire database table schema relational structure to include another association table and used that, flatting out the query.  However, it's really BAD coding because I have this query generating for every single $row['nnet_produkt_id'] from the outer query results.  BAD BAD BAD.. that means a while loop INSIDE another while loop!

  Can you say performance murder!

  Phil


    ----- Original Message ----- 
    From: Jeff Siegel 
    To: 'NYPHP Talk' 
    Sent: Sunday, September 21, 2003 1:46 PM
    Subject: RE: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


    You need at least ver. 4.1 of mySql. You may also be able to rewrite it.
    See: http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html

    Jeff Siegel
      -----Original Message-----
      From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On Behalf Of Phil Powell
      Sent: Sunday, September 21, 2003 11:54 AM
      To: NYPHP Talk
      Subject: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


      Ok guys, here we go again!

      SELECT s.nnet_produkt_storrelse_navn 
      FROM nnet_produkt_storrelse s, nnet_produkt_varegruppe v, nnet_storrelse_varegruppe_assoc sv 
      WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse id 
       AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id 
       AND sv.nnet_produkt_varegruppe_id IN (
         SELECT nnet_produkt_varegruppe_id 
         FROM nnet_produkt_varegruppe
         WHERE nnet_produkt_varegruppe_code =  'FLU17' 
       )
       AND s.nnet_produkt_storrelse_id > 1

      This produces the following error:

      You have an error in your SQL syntax near 'id AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id AND sv.nnet_' at line 1

      I don't see anything wrong with this query, it's standard inner SELECT stuff!  I need help... again!

      Phil


----------------------------------------------------------------------------


    _______________________________________________
    talk mailing list
    talk at lists.nyphp.org
    http://lists.nyphp.org/mailman/listinfo/talk



------------------------------------------------------------------------------


  _______________________________________________
  talk mailing list
  talk at lists.nyphp.org
  http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030921/69858552/attachment.html>