I searched all over and can't seem to find out how to take an average of
every x number of rows from a result set.
I have a table with over 700,000 rows, and I want to display an x and y
graph of that data on the web. What is happening now is I'm creating 2
arrays, one for the x axis and one for
In the last episode (Apr 13), Cesar Bonavides Martinez said:
I'm working with Solaris 8, and MySQL 4.0.17-standard.
I was trying to upload data into a single table database and when it
reached 2GB it stopped uploading sending the error message:
ERROR 1030 at line 2450: Got error 27 from
Just thought I'd share my experience with MySQL under Panther. I think
the critical thing that got me going was that the /usr/local/mysql/data
directory was owned by root instead of mysql. I changed that (chown
mysql /usr/local/mysql/data) and everything seems to be a) Hunky b)
Dory, thanks
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
homauoon mahboobi [EMAIL PROTECTED] wrote:
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
What is exactly wrong with mysql program?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hello sir
Are you support Arabic character set an collations in my sql 4.1?
I work with mysql 4.0 and store Arabic data on it,but i cant sort
my varchar data.Is this problem solved when i upgrade mysql 4 to 4.1?
Please help me.
Sincerely yours.
homauoon
Hello sir
Are you support Arabic character set and collations in my sql 4.1?
I work with mysql 4.0 and store Arabic data on it,but i cant sort
my varchar data.Is this problem solved when i upgrade mysql 4 to 4.1?
Please help me.
Sincerely yours.
homauoon
The staff on the other hand, is thinking in using
ORACLE, and I need very solid arguments to beet them. Any ideas I can
borrow?
There is really only two arguments against Oracle as a DBMS - price and
closed source. But then you have to ask what the argument is against MySQL.
When I
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
This was the answer for my installaton on Panther, as well. Scott's
instructions provide those extra commands you might need. I thought I had
followed the standard installation instructions VERY carefully, and yet I
got stuck. This got me through . . . .
on 4/14/04 12:26 AM, Daniel Lahey at
Hi there i was wondering if its possible to have two auto-inc fields ? I am
having to generate ticket numbers and i want it to look like DEP-1,
DEP-2, NEW-1, NEW-02 where NEW and DEP are the first 3 letters
of of the department associated with the ticket. How is this possible ?
Hi,
is it (mysql v5.0) or might it once be possible, to 'return' a cursor as an out
parameter from a stored procedure?
In MS SQL Server a stored procedure can return a 'recordset' by simply defining a
select statement. In ORACLE one can define a ref cursor output parameter and 'fill' it
within
nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so long as your running numbers are the same...we use this for our helpdesk
system too :)
good luck.
- Original Message -
From:
homauoon mahboobi [EMAIL PROTECTED] wrote:
Are you support Arabic character set an collations in my sql 4.1?
I work with mysql 4.0 and store Arabic data on it,but i cant sort
my varchar data.Is this problem solved when i upgrade mysql 4 to 4.1?
From 4.1 you cam use cp1256 and unicode for
cool so i create a unique field say ticket_number , then when inserting
concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
-Original Message-
From: Terence [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 7:29 PM
To: [EMAIL PROTECTED]
Subject: Re: two auto-inc
Help!
We're running MySQl on Win2000 server.
The other day our INNODB database filled up, so we
stopped the server, backed up the data, and adjusted
the innodb_data_file_path from
ibdata1:500M;ibdata2:500M;ibdata3:500M;
to
ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M;
Late
Hi
I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a
network. I have administrator privileges. I have also installed MySQL
Administrator. When I try to look at the users I get the following error
message:
Could not fetch Usernames
MySQL Error Nr. 1044
Access denied for
Hi,
So what threading library should I use with mysql?
Can somebody recommend me which to use? Because I'm bit confused.
I used to use linuxthreads and it was pretty good. Now there appears some
other threading libraries:)
Which one is reliable and has good performance?
Ganbold
At 07:41 PM
Kevin Carlson [EMAIL PROTECTED] wrote:
I have a table with four columns, the first three of which are combined
into a unique key:
create table Test {
cid int(9) NOT NULL default '0',
sid int(9) NOT NULL default '0',
uid int(9) NOT NULL default '0',
rating
Hi peeps,
The setup I have is 2 windows 2000 servers,
server A = IIS5
server B = IIS5 + MySQL.
The servers are connected by a 2nd network card in each machine and can see each other
fine.
When I connect to any database on server B using ASP executed on server B its
lightning fast, but
Franz Klein [EMAIL PROTECTED] wrote:
I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a
network. I have administrator privileges. I have also installed MySQL
Administrator. When I try to look at the users I get the following error
message:
Could not fetch Usernames
Hi,
Can you give me some hints and tricks to compile mysql with libpthread?
What compiler options should I use?
thanks,
Ganbold
At 08:31 PM 14.04.2004, you wrote:
On Wed, 14 Apr 2004 19:59:33 +0900
Ganbold [EMAIL PROTECTED] wrote:
So what threading library should I use with mysql?
Can
Tang, Grace H [EMAIL PROTECTED] wrote:
In my box, mysql server version is 4.0.18.
I tried flush logs. Nothing happened in the mysql data directory. All the log
files
were not replaced.
Does flush logs rename the old log files and create new log files?
FLUSH LOGS closes and reopens all
Hi All,
Can't I install and configure mysql database without have root privs. on linux. If yes
pls. let me know the workaround.
Thx and rgds,
piyush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can use the one that comes with Panther. But if you want to install
the latest, download the standard version 4.0.18. I assume you were
wondering between standard and max editions.
On Apr 13, 2004, at 3:34 PM, Daniel Lahey wrote:
Which distribution should I install on Mac OS X Panther?
Peter wrote:
So, what I need to do is get the average of a column ever x rows.
This is as far as I got:
SELECT AVG(value) AS every_ten_row_average FROM table GROUP BY [every 10
rows]
The part I'm stuck on is the [every 10 rows].
try this:
SELECT 10*FLOOR(X/10) as X, Avg(Y)
FROM table
Does this happen with a mysqladmin shutdown command as well?
-Original Message-
From: TO
To: [EMAIL PROTECTED]
Sent: 4/14/04 5:23 AM
Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding
INNODB space
Help!
We're running MySQl on Win2000 server.
The other day our
From which version it will be avalaible the possibility to define a
descriptor of a field (column) ? From example if I define a column as
CUSTOMER, I need to add a description for which customer is this column, as
in microsoft office, sql.
tks in advance
Massimo
Massimo Petrini [EMAIL PROTECTED] wrote:
From which version it will be avalaible the possibility to define a
descriptor of a field (column) ? From example if I define a column as
CUSTOMER, I need to add a description for which customer is this column, as
in microsoft office, sql.
From
Why does MySQL accept this insert statement with a warning?
Insert into Sessions (id) values (20de8376640263673ea03938);
Query OK, 1 row affected.
I expected a warning because of the Token column shouldn't be NULL!
I have a table with three columns:
Id # int not null
Token # char (1)
David,
Ok, I'll bite.:) Why don't you just create the table rfdata the
way you want it and change the column types manually. Before you start your
Select query delete all rows from the table with Delete * from rfdata and
then do a insert into rfdata [(column1, column2 ...)] select .
On 14 Apr 2004 at 17:27, B. Fongo wrote:
I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the CREATE
TABLE documentation:
If no DEFAULT value is
Hi,
Why does MySQL accept this insert statement with a warning?
Insert into Sessions (id) values (20de8376640263673ea03938);
Query OK, 1 row affected.
I expected a warning because of the Token column shouldn't be NULL!
I have a table with three columns:
Id # int not null
Token # char
I ran into this problem when I installed 4.0.18. All
of the tables in my database are INNODB and the
REPLACE statement was failing on tables that had
foreign key constraints. I just rolled back to 4.0.16
and the problems went away. Not much of a solution,
but it's buying me a little time. Will I
Keith C. Ivey wrote:
On 14 Apr 2004 at 17:27, B. Fongo wrote:
I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the CREATE
TABLE documentation:
What is NOT NULL good for, if Mysql will insert a default value?
I thought Mysql should warn: Column can't be NULL if no value is
provided.
Thanks anyway
Babs
-Ursprüngliche Nachricht-
Von: Martijn Tonies [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 14. April 2004 17:39
An: B.
Ruslan U. Zakirov wrote:
Keith C. Ivey wrote:
On 14 Apr 2004 at 17:27, B. Fongo wrote:
I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the CREATE
to it for display purposes only.
Michael
electroteque wrote:
cool so i create a unique field say ticket_number , then when inserting
concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
-Original Message-
From: Terence [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 7:29 PM
Hi,
I need help. I have my old mysql server running in my web server and I
can't stop it for make the test of the new version (3.28 to 4.0). I
have installed with compilation of the source code and configure my
socket, var and port. I have make a config file with the --example:
Has anyone had any luck getting MySQL 4.0.18 (specifically
innodb_buffer_pool_size) to use large amounts of memory on a G5 running
OS X Server 10.3.3?
I initially tried with the MySQL built binary, and was unable to get
innodb_buffer_pool_size to go beyond 1.5 GB. Here's the my.cnf section
that
I'm using an older version of Mysql, and I know it doesn't support
trigger.
What I'm trying to do, is to delete records from 2 tables (Sessions
Cart).
These experimental statements didn't help:
DELETE FROM Sessions INNER JOIN Cart on Sessions.id where Sessions.id
=$id;
DELETE FROM Sessions
Hello B.,
Wednesday, April 14, 2004, 7:02:06 PM, you wrote:
BF I'm using an older version of Mysql, and I know it doesn't support
BF trigger. What I'm trying to do, is to delete records from 2 tables
BF (Sessions Cart).
In a nutshell - you cannot do it in a single SQL Query on MySQL 3.x
MySQL
Ja! Most RDBMS don't use default values for NOT NULL columns. Rather
they alarm if a statement renders such fields NULL.
I do agree with Michael. Mysql went a different way in this regard, in
that it assigns default values... It only warns if one tries to
explicitly enter NULL in NOT NULL
Howdy all,
I've got a query which selects the count all listings
that meet meet a customer's search criteria. In
addition, there is a sent table that keeps track of
which listings have already been sent to that
customer. There are roughly 30,000 listings and 1.2
million sent records. As is stands
Thank you for your fast answer.
I tried everything you told me, but unfortunately another error message came
through:
Here you have all what you asked me to do:
mysql SHOW VARIABLES LIKE large_files_support;
+-+---+
| Variable_name | Value |
In the last episode (Apr 14), Cesar Bonavides Martinez said:
Thank you for your fast answer.
I tried everything you told me, but unfortunately another error
message came through:
Here you have all what you asked me to do:
mysql SHOW VARIABLES LIKE large_files_support;
I've been working on this all day. I would _greatly_ appreciate it if
anyone had some suggestions. I'll describe the problem in some detail
below. I'm guessing that there is some setting/prereq/version conflict
or such causing this failure, and hoping someone here can easily
identify my mistake.
hi list,
i'm studing foreign keys but my sql code does not react as
would imagine when i insert inconsistent data.
i.e.
create database urls;
use urls;
create table caths
(
name varchar(7) primary key
) type = innodb;
create table urls
(
name varchar(10) primary key,
home
On Wed, 2004-04-14 at 15:20, Dan Nelson wrote:
Now that's interesting. Max_data_length is set to 4gb, but you're
getting an error at 2gb. Could it be a process resource limit? What
does the ulimit command return? You can reset that limit with the
ulimit unlimited command.
IIRC, some
Emmett Bishop [EMAIL PROTECTED] wrote:
I ran into this problem when I installed 4.0.18. All
of the tables in my database are INNODB and the
REPLACE statement was failing on tables that had
foreign key constraints. I just rolled back to 4.0.16
and the problems went away. Not much of a
I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log
in locally as an administrator and issues a command such as DESCRIBE TABLE
some_table; - everything works fine. If I come back at a later time and run
the same command again - it fails because of some type of timeout. If I
Hi,
I've moved a Database Application from MSAccess to Mysql, most of the
application seems to work fine, but I'm having trouble with Inner
Joins. (The scripting language is ColdFusion MX 6.1) mySql 4.018.
Any help desperately welcome, including explanation of the principles
SELECT i.*,
In the last episode (Apr 14), Sean Quinlan said:
On Wed, 2004-04-14 at 15:20, Dan Nelson wrote:
Now that's interesting. Max_data_length is set to 4gb, but you're
getting an error at 2gb. Could it be a process resource limit? What
does the ulimit command return? You can reset that limit
Here is what you suggested:
% ulimit
unlimited
I don't know what is going on, since I do have files greater than 2 GB, and
no problem with them...
At the beginning I thought it was a problem in which MySQL couldn't handle
large input files, so I spited my original file into two parts. One a
My apologies for missing the previous discussion and thanks for the info. A follow up
question: is there a performance penalty associated with using PreparedStatement's
with queries that will never be reused? Clearly, there's a performance benefit for
statements executed multiple times, but
On Wed, 2004-04-14 at 16:03, Dan Nelson wrote:
He mentioned his input file was 3gb, so I assumed this was not the
problem :)
Ah, sorry, just joined the list must have missed it.
--
Sean Quinlan [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
Hi,
Can anyone suggest some troubleshooting tips when setting up a
slave and getting the error:
ERROR 1200: The server is not configured as slave, fix in config
file or with CHANGE MASTER TO
?
The master is already running with other slaves. I have granted
permission and copied the relevant
Hi,
After I've filled my MYSQL_ROW variable, I would like print it into the
screen
--
MYSQL_ROW lop;
db.pgInfoSel();
lop = db.PreRow(); // return the reference to filled row
for(int i = 0; i = 7; i++)
cout lop[i] endl;
but, if I would print from 0 to 7 don't print
I have 2 tables and 1 query. The problem is when I implement ORDER BY
p.date DESC it hits the wall.
I understand that MySQL is not the best at ORDER BY DESC so I am after
some tips on possible workarounds to avoid using ORDER BY DESC.
The site will list classifieds ads so I need to display them
Does this machine have a valid server-id? Run show variables like
'server_id' from the mysql monitor. Also, is there anything in the *.err
file on this machine?
-Original Message-
From: jim
To: [EMAIL PROTECTED]
Sent: 4/14/04 3:26 PM
Subject: Server not configured as slave
Hi,
Can
You need to drop the parenthesis. It looks you are trying to do a join
on a sub-join, and you appear to be missing a join condition. Or you're
trying to create a join with multiple conditions, which if fine. Near
as I can tell, you've made this a lot more complicated than it should.
I'm not
(This is probably not the best place for this post, but here goes...)
The (soon to be released) MySQL cluster software docs use a sample
cluster node configured with Dual Xeons and 16GB of ram. MySQL has
never been able to use more than 2 gigs of system memory (on 32 bit
platforms.) With
On Wed, 14 Apr 2004 16:59:31 -0400, wrote:
You need to drop the parenthesis. It looks you are trying to do a join
on a sub-join, and you appear to be missing a join condition. Or you're
trying to create a join with multiple conditions, which if fine. Near
as I can tell, you've made this a lot
On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote:
(This is probably not the best place for this post, but here goes...)
The (soon to be released) MySQL cluster software docs use a sample
cluster node configured with Dual Xeons and 16GB of ram. MySQL has
never been able to use more than 2
Does this machine have a valid server-id? Run show variables like
'server_id' from the mysql monitor.
Interesting. The my.cnf says server-id = 75 but the show_variables;
command says server_id 0 (zero).
Why would that be, and could it be the problem?
Also, is there anything in the *.err
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option.
However ps ax shows only 2 processes:
61652 p0 S 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/ta
61671 p0 S 0:00.82
Hi,
i got mysql 4.0.13 on my machine. When i installed it,
i did only basic stuff to get it running (bascilly hit
setup).
Now, i'm getting a little bit closer to mysql (the
system starts to became more friendly), but i got the
following problem:
- if i log as shellmysql
this user seems to have
would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
i screwed my installation up...well actually i believe i should have
installed a prior version...but regardless i have a strong desire to use
mysql...but at the moment i've hit a brick wall.
please tell me how to
on 04/14/2004 06:47 PM, the amazing jt at [EMAIL PROTECTED] wrote:
would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
i screwed my installation up...well actually i believe i should have
installed a prior version...but regardless i have a strong desire to use
Don't foreign keys need to be explicitly indexed?
Respectfully,
Ligaya Turmelle
saiph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
hi list,
i'm studing foreign keys but my sql code does not react as
would imagine when i insert inconsistent data.
i.e.
create database urls;
Only way I know of is to write a program for it. But I am a beginner.
Respectfully,
Ligaya Turmelle
beginner [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
i just created a db with around 30 tables and i need
to populate it. Is there any software or special
technic for doing
Dear Sir,
OS : Win XP Professional, Mysql 4.0.18 Category :WinMySQLAdmin 1.4
Description: I've encountered bug error problem using Mysql 4.0.18 ver when in
Dos Command prompt, using D:/mysql/bin/mysql --user root-- password give error
message
ERROR 2003 : Can't connect to
scott thanks for the help...but how do i know its uninstalled...i don't
think it worked.
this is what comes up for me:
rm: /usr/local/mysql: No such file or directory
is this correct if it's uninstalled or not??
_
Tax headache?
- Original Message -
From: Kelvin Chang
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 3:49 AM
Subject: Mysql 4.0.18 Bug error Message
Dear Sir,
OS : Win XP Professional, Mysql 4.0.18 Category :WinMySQLAdmin 1.4
Description: I've encountered bug error problem using Mysql
on 04/14/2004 09:00 PM, the amazing jt at [EMAIL PROTECTED] wrote:
scott thanks for the help...but how do i know its uninstalled...i don't
think it worked.
this is what comes up for me:
rm: /usr/local/mysql: No such file or directory
is this correct if it's uninstalled or not??
Try a
thanks scott,
i've uninstalled and reinstalled and i'm a happy guy!
huge thanks!!
jt
_
Watch LIVE baseball games on your computer with MLB.TV, included with MSN
Premium!
Has anyone seen this one? This is with MySQL 4.1.1 source RPM
MySQL-4.1.1-0.src.rpm on SuSE 9.
Using the MySQL binary RPM, I can --chroot=/path and --user=mysql,
and it works fine.
But if I compile the binaries mysql on SuSE 9 it doesn't work
correctly. If I run as root (--user=root) it starts
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option with libpthread.
After installation everything seemed OK. However after few minutes it hang
again.
It seems mysql with libpthread is even more unstable than using linuxthreads.
Ganbold
At 09:30 PM
80 matches
Mail list logo