upgrade from 4.1 to 5.0

Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import

compare tables from two systems

We have two clusters running the same data independently and saving output to databases on two systems (two hosts) respectively. We need to compare the output each day. Is there an easy way to compare tables from two systems? We are sure the structure of the tables are all the same and we need to c

Re: strange order by problem

5| 2005-09-23 | | SWAP5| 2005-09-22 | +--++ --- Hassan Schroeder <[EMAIL PROTECTED]> wrote: > Claire Lee wrote: > > I need to order a few names by the number > following > > the main name. For example swap2, swap3, swap10 in > the > > order of swap2, swap3, swap1

strange order by problem

I need to order a few names by the number following the main name. For example swap2, swap3, swap10 in the order of swap2, swap3, swap10, not in swap10, swap2, swap3 as it will happen when I do an order by. So I came up with the following query: mysql> select distinct secname, date from optresult

add a column if not exists

I want to check if a column exists in a table before I do an alter table to add it. How do I do this in mysql? Thanks. Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL Genera

Can't connect to DB after upgrading to mysql 4.1.5

Hi, I have a perl script that connect to mysql using the following: my $dbh = DBI->connect("DBI:mysql:$dbname;host=$host","$dblogin", "$dbpasswd") or die "Cannot connect to $dbname: " . $DBI::errstr; But after I upgraded to 4.1.5 I get the following error message: DBI->connect(dbname;host=host) f

need help for a query

Hi, Here's a table of mine namedate changeDate n1d1 cd1 n2d1 cd3 n2d2 cd1 n4d1 cd2 n1d2 cd5 n5d1 cd4 n6d2 cd2 I need to select every name for which the changeDate corresponding

distinct based on two fields--please help

I have a table like this name price type A10 1 B30 2 A20 1 B20 2 would like to distinct based on name and type, do a sum and get the following result name price type A 30 1 B 50 2 How do I do this with one sql qu

distinct based on two fields

I have a table like this name price type A __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

SQL Query problem

Hi All, I have a query problem here. Say I have a table with employee records of three different departments. If each department manager wants to see employee info of their own department. Three different queries will be needed. Is there a way that I can write one single query and let SQL decide wh

porting Oracle schema to MySQL

Hi, I'm a newbie working on a big project. The idea is to transport an existing Oracle database at http://www.ebi.ac.uk/arrayexpress/ to a local MySQL server. The Schema, scripts and loader for Oracle can be found in the website. But how to create an exactly same database with mySQL? I have no clue

Problem starting up mysql

Hi all, I installed mysql 4.0.14 binary distribution on RedHat 8.0 following the instructions in the manual. But I can't get it to work. Please help. When I start mysql using the command: shell> bin/mysqld_safe --use=mysql & the following message shows: "Starting mysqld daemon with databases