> -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
> dec
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
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 i
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 dat
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 h
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 a
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: http://lists.mysql.com
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 L
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 '
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 program
| 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 on
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 f
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 |
|
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 in
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
dupl
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 hab
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,
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, Sept
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:http://lists.mysql.com/[E
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
(1),(-1),(-2),(2),(3),(4),(5),(6),(7),(8),(65),(66),(67),(68
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 statement
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 co
Dear All,
I have a table with a varchar column that stores data in this pattern:
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 - 2.5 BW -
1 WT -
1 BW - 1 ME -
1 BW - 1 ME - 1.5 SY
23 matches
Mail list logo
