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 http://asia.messenger.y
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
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 opt
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 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 the
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 t
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 the
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:
S
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` int(5
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: mysql
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
--
MyS
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 windows).
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 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 linux
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 l
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
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
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
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]
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 ex
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 PROTECTED]:/u
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
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 t
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 new
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
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 PROTECT
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 JB
"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 :
>
>
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 v
-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 scrip
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 File
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 inserti
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 CURRENT_
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
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,
value to be inserted must always 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
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)
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
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.
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
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
"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
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 mysqld
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
co
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.
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
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 get
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
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:
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 man
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 --basedir
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.
> 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' er
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
>
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] m
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]>;
Sent: Wednesday, November 23, 2005 7:13 AM
Subject: RE: How to SUM every row for SubTotal?
mysql> s
56 matches
Mail list logo
