Thanks a lot the clarification. This works for me with no exceptions.
Srinivas.
Cersosimo, Steve wrote:
You need not select a table in MySQL as you do in Oracle.
Select 2 + 2;
Is valid in MySQL and should return 4. It at least lets you know if
MySQL is functional. By mysqladmin ping will do
SELECT user
FROM mysql.user;
- Original Message -
From: Binay [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Sent: Friday, December 05, 2003 3:25 PM
Subject: Mysql user
Hi all,
Can any one tell me the command to list all mysql users ???
Thanks in advance
Binay
--
MySQL
select ID from YourTable
group by ID
having count(ID) 1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I seem to be downloading a corrupted zip file?
Help!
###
Any views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of the
National Bank of Malawi Ltd (NBM).
The information,
Hello Listers.
I would like to upgrade from 3.4 to MySQL 4.1 and would just like to know.
Any Apps that have been compiled using ./configure --with-mysql option.
Would these apps have to be recompiled?
Regards
Denham Eva
ORACLE DBA.
-- Your information went that way --
--
MySQL General
Hello,
i'm having a problem with mysql. when i put an index on a
datetime column, it's never used.
for example the
sql: 'EXPLAIN SELECT * FROM actions ORDER BY datum'
shows:
table type possible_keys key key_len ref rows Extra
actions ALL NULL NULL NULL NULL 75853 Using filesort
even if
Hi,
I'm not saying I fully understand the MySQL optimizer, as
I never had to deal with it before... but:
Why should it use an index if the statement is returning ALL
rows? It might be faster to read them into memory ( 75853
isn't really much ) and sort them there instead of moving the
diskhead
Hello,
update of my last email sent.
when i use the
sql: 'EXPLAIN SELECT datum FROM actions ORDER BY datum'
the key gets used:
table type possible_keys key key_len ref rows Extra
actions index NULL datum 8 NULL 75859 Using index
however as soon as i select more column like
sql: 'EXPLAIN
Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
Corin
Tuesday, December 9, 2003, 10:19:16 AM, you wrote:
MT Hi,
MT I'm not saying I fully understand the MySQL optimizer, as
MT I never
Hi Corin,
As I said - I don't have the slightest idea about the MySQL optimizer,
but I'm trying to learn.
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
What if you do:
SELECT ... WHERE
Corin Langosch wrote:
Hello,
thanks for your fast reply. even when i use
EXPLAIN SELECT * FROM `actions` ORDER BY datum LIMIT 10
the key isn't used. the query takes about 2s :-(
What does it show if you do a
show indexes from actions
---
If you are sure the optimizer is
SQL
Hi all!
Nearly very night I have this problem.
This query is done every 3 hours. But problem is happened only at 3:00
Both master and slave are 4 CPU (2 with HTT) computers.
Both have mysql 4.0.16
And when I test table analit. There are many records which have the same
conditions as in WHERE
Use PURGE {MASTER|BINARY} LOGS TO 'log_name' instead of RESET
MASTER.
From the manual:
Deletes all the binary logs listed in the log index that are strictly
prior to the specified log or date. The logs also are removed from this
list recorded in the log index file, so that the given log now
Hi ,
Is anyone else experiencing a degrade in performance after upgrading from
3.23.53 to mysql 4.0.16.
After the upgrade the system load is extremly high +/- 6 and up and the cpu
is about 98% busy with the mysql process.
Regards
Stanley
variables below.
SQL-querySQL-query (126 Records)
Try using '$id' :
SELECT properties.area, images.image_filename FROM properties,
images WHERE properties.reference_number=images.reference_number AND
properties.area='$id'
On Mon, 2003-12-08 at 23:18, fatblokeonbike wrote:
.
I'm new to MySQL joins with PHP and I can't get this to work - and
Dear All,
Please comment on Best Practices for sharing members database between
different portals.
Suppose we have 3 portals running on different networks.
Assignment is to make a single Login/Pass for all portals, means once
LogedIn in one of the portal, could able to access the other portals
On Mon, 08 Dec 2003 19:07:43 +, zzapper [EMAIL PROTECTED] wrote:
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
B)
Now I can filter any quotes from form.searchtext easy enough, but how
do I filter
Dear All,
I am working in Linux 8.0 and running mysql 4.0.16. I am trying to
access same data files from the two mysql daemons. I mean there are
two PC's running with mysql and one NAS server where data files are
kept. To run mysql on the machines I first mount the NAS file system
and then run it
Hi list,
I've got a small MyISAM table which is used for some statistics.
I'm only doing insert into this table.
I need that clients doing INSERT queries can exit as soon as possible.
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit
.tcshrc is the config file for your settings on the environment variables
for your session of tcsh. When your looking for $SHELL your looking for the
command line interpretor. FreeBSD can use most any of them. bash, csh, ksh,,
sh, tcsh, etc. Usually the .rc file is found in your home directory
Hi Ya.
I seem to have solved my problem if I clean out any punctuation from
my search string (see below (ColdFusion script))
cfset form.searchtext=replace(form.searchtext,'[[:punct:]]','','all')
When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes
The LIKE appears to ignore
Corin Langosch [EMAIL PROTECTED] wrote:
update of my last email sent.
when i use the
sql: 'EXPLAIN SELECT datum FROM actions ORDER BY datum'
the key gets used:
table type possible_keys key key_len ref rows Extra
actions index NULL datum 8 NULL 75859 Using index
however as
On Tue, Dec 09, 2003 at 12:17:41PM +0100, David Bordas wrote:
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit to ten secondes for example, is that mean
that delayed_queue will be flushed every ten secondes ?
Is there an other
hi!
i have 2 machines.
both of them running mysql daemon.
i want to check the speed difference, and i am looking for a method how can i do this ?
is there an official tool for this thing ?
Vaso
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit to ten secondes for example, is that
mean
that delayed_queue will be flushed every ten secondes ?
Is there an other variable that specify the flush time ?
No -
On Tue, Dec 09, 2003 at 02:18:58PM +0100, David Bordas wrote:
I've read mysql doc sereval times, but i can't find any varaible that
specify when the delayed queue was flushed.
Well, I suppose that's because there isn't one. The DELAYED thread
handles that by itself. You don't want it too
Mike Brum [EMAIL PROTECTED] wrote:
Hopefully someone can help me out with this -
I have two tables in mySQL: comments and diary
I want to populate a new field in comments with the current values of diary
- but only if they meet certain criteria.
Now, the problem is this - my webserver
H. Steuer [EMAIL PROTECTED] wrote:
im just wondering if there are any limitations in cross database queries like:
SELECT one.* FROM db1.one, db2.two;
are there any differences in joining tables from within various databases to joinin
tables from within the same database?
No.
the
Tuesday, December 09, 2003 2:51 PM
Chris Elsworth wrote:
If you increase delayed_insert_limit then you're effectively giving
the DELAYED thread more preferencee to the table; it will write more
rows (once it can, ie there's a phase of time where there's no locks
on the table) in a batch,
I tryed to import from text file (columns divided by tabulators) like this:
5724KF2003CSDEUROPAPARKAN2003-12-12MarcinTamkanono
.
.
.
On PHPTriad (under Windows 2000) it works perfectly !
I use command: mysqlimport database file.txt
But under Linux (RedHat) i
Hi there,
I'm having problems running two versions of mysql simultaneously on the
same box.
The versions I'm using are:
* mysql 3.23.48
* mysql 4.0.16
What happens:
* I have the 3.23 version up and running (can see that it has 5
processes running with ps,
and 'bin/mysqladmin status' shows
is there a higher level directory that does not allow excecution? does it
work if you run it as root? can you 'vi /root/mysql/gwarancje.txt'?
just some thoughts
Jeff
Franz,
it could not be easier.
1. install MySQL using Yast's software menu.
2. use the Yast run level editor to have MySQL up at run levels 3 and 5
and to start the application.
3. be root in a xterm window and type:
mybox:~ # mysql
... and you will see:
mysql
here you are accessing a
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset about...
You can't.
From 4.1.1 you
I had tips from some people here to install the complete MySQL from Server
Logistics
on my Mac OS X 10.2 and so I did (I also installed Apache 2 and PHP from
them).
Now I'm on Step one, but got stuck here. (I always get stuck while trying
this MySQL).
In the pdf-file that came along
From: fatblokeonbike [mailto:[EMAIL PROTECTED]
$Query=SELECT properties.area, images.image_filename
FROM properties, images WHERE
properties.reference_number=images.reference_number AND
properties.area=$id;
but it doesn't work - I get the usual ...not a valid MySQL
result
.tcshrc is the config file for your settings on the environment variables
for your session of tcsh. When your looking for $SHELL your looking for the
command line interpretor. FreeBSD can use most any of them. bash, csh, ksh,,
sh, tcsh, etc. Usually the .rc file is found in your home
Is there anyway to still get the Solaris 9 64 bit binary for version
4.1.0 - now that 4.1.1 alpha appears to be out the 4.1.0 binaries don't
seem to be available on the download page
Thanks
Mark Needleman
Product Manager - Standards
Sirsi Corporation
email: [EMAIL PROTECTED]
--
MySQL
If the the file is on the same machine as your shell is running,
specify --local when running mysqlimport.
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: Problem with mysqlimport
I tryed
I did ask this before, but haven't got any help yet.
I'm trying this again... so please let me know if you know.
Setting up MySQL and PHP on my Mac OS X 10.2
Just made it work... well, at least I now have a databse
that I created and a table with two things inserted.
I can also see them when I do
HTTP 404 is an error code, when you try to reach a file, what is not exist.
For example, if you have a webserver, http://mydomain.com
and you have only an index.html nothing else, if you write
http://mydomain.com/myfile.html then you will get this error,
because myfile.html is not an existing
Dear list:
I apologize post this question, but
I`m newbie with MySQL.
I have a database called tacacs,
it has many tables and one of them is called accounting. This
table has many data stored since 2 month ago and it is very big and it
increases frequently everyday.
I`d like to know how can I
MySQL doesn't return HTTP error codes.
Your problem is not with mysql but with Dreamweaver's browser not being
pointed at a running webserver. Did you set up Apache (or some other
server) when you set up PHP and prove that both are functioning?
Matt
-Original Message-
From: Lost Idols
Lets do this:
mysqldump -u user -p [database_name] [tablename]
./thefilewhatyouwouldliketocreate.dmp
Check that file.
VAso
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 5:25 PM
To: [EMAIL PROTECTED]
Subject: How can I dump and
I tryed this option but i got following error:
mysqlimport: Error: The used command is not allowed with this MySQL
version, when using table: gwarancje
MySQL version is 3.23.49
What Can I do ??
Regards
- Original Message -
From: Matt Griffin [EMAIL PROTECTED]
To: 'Pawe3
Is there an easy way to determine the largest sql query I can
pass between a perl/C app to my MySQL database? It seems to wig
out around the 1 meg range but without resorting to trial and
error I'm not sure how to get an exact figure.
Thanks,
Mark.
--
MySQL General Mailing List
For list
The default maximum packet size is 1 meg. You can check your current
server setting with:
SHOW VARIABLES LIKE 'max_allowed_packet';
See A.2.9 Packet too large Error
http://www.mysql.com/doc/en/Packet_too_large.html for directions to
change this setting in the server and client.
Michael
Hi!
In my.cnf:
[mysqld]
...
default-character-set=cp1251
default_collation=cp1251_general_ci
...
Then, after
show variables like '%character%'
I have:
character_set_servercp1251
character_set_clientcp1251
character_set_connectioncp1251
character_set_resultscp1251
Hello all,
I'm having an issue with mySQL that causes some poor performance.
I'm running mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1
(i386); front-end is Apache 1.3.27 with PHP 4.1.1. My database is using all
MyISAM tables, with 50 or so tables and about 60MB of total data.
My
Hi.
First, sorry, if my problem is know or documented. I have made a rapid
search on the MySQL site, but without success.
Here is my problem : the following 'create table' command refuses to
execute on 4.1.1, if -1 is not put between a quottation mark:
create table testTable (name varchar(10),
There is limitation on user name in mysql - it can
be up to 16 characters. How change this limit? Need
I recompile mysql?
Thanks!
OldFrog.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
There is limitation on user name in mysql - it can
be up to 16 characters. How change this limit? Need
I recompile mysql?
[/snip]
[UNTESTED WARNING!]
Why not just ALTER the user table?
[/UNTESTED WARNING!]
--
MySQL General Mailing List
For list archives:
Three messages quoted, with my responses interspersed:
zzapper wrote:
[8 Dec 2003 19:07:49 -]
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
However users a complaining that if they search for for a
Does Mysql 4.1.1 have the two level index system integrated into it for full
text searches?
Thanks. :)
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Vaso:
I tried with your suggestion, it works
fine. I have the backup now. I have two questions:
How can I erase the actual data from
my table? and How can I restore them from my backup file?
Thank you and best regards,
EDWIN
Vasoczki Ferenc
[EMAIL PROTECTED]
09/12/2003 12:28
From what you describe, I have to wonder if a database is even truly
appropriate for the situation at all. How large is the data set in
question? If it's very small, save for actual image data (which could be
stored as files) the question becomes how often and under what circumstances
the data
On Tue, 09 Dec 2003 15:26:10 -0600 Tariq Murtaza [EMAIL PROTECTED]
wrote:
Please comment on Best Practices for sharing members database between
different portals.
Suppose we have 3 portals running on different networks.
Assignment is to make a single Login/Pass for all portals, means once
Paul,
--local is a valid option for mysqlimport in 3.23.49 according to the
manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport)
What is the entire command you are using?
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December
Hi all,
How should I set the parameters of the LOAD DATA LOCAL INFILE command for a comma
separated text file like this:
Text field,.4,123
Text field with included quote,,45
Text field with , a comma between quotes,1.2,44
Thanks,
Dan
--
MySQL General Mailing List
For list archives:
Hi,
I recently purchased a licence. I received this email. Do I download the
binaries myself or are you sending me a box? If I download it myself, do I
need to create an account? If I have one, I've long forgotten it.
Regards,
Len Buchanan
Datascape Technologies Inc.
At 06:07 PM 12/5/2003
My SQL Team,
When launching WinMySQLadmin 1.4 on multi-displayed systems, the admin
application launches center between both displays, not display 1, as it
should.
Thanks,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
Hi all,
How should I set the parameters of the LOAD DATA LOCAL INFILE
command for a comma separated text file like this:
Text field,.4,123
Text field with included quote,,45
Text field with , a comma between quotes,1.2,44
I believe it's...
Jay Blanchard wrote:
[snip]
There is limitation on user name in mysql - it can
be up to 16 characters. How change this limit? Need
I recompile mysql?
[/snip]
[UNTESTED WARNING!]
Why not just ALTER the user table?
[/UNTESTED WARNING!]
Thank for reply. I ALTER all 'User' columns
in
Having a multi-display system myself, I disagree with this being a bug. It's more of
a lack of a feature, being multi-display aware Also, some multi-display software
(matrox) tricks windows into it thinking it's one display with a _very_ weird pixel
width (2048 x 768), skipping over
If it's an option, I would run your datafile through a processor (sed on unix,
ultraedit on windows) to search and replace the string
with
\
and try it with
fields terminated by ',' optionally enclosed by ''
as mentioned by Mike Johnson's posting
(escaped by '\' is default)
-Original
Thanks for the help.
The problem was the line terminating character.
My source files are in DOS format '\r\n' and not the default posix one '\n'.
Thanks again.
If it's an option, I would run your datafile through a processor
(sed on unix, ultraedit on windows) to search and replace the string
Mark wrote:
Is there an easy way to determine the largest sql query I can
pass between a perl/C app to my MySQL database? It seems to wig
out around the 1 meg range but without resorting to trial and
error I'm not sure how to get an exact figure.
the max size would be limited by the variable
Andrew Braithwaite wrote:
Are you using MySQL?
yes of course :)
OK, if you are then first simplify your query:
group by 1
thanks, I didn't know it.
Then add the AVG column which will work ok with the group by :
select date_format(dt_imp,'%Y/%m') as date,
SUM(imp),
test
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
Diana Soares wrote:
Use PURGE {MASTER|BINARY} LOGS TO 'log_name' instead of RESET
MASTER.
From the manual:
Deletes all the binary logs listed in the log index that are strictly
prior to the specified log or date. The logs also are removed from this
list recorded in the log index file, so that
On Tue, 9 Dec 2003, Mayuran Yogarajah wrote:
Diana Soares wrote:
Use PURGE {MASTER|BINARY} LOGS TO 'log_name' instead of RESET
MASTER.
From the manual:
Deletes all the binary logs listed in the log index that are strictly
prior to the specified log or date. The logs also are removed
.
Dear List,
My thanks to those who replied.
I'm embarrassed as anything - the bloke I'm doing this thing for has now
changed his tiny mind and has decided to have a set number of images per
property, whereas before he was contemplating accepting a widely variable
number. I can thus stick all
On Tue, 09 Dec 2003 13:24:03 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You don't want to filter the quotes from the input string, because they
exist in the data. (Well, you could filter from both sides, but that's
inefficient.) What you need to do is escape the quotes with backslashes
From: fatblokeonbike [mailto:[EMAIL PROTECTED]
.
Dear List,
My thanks to those who replied.
I'm embarrassed as anything - the bloke I'm doing this thing
for has now changed his tiny mind and has decided to have a
set number of images per property, whereas before he was
contemplating
Hello,
Is there any RH 9 kernel tuning tips for system running Mysql 4.0 db? Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm new to MySQL, so this might be a stupid question/problem, but I
can't figure out the answer: I'm trying to install the Popper webmail
client on my web server. I'm following the instructions exactly. It
told me to log in to the mysql console with mysql -u root -p and then
create database
Greetings,
I can not get the DBD::mysql module for perl to install
correctly. It continues to complain about the mysql.so file. What worries
me is the solaris dist does not include a libmysqlclient.so file which I do
believe the linux DBD:mysql needs to install. Any help is most
Hi All,
I want to change the default port on mysql server from 3306 to 5 (for
example). The server is NT. Has anyone done this before?
Any help really appreciated,
Cheers
Gavin
Dear Members,
For the last two years we have had a large software application written in
PHP 4.0.6 with a MySQL 3.23.56 database all running on a single box with
RedHat Linux 9.0. This has worked fantasticly and it is very fast.
For certain business reasons that I wont go into detail here, we
On Wed, 10 Dec 2003, Gavin Dimmock wrote:
Hi All,
I want to change the default port on mysql server from 3306 to 5 (for
example). The server is NT. Has anyone done this before?
Any help really appreciated,
Can either modify the service to start with the --port parameter or add in
your
Yes ODBC connections is considerably slower i have found, it could also be
the native connections class you may be using for ASP, but why why why. Bad
mistake.
Dear Members,
For the last two years we have had a large software application written
in PHP 4.0.6 with a MySQL 3.23.56 database all
David Potter wrote:
Dear Members,
For the last two years we have had a large software application written in
PHP 4.0.6 with a MySQL 3.23.56 database all running on a single box with
RedHat Linux 9.0. This has worked fantasticly and it is very fast.
For certain business reasons that I wont go
I'm thinking about doing this:
Setting up 2 mysql servers each replicating to the other (each a slave
of the other).
Code the connect/j connection creation to try one server on connect. If
it fails, connect to the other server.
Both servers are writeable, but my code is never talking to more
Hi,
In mysql 4.014, the below INSERT statement works fine:
INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10
But in mysql 4.1, it fails, I get a message:
Error Code : 1066
Not unique table/alias: 'TEST_TABLE'
(10 ms taken)
Question: Is this a problem with 4.1 or is it
Hi, can anyone tell me what is the problem of my script:
$sql2 = SELECT * FROM Cash WHERE HP='$HP' and SignUpDate='$SignUpDate';
$rows1 = mysql_query($sql2,$linkptr1) ;
$OwnnerMail =[EMAIL PROTECTED];
$Subject = Testing;
while ( $row =
hi
the error is in this line:
$newvalue = $row[Password];
make it
$newvalue.= $row[Password];
(notice ^ the dot - for concatenation with the
previous value).
and if u want to see each password in the browser too,
in that same loop, put:
echo {$row[Password]\n;
so it would now look like:
Hi,
just got a new MacOS X Server 10.3 (Panther) that came with MySQL
4.0.14. Previous system we had was MacOS X 1.2, the really old one. I
old system I was running MySQL 3.23.39 (if I now remember it right).
I have good reason to believe that we made the change from old to new
by the book.
Greetings every body
I'm developing a web application using JSP ,Mysql and jrun application
server.i need the code of user authentication in jsp.Can any one supply the
same Your help would be appreciated
Regards
Aby
Technical Services
Abhinav Chaturvedi
TransAction Solutions Pty Ltd
88 matches
Mail list logo