4.0.20 vs 4.1.16 issue

Hello all, I was running a legacy app on a MySQL 4.0.20 server. The app queried the server like this "SELECT count(total) as total from tbl_nada" For 4.0.20 the result of this query was an integer. Running the same query on 4.1.16 returns a much larger Integer and the app crashes. Problem

4.0.20 vs 4.1.16 issue

Hello all, I was running a legacy app on a MySQL 4.0.20 server. The app queried the server like this "SELECT count(total) as total from tbl_nada" For 4.0.20 the result of this query was an integer. Running the same query on 4.1.16 returns a much larger Integer and the app crashes. Problem

MySQL and dates puzzle

Hello all, I have a TA table to record TA UNAVAILABLE times. This table is quite simple. It has a TAID number, a start date and an end date. tbl_schedule { TAID integer, starts datetime, ends datetime } A valid entry would be a TA whose id is 1 and between 17:00 and 18:00 he is busy. So:

Re: SQL statement help

Another thing is that table2 might not have a match. C.F. Scheidecker Antunes wrote: I actually forgot something. I need a two statements into one. The reason is that table_two has multiple values, so I need the minimal ID from table 2.Thanks. Maybe I am working too much here and tired to

Re: SQL statement help

I think this would do it for you. UPDATE table_one t1, table_two t2 SET t1.ID = t2.ID WHERE t2.num = t1.num AND t1.ID = 0 J.R. -Original Message- From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED] Sent: Sunday, October 16, 2005 1:45 PM To: mysql@lists.mysql.com Subject: SQL

SQL statement help

Hello All, I have two MySQL 4.1 tables. The first table has an ID field which is set to zero. The second one has ID fields and filenames. I need a single SQL statement to set the ID from table 1 to the ID from table 2 ONLY IF the ID on one is zero. That is, if the ID on table one is not set (

A SQL statement to copy a blob from one table to another

Hello everyone: I have two tables that store a blob. They both have Id fields. What I would like to do is, given an id, copy the blob stored on table one to table two. I could do that in my java program by selecting and retrieving the blob from table 1 and then issuing a insert/replace statemen

Writing a file into a BLOB field with Java

Hello all, Does anyone knows howto insert a row in a database that has a blob field using Java? I need to read a file and then write it to a blob field on the database. Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Dates & Schedule Problems

Hello all, I have a little table o TAs (teach assistants) with the following MySQL schema: tbl_NotAvailable { TAid - int(11) StartDate - DateTime EndDate - DataTime } This table logs the times where TAs are NOT available. So If a TA is not available on Monday from 12:00 to Tuesday

Re: Storing manually diggested Passwords with MD5

By using a software this is easy but what I want to know is by using a simple query operation. Is there any functions that I can use inside a SELECT statement that would show the password decoded? Thanks, C.F. C.F. Scheidecker Antunes wrote: Hello all, Is there any function that I could us

Storing manually diggested Passwords with MD5

Hello all, Is there any function that I could use on a SQL statement to store a password on a table manually using an algorithm like MD5? Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

2 questions on Auto Increment fields

Hello all, I have two question on Auto Increment fields: 1) For what I see on the MySQL manual you can have an Auto Increment not null Field as the primary key. Say that you have a table with only two columns the first being an Auto_Increment. How do I write an INSERT or REPLACE SQL statement

Transactions in Java - JDBC

Hello, Can anyone tell me what to do in order to use transactions on a java application? Is there any howto regarding this issu? Thanks, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Still having problems with MySQL 4.1 on Fedora Core 3

Hello all, I now have disabled my SELinux and so it should work. However it still does not work. I have a bunch of errors now on my .err file that I am copying bellow. I've tried to create the tables again by issuing mysql_install_db and then tried to run the daemon. Is there any ideias on how to f

Problems installing MySQL 4.1 under Fedora Core 3

