MySQL 5.0.0 has been released

Hi, MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Do to an unfortunate build

Re: 100,000,000 row limit?

Just to help you along, why test 100m when you can test 1b SELECT FORMAT(count(*),0) as one_billion_rows FROM test2.test_size 1,027,346,573 And so as we can see, mysql can handle pretty big tables. Rgds - Original Message - From: Andrew Braithwaite [EMAIL PROTECTED] To: 'Paul DuBois'

how to get data from one db to another?

hello, unter /data i have a directory (db) /working and another /change. in /working there are packed myisam-tables and they are used from a homepage (java, jsp). in /change new values are added to a innodb-database which will. because the changes shouldn't go immediately in production (i.e.

My sql download

Dear Sir/Madam, I would like to download MySql to my computer and I think I am not downloading the correct file. My computer is a Mac and the sytem is OS 10.1. Is there a version of MySql for 10.1? Thank you Laura

rollback..

I run update on the database which by my mistake updated all rows. Is it possible somehow go back to previous state before the update? _ Have fun customizing MSN Messenger — learn how here!

Re: MySQL 5.0.0 has been released

Where can I findscripts or documentation to makeSPs? Thnx! Alejandro ---Mensaje original--- De: [EMAIL PROTECTED] Fecha: miércoles 24 de diciembre de 2003 05:10:36 A: [EMAIL PROTECTED] CC: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: MySQL 5.0.0 has been released Hi, MySQL

Re: 100,000,000 row limit?

SQL :) We have ~1 200 000 000 rows in one MyISAM table. And it works :) I don't believe this. I'm going to write a script to disprove this theory right now.. We have a lot more than 100,000,000 more than that in a single MyISAM table at work: mysql select count(*) from probe_result;

Column name: CHECK

