Death of MySQL popularity?

http://www.mysql.com/products/ So the free version is going to include only MyISAM? And you won't be able to connect using MySQL Workbench (and presumably apps like MySQL Query Browser)? Otherwise you have to shell out $2k? Wow. I think it might be time to start seriously looking at Postgres..

Re: FW: Even or Odds numbers

ing a remainder of 0, or it'll have a remainder of 1. The former indicates the number is even, the latter odd. thnx, Christoph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Even or Odds numbers

1 it's odd. thnx, Christoph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: grabbing even addresses?

ut the house number then operating on it as above.You can read more about mysql and regular expressions here: http://dev.mysql.com/doc/refman/5.0/en/regexp.html thnx, Christoph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

UPDATE jujitsu?

Consider the folowing dataset: +++-+-+---+ | id| Name | Location| OnOffFlag | Description | +++-+-+---+ | 1 | Paper| Cabinet | 0 | Blah| | 2

Conditional Joins

oin those tables that are relevant based on the conditions set in the WHERE clause. Is something like this even possible? thnx, Christoph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: select records to send to another table in another database

> > I have a slew of records that went to the wrong database. The tables > > have the same names and now I want to copy those records over to the > > correct database. Is there such a mechanism using the cli mysql > > application in Linux? > For each corresponding table: > INSERT INTO db1.mytab

Re: select records to send to another table in another database

> I have a slew of records that went to the wrong database. The tables > have the same names and now I want to copy those records over to the > correct database. Is there such a mechanism using the cli mysql > application in Linux? If the tables have the same schema, you should be able to jus

What am I misunderstanding here?

data row. My expectation is that the second query should have returned the same 77 distinct resources from the first query along with any additional rows correlating to the relating data from the OUTER JOINed table. But that's not what's happening. Where am I going wrong here? thnx, Christoph

Result set flipped on it's axis

Let's say I have the following table: CREATE TABLE `Users` ( `id` blahblah, `firstName` blahblah, `lastName` blahblah, `phone` blahblah, `fax` blahblah, `email` blahblah ); If I do "SELECT id, firstName, lastName, email FROM Users, my result set is returned as follows: ++---+

Is this kind of ORDER BY possible?

| 9 Briggs| Hammer | 4 Briggs| Screwdriver| 1 Briggs| Wrench | 3 I know I can do this programatically after the fact while I'm processing the dataset but I'm hoping this can be achieved at the database level. Any information and/or advice would be appreciated! thnx, Christoph

Re: Does this MySQL client exist?

> > > How do you go about creating the tunnel? > There are lots of good tutorials online: > http://www.google.com/search?q=create+ssh+tunnel > Excellent. My thanks to you and to everyone who participated in this thread! thnx, Christoph

Re: Does this MySQL client exist?

over-SSH option > is very likely just creating the tunnel for you). How do you go about creating the tunnel? thnx, Christoph

Re: Does this MySQL client exist?

look at toad-for-mysql and NaviCat. thnx, Christoph

Re: Does this MySQL client exist?

; > preference) or use the command line. > > Use the mysql client, like so: > > #> ssh [EMAIL PROTECTED] > > [EMAIL PROTECTED] ~> mysql --user=dbuser --password somedatabasename > > Enter password: XXX > > mysql> SELECT blah blah... Right. That's the command line to which I referred above. thnx, Christoph

Does this MySQL client exist?

er of personal preference) or use the command line. I'm hoping that there is client software out there that can do what I'm looking for. Does it exist? thnx, Christoph

Re: Selecting just 'N' first rows

How can I send a query that retrieves only the first 'N' rows that match a condition? As far as I know you must call mysql_fetch_row() until the last row has been processed or the resources allocated won't be free. Am creating a program in PHP that should retrieve only 'N' records each time a qu

Re: Broken Tables, was:Memory Problems

Just for the logs: Finally I found the failure. It was the Raid-Controller (3ware). It seems that the 64-bit Kernel has troubles with this Device. I tried different mainboards with different controllers and the failure was reproducable with a 3ware-8000. I tried two of them. Cheers, Christoph

Re: Broken Tables, was:Memory Problems

Mike, I had the same failures without network. And it is a onboard-controller :-) Christoph > > Christoph, > Have you tried replacing the network card with the one from the > working machine? Network cards can cause problems under high load but will &

Re: Broken Tables, was:Memory Problems

Hi, It seems to be the Hardware somehow. I tested on another Machine with same OS, and everything seems to run now. I am using the same Memory so this is not the problem. Both Machines have hardware raid. The only thing left is the mainboard. Vey ugly. Cheers, Christoph On Friday 18

Re: Broken Tables, was:Memory Problems

