On Sun, 2005-10-30 at 00:14 -0300, Fabricio Mota wrote:
Anybody has worked as a developer to MySQL Database Server features?
If you mean people who work for MySQL hacking on Cluster, then yes, we
exist.
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
[EMAIL PROTECTED] wrote:
wang shuming [EMAIL PROTECTED] wrote on 10/31/2005 01:11:06 AM:
How could run mysqld-nt.exe in background on win2000/XP, not as a
would be useful in HIS operating system. AFAIK, there has never, ever,
been a Windows (or DOS) command or command modifier to launch an
Hello.
this reads dropped in in a time-delay of about 10 sec.
I don't think this is a bug. Even after the KILL statement mysqld
threads don't die at once. Furthermore - CPU load was huge enough.
to say that mysql after 16 hours run still was reading the tables...
It could be
Hello.
What version of MySQL do you use? General information about MySQL Server
Shutdown Process you can find here:
http://dev.mysql.com/doc/refman/5.0/en/server-shutdown.html
Mayuran Yogarajah wrote:
We have MySQL running on a Redhat server (RHEL 3.2). We issued a
service mysql
Hi, guys!
I need to add three fields of three different tables how can I do?
Thank you very much.
Priscilla.
-
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!
Like this:
ALTER TABLE table_name ADD COLUMN column_name parameters;
and next change table_name
Priscilla Labanca wrote:
Hi, guys!
I need to add three fields of three different tables how can I do?
Thank you very much.
Priscilla.
Hi, guys!
I need to sum three fields of three different tables how can I do?
Thank you very much.
Priscilla.
-
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!
Hi,
One possible way would be to the UNION statement - I think this would be
your best action, providing the data is consistent across all three
tables.
See: http://dev.mysql.com/doc/refman/5.0/en/union.html
Hope this helps,
Paul
-Original Message-
From: Priscilla Labanca
Hi Priscilla,
you can do:
SELECT (SELECT SUM(t1.field) FROM table1 t1) +
(SELECT SUM(t2.field2) FROM table t2) +
(SELECT SUM(t3.field3) FROM table t3)
/Johan
Priscilla Labanca wrote:
Hi, guys!
I need to sum three fields of three different tables how can I do?
Thank you
Hi!
Scott Gifford wrote:
Jerry Swanson [EMAIL PROTECTED] writes:
Why when I do select from database and try to compare float field with float
number, I have no results
amount --- type float
select * from price where amount = 3.45 // doesn't work
select * from price where amount = '3.45'
Jigal van Hemert [EMAIL PROTECTED] wrote on 10/31/2005 03:41:39 AM:
[EMAIL PROTECTED] wrote:
wang shuming [EMAIL PROTECTED] wrote on 10/31/2005 01:11:06
AM:
How could run mysqld-nt.exe in background on win2000/XP, not as a
would be useful in HIS operating system. AFAIK, there has never,
Somebody give me some ammo for this. I flagged MySQL v5 to our CTO and
got shot down. We currently develop in MSSQL and I don't know enough
about either to make a constructive argument. I'm not even sure I
understand what he's on about with 'table functions' and 'nested
selects'. I couldn't find
I've been given some Oracle table dumps that are NOT plain text
delimited. I've been asked to look at using sqlloader to get the file
into my mysql database.
Does this exist for mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
The primary key by definition is an index (key). If you don't make it a
primary key index or unique index then duplicate entries can occur. It is
good practice to always set a primary key, and always make it a unique
auto-increment integer.
If you look at the output of EXPLAIN now, you can
i am developing a php app. in the beginning of every file there is
a require_once(./setup.php); that does the housekeeping, fetches the
connection credentials and connects to the database. All that worked
fine until this morning I made a new file.
Now I get a connection failure when I try
Gerald Taylor wrote:
i am developing a php app. in the beginning of every file there is
a require_once(./setup.php); that does the housekeeping, fetches the
connection credentials and connects to the database. All that worked
fine until this morning I made a new file.
Now I get a
Zan B. wrote:
Hello all!
I wanted to discuss a problem I am having with setting up MySQL.
I noticed that my root password isn't set. When i try to set it via
phpMyAdmin, MySQL doesn't recognize my databases, and denies all
connections. Now I've tried setting the password via SSH by accessing
Table function: A function that return a value of the table data type
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_7ysl.asp).
This is similar but not the same as creating a temporary table to store
the results of a query. Variables declared as type table
Bruce Martin wrote:
What should the permissions be for the MySQL 5 install on Mac OS X. By
default it was Owner = System Group = wheel.
Could someone give me a list of directories and what owner:group
settings I should have?
Bruce Martin
The Martin Solution
PO Box 644
Delaware Water Gap,
Hassan Schroeder wrote:
Scott Gifford wrote:
select * from price where amount = 3.45 // doesn't work
Floating point numbers are very rarely equal, because of small
rounding errors that happen all the time. Probably the actual number
in the database is something like
Christoph Lehmann wrote:
Hi
I have 2 tables, say A and B. One field in table A, say A_link, points
to a field B_link in table B. I need to select entries in A, which
fulfill two conditions: A_cond1 = XX and B_cond2 = YY.
E.g
table Atable B
A_cond1 A_linkB_link
Michael Stassen [EMAIL PROTECTED] writes:
Scott Gifford wrote:
[...]
Try something like this:
select * from price where amount 3.44 and amount = 3.46
I hope the = was a typo?
Yes.
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Scott Haneda wrote:
on 10/28/05 5:52 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
You can nest the IF statement, putting another where 'soon' is like
Jasper suggested. Or you can use the CASE WHEN THEN construct if you
have a lot of conditions you need to check for.
Can you show me an
Can someone please tell me what the command would look like to grant access
for the root user to a database and table on a remote host.
Thanks in advance
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 27 October 2005 23:12
To: mysql@lists.mysql.com
Subject: Re:
iH
i saw this report as a bug for previous mysql versions but not for
5.0.15
ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause'
the query that generated this works fine of mysql 5.0.11
others having this issue? using OS X 10.4 (32bit)
thanks
Rich Allen
Dare Do
--
MySQL General
Hello.
If MySQL throws 'Access denied', have a look here:
http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
Your version of MySQL is very old and have lots of bugs, I recommend you
to upgrade.
Zan B. wrote:
Hello all!
I wanted to discuss a problem I am having with
Hello.
MySQL is able to work with every environment you have meant. Have a look
here:
http://dev.mysql.com/doc/refman/5.0/en/apis.html
http://dev.mysql.com/doc/refman/5.0/en/connectors.html
But in my opinion, word PHP is more frequently used at:
Hello.
Please provide complete PHP error message.
that the bad new file is doing something bad that boggles subsequent
connections? If so what?
Maybe. To find out what your file is doing with the server use the
following things:
hcir [EMAIL PROTECTED] wrote on 10/31/2005 12:37:15 PM:
iH
i saw this report as a bug for previous mysql versions but not for
5.0.15
ERROR 1054 (42S22): Unknown column 'c.len' in 'on clause'
the query that generated this works fine of mysql 5.0.11
others having this issue? using OS
iH Swawn,
thanks for the quick reply and the pointing out the change, after
reading the new mysql syntax doc i have my query qorking again
On Oct 31, 2005, at 9:12 AM, [EMAIL PROTECTED] wrote:
hcir [EMAIL PROTECTED] wrote on 10/31/2005 12:37:15 PM:
iH
i saw this report as a bug for
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld got
signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is
Bill Adams wrote:
Shawn,
That's a very reasonable answer. Thanks for pointing me to the
examples. This one addresses the second question:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.
html . There is no example answering both questions in one query.
Regards,
Evening All,
I knew I should have been paying attention.
A while back I received an email about a software product that runs with
mysql for development error tracking/reporting and it's used by the mysql ab
team. Can't or the life of me remember what it's called.
Can anyone help please?
Alex
Hello,
Are you think of Eventum?
http://dev.mysql.com/downloads/other/eventum/
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
Houston, TX USA
Phone: (713) 636-9239
Are you MySQL Certified? www.mysql.com/training//certification
-Original Message-
From:
I have just received a new machine to install mysql on and I do not know how to
tell which version of the rpm's I should use
[EMAIL PROTECTED] config]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 2)
[EMAIL PROTECTED] config]# uname -a
Linux snv1 2.6.9-22.ELsmp
Mayuran Yogarajah wrote:
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld
got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 3.4
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
-
Hi,
I'm not really interested in Lasso and can't see why I am receiving your
emails. Could you please take the entire list off your mailing list?
Thanks and Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417
Yes! Please stop spamming us; we would signup for a Lasso list if we cared to
get these tips not a MySQL list.
John A. McCaskey
Software Development Engineer
Klir Technologies, Inc.
[EMAIL PROTECTED]
206.902.2027
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL
I have no idea what the product was called but if the email was sent to this
mailing list, you should be able to find it on the MySQL site; they archive
all of the traffic on the various MySQL mailing lists and have a search
engine for locating it; all you need to do is throw appropriate search
I have installed the following rpm's for mysql on my node
[EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql
MySQL-client-standard-5.0.15-0.rhel4
MySQL-server-standard-5.0.15-0.rhel4
MySQL-shared-standard-5.0.15-0.rhel4
MySQL-devel-standard-5.0.15-0.rhel4
The node is:
[EMAIL PROTECTED] mysql]#
In true, I have a project to develop a new (revolutionary) engine for mySQL,
and so increase many times applications performance, and reduce enterprises
cost with hardware infraestruture. So I'm looking for peoples to help me to
develop this project - or appoval by MySQL AB.
My regards,
Fabricio
Master and slaves are both Mysql 4.1.14 standard. There are six slaves,
and this error kept happening on #2 and #4, but then it stopped. I
thought it was all gone for good but today it happened on #3.
The symptom is: Replication stops with the following error:
Error 'Can't find file:
Jon,
I can't offer any great insight into your problem I'm afraid. But I'd
encourage you not to add the error to the ignore list as the UPDATE won't
actually get replicated then and your databases will be out of sync. Maybe
this is a filesystem problem at the OS level? What OS and
On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote:
In true, I have a project to develop a new (revolutionary) engine for mySQL,
and so increase many times applications performance, and reduce enterprises
cost with hardware infraestruture. So I'm looking for peoples to help me to
develop
Ok, could you suggest me where I may find it with more occurrences?
Another problem is: MySQL is a very big project, and I have no UML (or any
abstraction) that could help me to understand it!! Can you tell me where
could I find this kind of documentation?
My Regards
Fabricio Mota
Hi Fabricio,
You can find a lot of information in the manual, more specifically at
http://dev.mysql.com/doc/refman/5.0/en/example-storage-engine.html
This would be a very good place to start. Otherwise, as suggested, ask
questions on the internals list.
Regards
David Logan
Database
Ok, David. Thank you,
I'll take a good look on it!
My Regards,
Fabricio Mota
-Mensagem original-
De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Enviada em: segunda-feira, 31 de outubro de 2005 23:36
Para: Fabricio Mota; Stewart Smith
Cc: mysql@lists.mysql.com; [EMAIL
Connie,
The port you have specified (1020) requires root permissions as does any
port 1024 and below. The normal port is 3306. I'm suspecting that your
mysql server installation is configured to run as mysql or some user
other than root. Change the port to something above 1024 and you
49 matches
Mail list logo