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
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
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:
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
, but 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
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
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
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:
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
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]
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 use on a SQL statement
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]
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
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
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
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
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
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.
I am trying to install MySQL 4.0.24 as I usually
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
://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]
Sent: Monday, March 14, 2005 10:52
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
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]
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
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
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 and I
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
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
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
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 =
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.
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
31 matches
Mail list logo