ber of rows changed from 1143479 to 1143474  | | goolive.community_msgin | repair | status  | OK                                              | +-++--+--+ 4 rows in set (19.36 sec) Then the table is OK until I

Corrupted Tables, was:Memory Problems

mysqld: Sort aborted Repairing the tables worked. But it would take just some minutes until the tables got corrupted again. I tried mysql-5.0 from debian etch (5.0.32) ,4.1 from debian sarge (4.1.11) and 5.0 from debian-testing (5.0.38). All the same. Any hints anybody ? Cheers,

Broken Tables, was:Memory Problems

mysqld: Sort aborted Repairing the tables worked. But it would take just some minutes until the tables got corrupted again. I tried mysql-5.0 from debian etch (5.0.32) ,4.1 from debian sarge (4.1.11) and 5.0 from debian-testing (5.0.38). All the same. Any hints anybody ? Cheers,

Memory Problems

ysqld: Sort aborted I have set the sort_buffer_size to 1G but even this doesn't help. Any hints ? Should we try a 64Bit-OS ? Regards Christoph Kernel is a 2.6.18-3-686-bigmem from debian-etch. mysql> show status; +++ | Variable_name

newbie: select from a table, conditioned on the entry in another table

statement such as: SELECT* from A WHERE A_cond1 BETWEEN 1 AND 3 "and corresponding field B_cond2 = A" this would return A_cond1 A_link 1 aa 1 aa 2 dd 3 dd 3 dd many thanks for your kind help best regards Christoph -- MySQL General Mailing List For list arch

Re: newbie: how to sort a database without extracting the data

3 ie 02 what do you mean by adding an index thanks for your help cheers christoph Damian McMenamin wrote: add an index on the field. would be quickerthan any exporting importing. --- Christoph Lehmann <[EMAIL PROTECTED]> wrote: Hi I am really new to mysql. I need my database to be sorted a

newbie: how to sort a database without extracting the data

a new database and importing the old one but being sorted? many thanks for your kind help cheers christoph (p.s. I need this for later chunk-wise data-fetch with one chunk being homogenous in regard to one (the sorted) field) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

newbie: delete row xy

Hi I now how to use delete together with a WHERE statement. But e.g. after some warnings revealed me certain rows being inconsisent, and I want to delete them- how can I do this? I just know that I want to delete e.g row 1433 (I have no special id) thanks for a hint cheers christoph -- MySQL

connect with 'localhost' to a '%' host entry fails with mysql 4.0.13

his a feature or a bug in this MySQL Version? Thanks for help Christoph p.s. I tried it on two different servers, both times the same result, while with all the old 3.x servers around there is no problem with that. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Connecting to MySQL using OLEDB

Tell me what you do ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL ADODB -> MyOLEDB -> MySQL or anything else? first case: check "don't promt on connect" Did you create a data source? (First thing you don't need to do...) But whatever you do with VB, MS ADODB and MySQL - you will need

MyOLEDB-Provider - Some fixes by me

ort instructions on how to do this). best regards, christoph weber - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Re[2]: Join or smth.

select id, product, min(price), store from tablename group by product Better? Regards Chris - Original Message - From: "Ciprian Trofin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 1:24 PM Subject: Re[2]: Join or smth. > Doesn't work the way I want

Re: Join or smth.

select * from table_name where product like 'p1' order by price limit 1; - Original Message - From: "Ciprian Trofin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 11:20 AM Subject: Join or smth. > I have a table that looks smth. like this: > > id prod

Fw: ODBC Connection to Linux MySQL

take a look in the user table (database mysql). There should be a row like this... HostUserPassword localhost root ... means that the user root can connect from localhost (the mysql server) only. replace localhost by % or (better) insert a new row %

MS ADO (VB6.0) Problem with Updates

s.update ... ERROR: Row cannot be located for updating. Some values may have been changed since it was last read. Any suggestions? Or does anyone know where I can find more information about MySQL and ADO? Thanks, Christoph Lütjen

mit-pthreads needs select(2) prototype on NetBSD

Hi! Another patch for mit-pthreads under NetBSD. The newer gcc that is now used on NetBSD-current needs a prototype for select(2) to compile mysqld.cc otherwise it aborts with: mysqld.cc: In function `void * handle_connections_sockets(void *)': mysqld.cc:2314: implicit declaration of function `

setting a new default nice value

for mysqld -child processes. i set it manually, but how to do it automatically. has somebody done this ? thanks christoph - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Caching Bug with AUTO_INCREMENT columns

Does anyone know a workaround for this Problem? Executing the SELECT twice is not practicable for me! Thanks Christoph Schemainda How-To-Repeat: CREATE TABLE IF NOT EXISTS BugTest ( TestID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Name V