I have a Pentium III with Fedora Core 3 notebook and I need to install MySQL 4.1 on it. There was no mysql installed before so I've downloaded the packages and did what I usually do to install the packages. They install great. But when I try to run MySQL I have problems as it does not run. It tr

Re: Re : Problems installing MySQL 4.1 under Fedora Core 3

It only shows this: 050413 23:53:35 mysqld started 050413 23:53:35 mysqld ended Nothing conclusive. prasanna a wrote: Hi please cat the below error file and see /var/lib/mysql/presario2700.err __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhan

Problems installing MySQL 4.1 under Fedora Core 3

I have a Pentium III with Fedora Core 3 notebook and I need to install MySQL 4.1 on it. There was no mysql installed before so I've downloaded the packages and did what I usually do to install the packages. They install great. But when I try to run MySQL I have problems as it does not run. It tr

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

://home.earthlink.net/~jksteinkamp http://n7yg.webhop.org ___ Nothing is foolproof to a sufficiently talented fool. - Original Message - From: "C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> To: "Jeff Steinkamp" <[EMAIL PROTECTED]>

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

Hi Bob, Yes the ownership is correct. In fact I did a chmod -R mysql:mysql /var/lib/mysql and I still have the same problem. I wonder if it is because I am running a dual processor machine. Robert A. Rawlinson wrote: C.F. Scheidecker Antunes wrote: Hello Mr Paharenko, I have started it with

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

rding to the manual they should be installed automatically, when you're using RPM distribution. How do you start the MySQL server? "C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote: Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server.

Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.2

Experience with MySQL 5

Hello, Does anyone has experience with MySQL 5.x? How reliable is it? Is it compatible with JDBC, PHP and other drivers and connectors? Thank you, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Which PHP for MySQL 4.1

Hello, I would like to migrate my MySQL servers from 4.0 to 4.1. As I use PHP as well as Java with these servers I wonder what PHP 4 version would be compatible with MySQL 4.1. Has anyone used MySQL 4.1 with PHP yet? I appreciate your thoughts. Thanks. -- MySQL General Mailing List For list archi

More on MySQL server is taking all my hardrive space

Hello, On a further inspection and by reading Paul DuBois' I guess m y system has to many bin logs. How can I get ride of them? Thanks in advance, C.F. C.F. Scheidecker Antunes wrote: Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used

MySQL server is taking all my hardrive space

Hello, I have a server with 18Gb of space. I have ran du to figure out how the harddrive is being used and I realized that the directory that is taking the most space is /var/lib/mysql I know that now I have much less database records than I used to have and I have the same database structure h

Problems with mysqldump

Hello all, I have a remote server that has a harddrive almost full. Therefore I need to dump a huge table to my other host. OK, I've set the permissions so that I can log in to the server as root from my host. I've try to connect to it and it works. I have to do the dump to the host because the r

Figuring out the ranking position of an item on a table given its partnumber

Hello All, I have a table that has a PartNumber and the Quantity of Items sold for each partNumber, that is: PartNumber Qty I need to get its sales raking given its PartNumber, that is. So if I order the table by Qyt in descending order the first record will be the partNumber that sold the most.

Inserting records from one table to another respecting a condition

Hello all, I have two mysql tables. They have a slightly different structure but share comom columns. I need to get the top 100 sold parts ( partnumbers and quantities) from table Sales and insert into table Suggestion if I issue a query : SELECT partnumber,qty from Sales order by qty desc lim

Mysql 4.0.20, InnoDB my.cnf problems

Hello all, I would like to create InnoDB databases within MySQL. I have installed MySQL 4.0.20 and I have tried to uncomment the following on my /etc/my.cnf. MySQL is run on top of Fedora Core 2 Linux. # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysq

Function to extract difference in Minutes from DateTime variables

Hello all, I need to compare a datetime field in my database with the current time and return only the records that are 5 minutes old or older. Is there any way to do it? Any function to it? I use to_days() when I am doing the same thing but with days instead of minutes. Thanks in advance.

Selecting Date Time field, difference in minutes

Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before f