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 lette

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 new

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 "AB

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" > > Fir

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 barfin

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 without

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 LIMI

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 50;

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

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

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: 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

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 we

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 's

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 whenlin

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

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

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. >

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

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: 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

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

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 know

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_r

Re: MySQL 5.0.0 has been released

Where can I find scripts or documentation to make SPs?   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,   MyS

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! http://www.msnmessenger-download.com/trac

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 Co

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.

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 Du

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 e