RE: Why MySQL?
On Fri, 2 Mar 2001, Evan James Dembskey wrote: > > I chose MySQL for our products because I could NOT get postgres to run > > on > > SCO Openserver, even though it was supposed to be supported. > > I tried for 2 months to get help on the postgress mailing list. > > Nobody offered ANY help. > > > > > Funny, I had the same experience. The only reason I am no learning > to use MySQL is because PostgresQL would not install on either my > Linux box or my DEC box. The postgres list was not helpful. > My current (personal) view on the debate is that PG is more advanced featurewise and they claim to be as fast. It's also much less user/admin-friendly and lacks (last I could tell) an important feature I've come to love (ALTER TABLE CHANGE ). However, mySQL is very fast. It's got virtually all of the features I need (row-level locking and transactions are what I'm waiting for to become stable). I've seen some stability problems but most were under Solaris. I look forward to it maturing and growing out of the "small to medium" range RDBMs that it's usually tagged as due to the (stable) lack of the two features I mentioned. By the way, found the -1 table handler problem. *sigh* Disk was at 100% usage on that partition. Got so used to scripts keeping track of disk usage I forgot to even consider that a possibility. Perhaps mySQL could so some testing to find the instances where it would get an error writing to the disk or temp file and indicate an error as such? I mean, you're going to get an error code back from your system (f)write call that indicates what the problem is... -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select problem
Can't you do something with SUM() to get the results, possibly in coordination with GROUP BY? --Nathan On 2001.03.01 23:49:28 -0500 Thalis A. Kalfigopoulos wrote: > Now that I notice more closely the numbers, my answer was obviously wrong > with regard to the 3rd column :o) > > Very interesting question...but I doubt there is a SQL way to do that. > Looking fwd to what the rest will sugest. > > cheers, > thalis > > > On Fri, 2 Mar 2001, Richard Vibert wrote: > > > Hi, > > At 01:52 pm 2/03/2001, Thalis A. Kalfigopoulos wrote: > > >On Fri, 2 Mar 2001, Richard Vibert wrote: > > > > > > > Hi, > > > > > > > > I having trouble working out how to get a result set similar to the > > > > following where I select from a table with Date & Sales column. > > > > > > > > My specific question is can I have a column that accumulates > values, if so > > > > could I have some guidance on how to express this in a select > statement > > > please. > > > > > > > > > > > > +--+---+---+ > > > > | Month| Sales | Cum Sales | > > > > +--+---+---+ > > > > | Jan | 1000 | 1000 | > > > > | Feb | 1500 | 2500 | > > > > | Mar | 1200 | 3700 | > > > > | April| 1400 | 5100 | > > > > +--+---+---+ > > > > > > > > Many thanks in advance. > > > > > > > > Richard > > > > > >I assume the query should be like: > > > > > >select MONTHNAME(date_col) as Month,count(sales_amount) as > > >Sales,sum(sales_amount) as Cum_sales from lala_table group by > > >MONTHNAME(date_col); > > > > > >regards, > > >thalis > > > > Thanks for your reply. > > > > This is not quite what I'm after. Count(sales) gives me the number of > sales > > transactions. > > > > The first two cols I write as monthname(date_col) as Month, sum(sales) > as Sales > > > > It's the next column that's got me. That needs to be a "Running total" > if > > you like. > > > > Richard > > =========== > > Richard Vibert > > [EMAIL PROTECTED] > > Tatura Mitre10 > > === > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1030: Got error -1 from table handler
Getting the above error message on one of our servers using mySQL. Went to go and set up WebCalender on it and tracked an issue down to mySQL. If I execute the query of: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231; It works fine and I get results back. However, if I add a simple ORDER BY, as in: mysql> SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date >= 20010201 AND webcal_entry.cal_date <= 20010231 ORDER BY webcal_entry.cal_time; Then I get "ERROR 1030: Got error -1 from table handler" returned back to me. I've shut down mysql (made sure no active processes left) and run isamchk -r on the ISM files. This was the output: # isamchk -r *.ISM - recovering ISAM-table 'webcal_entry.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_repeats.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_user.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_user.ISM' Data records: 2 - Fixing index 1 - - recovering ISAM-table 'webcal_user_layers.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_user_pref.ISM' Data records: 12 - Fixing index 1 # This did nothing to affect the problem. Some helpful info about the system: # mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) # rpm -qa | grep -i mysql MySQL-3.22.32-1 mysqlgui-static-1.7.1-1 MySQL-client-3.22.32-1 MySQL-devel-3.22.32-1 MySQL-shared-3.22.32-1 # uname -a Linux 2.2.14-5.0.14smp #2 Fri Jun 30 16:25:11 EDT 2000 i686 unknown # Any help appreciated. -- Nathan Clemons <[EMAIL PROTECTED]> 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
