Re: comparing two databases

Is there a program out there that I can use to compare two databases? Just the structure, not the content. You might want to look into our development tool Database Workbench, it has a database compare tool as well: www.upscene.com Here's a screenshot/help:

Regular Exp help

Dear All, I have a table with a varchar column that stores data in this pattern: numberone_white_spacestringone_white_spacehyphen_symbol The pattern may be repeated upto 5 times in same cell, but the string will be different in each case. Hence there will not be a value like this: 1 BW -

Re: Regular Exp help

Ravi, Knight 4 to Pawn's 5! Sorry, being serious for a minute, you'd need more info to solve this problem. Your example implies that something without a number after it still counts for a value of 1, i.e. and 3 if I am searching for WT. Correct? What is the extent of the two letter

Re: comparing two databases

On Thu, 2006-09-28 at 15:06 -0500, Steve Buehler wrote: Is there a program out there that I can use to compare two databases? Just the structure, not the content. SqlFairy (http://sqlfairy.sourceforge.net/) has a sqlt-diff tool that will output the differences as a set of sql alter

Problem with subselect and primary keys

Can someone tell me what's wrong with this test: create table t1 ( course_id int(10) signed not null, primary key (course_id) ); create table t2 ( course_id int(10) unsigned not null, primary key (course_id) ); insert into t1 values

Encryption

Is there a simple way to encrypted data as it's being stored in a table? And then easily decrypted when it's queried? Sample syntaxs if available - thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Encryption

Hello, Have you taken a look at: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html That might give you a good start. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] Sent: Friday,

updating table but afterwards there are duplicate entries that violate a key..

Hi all, I have a table like this TABLE -- tagid taggerid objectid There is a primary key on (tagid, taggerid, objectid). First I remove that key, then I am changing the object id (because I've changed my objects), but what happens now is that I suddenly have duplicate (tagid, taggerid,

SELECT wird unterschiedlich ausgeführt

Hallo zusammen! Ich habe die Frage vor ein paar Tagen bereits ins MySQL-Forum gestellt, aber leider hat da noch niemand geantwortet. Jetzt versuche ich es mal mit der Liste. Wäre super, wenn mit jemand von Euch helfen könnte, weil ich hier nach Wochen des Probierens nicht weiterkomme: Ich

Re: updating table but afterwards there are duplicate entries that violate a key..

Peter Van Dijck wrote: Hi all, I have a table like this TABLE -- tagid taggerid objectid There is a primary key on (tagid, taggerid, objectid). First I remove that key, then I am changing the object id (because I've changed my objects), but what happens now is that I suddenly have

perl/dbi - insert into server2.db2.table2 select * from server1.db1.table1

Hi All, I have 2 separate mysql servers and need to import data from a table on sever1 to a table on server2. This would need to be done in Perl. The script in question already has open handles to both servers, so I know I can select all the rows from server1 and process them one by one and

Re: Problem with subselect and primary keys

Derek, I was able to replicate all the behaviors you describe in 5.0.21. I noticed you have a signed INT in one table and an UNsigned INT in the other. I changed t1 to UNsigned and then the query returns the results you would expect: +---+ | course_id | +---+ |-2 | |

Re: perl/dbi - insert into server2.db2.table2 select * from server1.db1.table1

George, that's probably about the easiest way you could do it in perl. If you want every column transferred you could do a SELECT * instead of enumerating columns I think. Dan On 9/29/06, George Law [EMAIL PROTECTED] wrote: Hi All, I have 2 separate mysql servers and need to import data from

Re: perl/dbi - insert into server2.db2.table2 select * from server1.db1.table1

| Hi All, | | I have 2 separate mysql servers and need to import data from a table on | sever1 to | a table on server2. This would need to be done in Perl. | | The script in question already has open handles to both servers, so I | know I can | select all the rows from server1 and process them

RE: comparing two databases

Some freebies: PHP: http://sourceforge.net/projects/phpmycomparer Perl: http://freshmeat.net/projects/mysqldiff/ Cheers, Andrew -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED] Sent: Thu, 28 Sep 2006 21:06 To: mysql Subject: comparing two databases Is there a

Help needed

Hi I'm having a problem compiling store procedure getting errors that don't make much sense. The problem is that I need to filter any value that is either NULL or an empty string an set to '0' character. SP is below CREATE PROCEDURE test () BEGIN DECLARE code VARCHAR(10) DEFAULT

Quick way to determine existence of an index?

Dear MySQL-ers, Using MySQL 5.0.24a, is there a quick way to determine which columns on a table don't have an index? I want to do sort of s recursive loop, and add indices for all columns which don't have an index yet (and that over many databases). Thanks, - Mark -- MySQL General Mailing

Running a Staging and Development DB on the same server?

I'm setting up our one server for staging and development. I am need to set up MySQL to have 2 copies of the same database on the same server. Could anyone direct me to some documentation or tell me how to do this? Thanks. -- MySQL General Mailing List For list archives:

Re: Quick way to determine existence of an index?

Mark wrote: Dear MySQL-ers, Using MySQL 5.0.24a, is there a quick way to determine which columns on a table don't have an index? I want to do sort of s recursive loop, and add indices for all columns which don't have an index yet (and that over many databases). Thanks, - Mark Sounds like

Re: Running a Staging and Development DB on the same server?

I'm setting up our one server for staging and development. I am need to set up MySQL to have 2 copies of the same database on the same server. Could anyone direct me to some documentation or tell me how to do this? Is there a reason you can't have one instance of the mysql server and simply

Re: Running a Staging and Development DB on the same server?

Jay Paulson wrote: I'm setting up our one server for staging and development. I am need to set up MySQL to have 2 copies of the same database on the same server. Could anyone direct me to some documentation or tell me how to do this? Thanks. What's wrong with having a test and production

communication error

The following is an example of an error in our mysql log files: [Warning] Aborted connection 1519045 to db: 'ES_buildings' user: 'esbuildweb' host: 'nrn7.nrcan.gc.ca' (Got an error reading communication packets) Is there some way to determine why/when that happens and to fix our setup so it

Joining *3* tables

Hello list I have a large database of contacts, but since not all fields are used I decided to separate all information in 3 tables to save space like this: DB_ADDRESS id int address char(128) ... three columns more ... DB_COMPANY id int company char(64) DB_LISTS id int list char(16) Not all

Re: Joining *3* tables

-Ursprüngliche Nachricht- Von: Renito 73 [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 30. September 2006 04:20 An: mysql@lists.mysql.com Betreff: Joining *3* tables Hello list Hello Mr 73, I have a large database of contacts, but since not all fields are used I decided to