but it can't work if multiple tables.
how it can use for multiple tables?
- Original Message -
From: ISC Edwin Cruz [EMAIL PROTECTED]
To: 'The Nice Spider' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, November 23, 2005 7:13 AM
Subject: RE: How to SUM every row for
Hello.
I was only testing MySQL 5.0.16 in chroot environment, so my
configuration isn't perfect and should be improved, but mysqld
runs in it:
[EMAIL PROTECTED] mysqls]# /home/gleb/mysqls/chroot/mysqls/bin/mysqld
--defaults-file=/home/gleb/mysqls/chroot/mysqls/my.cnf
[EMAIL PROTECTED]
Hello.
# mysql -u=root
What is 'SELECT CURRENT_USER();' reporting for you?
Rajesh Olafson [EMAIL PROTECTED] wrote:
hanks Gleb.
I get the exact same results when I connect with:
# mysql -u=root
---
Maybe a different issue but, for some reason I can't connect with
# mysql
Hello.
I have also tried mysqld_safe --skip-grant-tables --user=root
Don't run mysqld under root (even more - fresh versions should
automatically skip this option). What exactly have you done to
restore root password? Please provide exact SQL statements.
What user is 'Access denied'
Hi Walt, all!
walt wrote:
Is this something new with mysql 5, a bug, or something I'm missing? I'm
not able to switch databases.
A known bug (#14504 and others) in handling the separator at the end of
a use statement, see
http://bugs.mysql.com/bug.php?id=14504
mysql CREATE DATABASE
Hello.
MySQL has not only per-connection threads. See:
http://dev.mysql.com/doc/internals/en/threads.html
Maxim Nechaev wrote:
After my MySQL server start i see this processes:
[EMAIL PROTECTED]:/ps -HC mysqld -o pid,command
PID COMMAND
3116 /usr/libexec/mysqld
Hello.
don't think I will find the answer to this question in the normal manuals
but rather from someone / place that deals with the internals of the
system.
Mike
MySQL internals are available at:
http://dev.mysql.com/doc/internals/en/
Mike OK wrote:
I did read the manuals
Marko,
Do you have an index deleted + name on the accounts table?
How many rows have deleted=0?
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
How many rows do you have in the users table?
Ronan
--
MySQL General Mailing List
For list archives:
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Not sure if this is the place to ask but hopefully someone can help me
here. I am setting an application system and have successfully setup
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
Xiaobo Chen wrote:
Have you tried to put the port 3306 after the host? I assume you are in
the localhost.
Yes, I am trying to connect in localhost. I did 'nmap localhost' and
port 3306 is open and I can connect to mysqld with mysql client. I will
try putting 3306 after the host when I
I am not sure if you're trying to connect from outside of your office
newwork. If you try 'telnet' using 3306 (forgot the syntax, check the
Mysql site)outside your office network and if you couldn't get
through,(otherwise you will get some garbage characters) then you can't
connect to the database
Do you have an index deleted + name on the accounts table?
How many rows have deleted=0?
that depends because SugarCRM doesn't delete anything from DB just marks
item as deleted using this field.
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
Xiaobo Chen wrote:
I am not sure if you're trying to connect from outside of your office
newwork. If you try 'telnet' using 3306 (forgot the syntax, check the
Mysql site)outside your office network and if you couldn't get
through,(otherwise you will get some garbage characters) then you can't
Hello,
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
This is the errormessage from InnoDB
Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: Error number 30 means
'Read-only file system'.
Nov 23 13:36:30 aliao
Marko Knezevic [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Here are my tables and queries i am running on them with index
explanations.
Hope this will help.
ACCOUNTS TABLE:
+-+--+--+-+-+
| Field
that depends because SugarCRM doesn't delete anything from DB just marks
item as deleted using this field.
Do you have an index for deleted column?
It should help.
Can you apply any more filter in the users table (like date)?
You are requesting all rows.
no, because purpose of this query is
For Archivum
My destination was: Changing default latin1 charset to latin2 and the default
collation to latin2_hungarian_ci.
I tried to configure accross my.cnf, but all of my effort failed.
I installed mysql-administrator, use startup paramters in. Change mysqldump .
Took changes and
Thanks for the point to the internals. I will keep this page bookmarked. I
read everything there regarding indexes and did not find the answer I was
looking for. I think what I need falls under the UPDATE statement (no
listing there). Specifically, what triggers the action for index re-builds.
Hi,
The following query worked fine:
INSERT INTO Allocations(Project_ID, User_ID)
SELECT P.Project_ID, U.User_ID
FROM Users U, Projects P, Clients C
WHERE P.Client_ID = C.Client_ID
AND U.Client_ID = C.Client_ID
AND Project_ID =.$project_id)
However I want to add a column to the INSERT part of
Hi,
Try setting the default value of the column to 'Yes' that should work or
INSERT INTO Allocations(Project_ID, User_ID, field) SELECT P.Project_ID,
U.User_ID, 'Yes' FROM Users U, Projects P, Clients C WHERE P.Client_ID =
C.Client_ID AND U.Client_ID = C.Client_ID AND Project_ID =.$project_id)
be 'Yes'. Is there a way to do this with
just with one query?
Thanks for your help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__ Información de NOD32 1.1298 (20051123) __
Este
Hi Ralph,
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
I guess I can ask the obvious question. Why are you trying to use
InnoDB, if your data/filesystem is read only? Why not use MyISAM instead?
Regards,
On 11/22/05, Jim Winstead [EMAIL PROTECTED] wrote:
On Tue, Nov 22, 2005 at 04:50:42PM -0800, Jon Drukman wrote:
What happened to MySQL Control Center (aka mycc or mysqlcc)? The
dev.mysql.com site redirects to the Query Browser page. QB is a poor
substitute for mycc. It looks like neither
Hi Gleb,
Here's the output:
[EMAIL PROTECTED]:/usr/local/mysql/bin: ./mysql -u=root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 143 to server version: 4.1.10a-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql SELECT
In MySQL 4.1.11, if you create two temporary tables with non-unique indices as
part of the CREATE TEMPORARY TABLE statement, then
insert several hundred (or thousand) rows, a subsequent SELECT using a JOIN
between the two tables is substantially slower than if
you create the indices after
Hi!
I am in the process of upgrading the machine with everything
to a newer versions. This time, I'm getting rid of the IBM DB2 as it
won't be there. So, I downloaded the MySQL 64 bits for the AIX and
extracted it there. The AIX server use 64 bits kernel and Enhanced
Journal
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Gleb,
Thanks for the answer. I was hoping to use the mysql.server script that
ships with MySQL to start the database, which it seems You are not
doing. I think the script is the core of my problem. I guess i'll have
to give up on the
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt (essentials version)
Windows xp
The DB contains tables, vw's and sp's.
It is a
Barak Mery [EMAIL PROTECTED] wrote on 11/23/2005 01:51:37 PM:
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my
project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt
Hi;
I have been running this server, 4.1.14 on Linux FC 4 for while, no problems.
Yesterday I fiddled with my.cnf via the Administrator console to,
tried some graphs, and also turned on binary logs.
Later in the day, (don't think it was immediate after the server
process restart, but maybe), the
Well Shawn,
First of thanks for the quick result.
I tried your suggestion but it didn't help no sp and no restore.
It only shrinked the backup file (by deleting the cr).
Is there any log file where I can trace that kind of erros ?
Barak
_
From: [EMAIL
There's a new option added in 5.0.13:
-R (--routines)
It's designed designed specifically to dump SPROCs and FUNCTIONs. I
thought it would have been turned on by default but I guess it wasn't. Add
that to the list of options and check your dump results again. I refer you
again to the manual
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There's a
I'm getting ready to do a roll out next week on converting an
application from MySQL to MSSQL. I'm installing the perl drivers on the
production machines today. The perl DBD driver requires mysql to be
installed. Everything's been going fine on all the machines until I got
to the last one. On
Hello.
Why is it that adding an index before or after the addition of data
makes a difference on SELECT performance?
Check whether the problem still exists if you run ANALYZE table after
inserts in case you have already created indexes. FORCE_INDEX in the
SELECT clause should help as
Hello.
| @localhost |
Obviously it is not a root user. If you're unable to connect
as a root have a look here:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Rajesh Olafson [EMAIL PROTECTED] wrote:
Hi Gleb,
Here's the output:
[EMAIL
I thought I would get around the whole thing by just installing the RPM
instead of compiling. So I downloaded MySQL-devel-4.1.14-0.i386.rpm and
installed it. Then I went to install the DBD-mysql module and got this
error during the compile:
/usr/bin/ld: cannot find -lz
collect2: ld returned 1
I fixed the whole problem by typing this one line:
`ln -s libz.so.1.1.3 /usr/lib/libz.so`
Linux is such a pain sometimes.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Gleb,
Thanks for the quick response. Unfortunately, ANALYZE TABLE does not
appear to affect the Cardinality field of a temporary table (it is
still NULL, even with rows added). Only by creating the index itself
after the insert seems to make the query faster. I also tried FORCE
INDEX and it
Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
Dear All
I have a problem with mysql_num_rows
if I execute it on a result returned by mysql_query,,, and that result is
empty then I will get an error saying that this result is not a valid mysql
result,,, but i think it should return ZERO!
I am using count(*) and checking if my
Dear Friends
I've set up an mysql server with version 4.1.15 by compiling the .src.rpm on
an linux machine running conectiva linux 10 with 1.5Gb of RAM on an Pentiun
4 2.88 Gz machine
The app I have is running on windows connecting to this linux server by
using direct ip address for mysql
Hi Luiz,
I've set up an mysql server with version 4.1.15 by compiling the
.src.rpm on an linux machine running conectiva linux 10 with 1.5Gb of
RAM on an Pentiun 4 2.88 Gz machine
The app I have is running on windows connecting to this linux server by
using direct ip address for mysql
Have somebody tryed to install dotproject 2.x with MySQL 5.0.x??( The stable
release)
++
| ISC Edwin Cruz [EMAIL PROTECTED]|
| IT Manager |
| Transportes Medel Rogero SA de CV |
| Desk: 01 (449) 910 30 90 x3054
Hi Ryan,
Hmm, --without-server doesn't seem to work. Not sure what are you
doing wrong, but as a workaround you could define F_TO_EOF to zero
in open.c. Quoting sql/my_global.h:
#define F_TO_EOF 0L /* Param to lockf() to lock rest of file */
And for linux it is zero (it's different for
Is the only way to sort numbers stored in a varchar column to use lpad?
Are there any other columntypes that allow both characters and numbers that can
sort numbers correct?
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
I've tryed and I only get a lot of sql errors, looking into the source code
I sow that the problem is with JOIN clause.
Any ideas abaut how to install it?
-Mensaje original-
De: ISC Edwin Cruz [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 23 de Noviembre de 2005 05:06 p.m.
Para:
Hi All,
We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
working. It works fine on 4.1 but 5.0.16 gives us an error:
How to reproduce:
CREATE TABLE `user_master` (
`user_id` int(5) unsigned NOT NULL auto_increment,
`department_id` int(5) default NULL,
`role_id`
On 24/11/2005 2:22 p.m., Terence wrote:
SELECT um.username,rm.role_name,dm.department_name
FROM user_master um, role_master rm
LEFT JOIN department_master dm ON um.department_id = dm.department_id
WHERE um.role_id = rm.role_id;
1054 - Unknown column 'um.department_id' in 'on clause'
Query:
Hassan Schroeder wrote:
Gobi wrote:
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here is what I have done:
and I created the following servlet, TestSQL:
It's possible
Terence,
SELECT um.username,rm.role_name,dm.department_name
FROM user_master um, role_master rm
LEFT JOIN department_master dm ON um.department_id = dm.department_id
WHERE um.role_id = rm.role_id;
J
Your query joins rm to dm on a um column = a dm column. Recent 5.0 releases
rightly object to
I have a PHP application that stores member-access passwords in a char
column. When the passwords were stored, they were written to the
database using the PASSWORD() function. Each hashed password is 16
characters long. When a member logs in, the plain text password
submitted is run through
Test USER [EMAIL PROTECTED] wrote on 11/23/2005 07:36:43 PM:
Is the only way to sort numbers stored in a varchar column to use lpad?
Are there any other columntypes that allow both characters and
numbers that can
sort numbers correct?
-
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the source command within the MySQL
CLI?
mysql -uroot -pmypass
(login welcome)
mysql CREATE DATABASE IF NOT EXISTS bcm;
mysql USE bcm;
mysql source myback1.sql
There is another option
Terence [EMAIL PROTECTED] wrote on 11/23/2005 08:22:30 PM:
Hi All,
We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
working. It works fine on 4.1 but 5.0.16 gives us an error:
How to reproduce:
CREATE TABLE `user_master` (
`user_id` int(5) unsigned NOT NULL
I have a command :
SELECT * FROM reg_one WHERE 'varName' like 'varTmp' %
This is made within dreamweaver mx.
varName and varTmp is a textselect.
Does anyone can help how to make reg_one
Becomes to like varName or varTmp ?
Send instant messages to your online friends
56 matches
Mail list logo