Hi Group, I use the column name CHECK (smallint), but when I insert into the table I get an error : Check the manual for: Check) values ( etc.etc. When I try to change the column name (alter table tablename change check blabla smallint) I get an error too, check your manual.. Does anybody

Re: Column name: CHECK

I use the column name CHECK (smallint), but when I insert into the table I get an error : Check the manual for: Check) values ( etc.etc. When I try to change the column name (alter table tablename change check blabla smallint) I get an error too, check your manual.. Does anybody know

Re: Delete items which aren't present in another table?

Adam Clauss [EMAIL PROTECTED] wrote: I have a table which maintains a list of categories and has a field called catID. This field is a one-to-many relationship with another table. What I want to do is remove any empty categories - aka: remove any categories which aren't used in the second

Query gift ?

I am using MySQL 4.0.16 on Xp. I have two tables, friend table and a gift table. I have to buy one gift per friend before tonight. How to do with mysql ?

Re: Query gift ?

I am using MySQL 4.0.16 on Xp. I have two tables, friend table and a gift table. I have to buy one gift per friend before tonight. How to do with mysql ? You cannot. MySQL doesn't buy any gifts for you. In other words: please describe the problem in more detail. What is the structure of

Re: Quering user privileges

On Tue, 23 Dec 2003 18:20:53 -0600 Paul DuBois [EMAIL PROTECTED] wrote: I confirm: SHOW GRANTS FOR CURRENT_USER(); does not work, while that query is exaclty what you expect to do reading mysql manual. I agree, one might easily come to that conclusion based on the wording. The manual

Re: Column name: CHECK

Have tried to use back sticks? Like `check` Thanks Emery - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 24, 2003 16:41 Subject: Re: Column name: CHECK I use the column name CHECK (smallint), but when I insert into the

Re: Quering user privileges

Yes, I think I will do it with an additional table on the db server, for the moment (I have no time to implement parsing etc...) The problem is, like you stated, to mantain that table up to date with changes in system tables. The best solution would be a trigger for this, but we haven't them at

Building mysql apps with CodeWarrior on Mac OS X

I'm tring to use CodeWarrior 9 to build a Mach-O target application on Mac OS X that uses the embedded mysql server library (libmysqld.a). I'm using the library that comes from standard Mac OS X binary distribution (the .dmg package). I can add libmysqld.a to the CodeWarrior project but

View SSL connections ?

Is there anyway to see what connection threads are using ssl and which ones are not ? ex: when i type mysql status; one of the returned lines is SSL:Cipher in use is DHE-RSA-AES256-SHA is there any way to see the status of other treads like this? or is there anyway the

Re: Quering user privileges

Plinio Conti wrote: Yes, I think I will do it with an additional table on the db server, for the moment (I have no time to implement parsing etc...) The problem is, like you stated, to mantain that table up to date with changes in system tables. The best solution would be a trigger for this, but

Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH

On Tue, Dec 23, 2003 at 07:07:57PM -0600, Matt W wrote: Hi Jeremy, - Original Message - From: Jeremy Zawodny Sent: Monday, December 22, 2003 2:20 PM Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote: Hi Mark,

Re: 100,000 row limit evil rumor spread by Larry Ellison and B. Gates

Really? I heard it was Hitler. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Prepared statements in MySQL 4.0

On Tue, Dec 23, 2003 at 04:12:37PM +0200, Yosef Teitz wrote: Jeremy writes: Please give 4.1 a try. Ah, yes - 4.1. I actually did quite a bit of testing on 4.1 alpha in July/August which is one of the reasons why we like MySQL, but I'm not sure that my management wants an alpha version in

Re: InnoDB size against MyISAM size

On Mon, Dec 22, 2003 at 04:57:00PM +0200, Eli Hen wrote: Hello, My HDD is running low and I MyISAM tables are keep crashing... Are the MyISAM tables crashing *because* you're low on space? If so, you need more space, *not* a new table type. I think that converting to InnoDB will be more

SELECT Optimization (speeding up a SELECT)

Hello there; I have the following mysql Select: SELECT ndc, ln, fdb.rndc.gcn_seqno, rt FROM fdb.rndc INNER JOIN fdb.rgcnseq on fdb.rgcnseq.gcn_seqno=fdb.rndc.gcn_seqno LEFT JOIN fdb.rrouted ON fdb.rrouted.gcrt=fdb.rgcnseq.gcrt WHERE ln LIKE '%%%' GROUP BY gcn_seqno, ln ORDER BY rndc.ln LIMIT

Re: SELECT Optimization (speeding up a SELECT)

On Dec 24, 2003, at 2:51 PM, David Kinyanjui wrote: SELECT ndc, ln, fdb.rndc.gcn_seqno, rt FROM fdb.rndc INNER JOIN fdb.rgcnseq on fdb.rgcnseq.gcn_seqno=fdb.rndc.gcn_seqno LEFT JOIN fdb.rrouted ON fdb.rrouted.gcrt=fdb.rgcnseq.gcrt WHERE ln LIKE '%%%' GROUP BY gcn_seqno, ln ORDER BY rndc.ln

Re: Column name: CHECK

Yes, I have used ` I don't think check is reserverd because I can CREATE the column name! From the mysql prompt its possible to insert a record, but not from my Delphi Code. After that i try to alter / delete the column but thats impossible. Other columns in the same table where altered

Error 5 during replication

Hi, I'm currently migrating users from an old 3.23.49 i686 server to a 4.0.16 amd64 server. Most of our users will have to change their code, and so I just set up the current server as a master and the new server as a slave, so that they can switch over at their leisure. Replication keeps

Re: Foreign Keys in CREATE TABLEs produced by mysqldump

Michael, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, December 24, 2003 1:45 AM Subject: Foreign Keys in CREATE TABLEs produced by mysqldump --=_alternative 008277CD88256E05_= Content-Type: text/plain; charset=US-ASCII First let

How to do case sensitive replace with wild card matching?

Ok, put your thinking caps on because this one bit of a toughie. I an Update statement that will insert a '/' in front of the *first* lowercase letter of a field value. Example: ABCDef becomes ABCD/ef. Of course it doesn't always end in ef and could be any 2 or 3 group of letters like ABcde

MySQL 4.x: Access denied for users when password is set...

Hi gang as subject says ... I've got a pretty weird situation. For all users I create in the 'user' table in 'mysql' DB, if I set a password, that user becomes unable to access any DBs ... it doesn't matter if I set the pw as ASCII or password, still won't allow access... I've tried making

Re: How to do case sensitive replace with wild card matching?

mos wrote: Ok, put your thinking caps on because this one bit of a toughie. I an Update statement that will insert a '/' in front of the *first* lowercase letter of a field value. Example: ABCDef becomes ABCD/ef. Of course it doesn't always end in ef and could be any 2 or 3 group of letters