Qiang.zhou [EMAIL PROTECTED] wrote:
Dear All;
At oracle8i i can write this sql:
select decode(a.id,null,'NULL',2,God',3,'Norma','Animal') from user
Then i want know ,how to write this at mysql4.1
Use IF() or CASE to rewrite your query:
Rick Duley [EMAIL PROTECTED] wrote:
Hi folks
I am running MySQL 4..0.7-gamma on Red Hat Linux 7.2.
I wish to download data from my database.
I have a directory called 'Results' with permissions set to: drwxrwxrwx
I enter the command:
SELECT * INTO OUTFILE
I'm getting unexpected results when using GROUP BY. If you specify a
WHERE match in the query I get the desired result, but if I remove it,
to show all results, the set returned is inaccurate.
The query counts how many of a certain bcode there are at various prices.
mysql SELECT bcode, price,
Hello colleagues, I'd like to know
IF by enabling the binary logs production I'll affect meaningfully the
MySQL DB performances, and
HOW MUCH the performances are impacted
Any witnesses on this topic?
Regards
Enrico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have just moved my web site from one server to another (whew!) and I am
having a problem with a mysql user definition for a calendar program.
I used mysqldump to dump the calendar database (wc_jpo) and loaded it on
the new server; it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lefty --
...and then BGLefty said...
%
%
% Is there a simple php script out there somewhere (or an example of how to do
It's a little bigger than simple, but have you seen phpMyAdmin?
% it) to create a new database, username and password? I
Hi, all --
I have just moved my web site from one server to another (whew!) and I am
having a problem with a mysql user definition for a calendar program.
I used mysqldump to dump the calendar database (wc_jpo) and loaded it on
the new server; it appears to be happily there. I then ran
grant
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again, all --
...and then David T-G said...
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
Sorry for the duplicate post; I only realized
On 23 Mar 2004, at 10:38, [EMAIL PROTECTED] wrote:
Hello colleagues, I'd like to know
IF by enabling the binary logs production I'll affect meaningfully the
MySQL DB performances, and
HOW MUCH the performances are impacted
I just tested a load of a 6GB mysqldump (MyISAM tables), on an unloaded
David T-G [EMAIL PROTECTED] wrote:
I have just moved my web site from one server to another (whew!) and I am
having a problem with a mysql user definition for a calendar program.
I used mysqldump to dump the calendar database (wc_jpo) and loaded it on
the new server; it appears to be
Hi all,
This morning my server wasn't running. For some reason it had shutdown,
which the error log shows, but what's causing it is a riddle to me. I'm
now running with --log and --log-update to be able to get some info if
it happens again. Any other ideas on how to troubleshoot this or is
OFF TOPIC
Remove space between '-p' and the password in you command line.
That isbash-2.05a$ mysql -uwcjporoot -pwc_jpo
/OFF TOPIC
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 6:36 AM
Subject: Re: created user but
On Monday 22 March 2004 18:26, Shane Nelson wrote:
Thanks, the help file cleared up the rest.
In my case the table tt wasn't a merge table, it was just a table I
created normally. Even so the alter table line didn't create an error.
If the table type other than MERGE, UNION part of the ALTER
Hi i'm trying to write an sql statement which will make a copy of a
table including all its data and indexes. The problem comes with the
fact that the table contain over 20 million lines and i'm looking for a
code or an sql statement that will duplicate this table including its
indexes.
i'm using
Hi,
can operators be used in MySQL e.g.
a table Table X with column A, column B column C
All three are floats
can I use
select (A-B)
from X
where condition
or will I have to so the A-B calculation in my application code instead?
Also can I use
select C from X where condition
Then
Vinay [EMAIL PROTECTED] wrote:
Hi i'm trying to write an sql statement which will make a copy of a
table including all its data and indexes. The problem comes with the
fact that the table contain over 20 million lines and i'm looking for a
code or an sql statement that will duplicate this
Ye That Know,
Short: Does YaST really install MySQL 'all-the-way', or do I now need to run 'make'
and/or 'make install', or other similar commands?
Long:
Previously last week I had installed MySQL using rpm as detailed in a SAMS book
http://tinyurl.com/2pq27
It installed fine and worked ok
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick, et al --
...and then Rick Emery said...
%
% OFF TOPIC
%
% Remove space between '-p' and the password in you command line.
% That isbash-2.05a$ mysql -uwcjporoot -pwc_jpo
Actually, wc_jpo is the name of the database, and -p without a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
%
joe collins [EMAIL PROTECTED] wrote on 23/03/2004
14:33:13:
can operators be used in MySQL e.g.
a table Table X with column A, column B column C
All three are floats
can I use
select (A-B)
from X
where condition
or will I have to so the A-B calculation in my application code
Has anyone had experience with running MySQL on Trusted Solaris?
Thanks,
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
we had a database blown away (oops) and we still have the old
.frm files, is there any way to get this structure back?
is there a way to view the contents of the .frm files to
see how the tables/indexes were setup?
I can't find anything in the docs, faqs, etc.
Dan.
--
MySQL General Mailing
how is possible that crashing a client that was quering a mysql db located in a server
this db(not sure a dbms...) it reports the errors:
Got error 127 from table handler
and
Database error: Metadata query failed.
MySQL Error: 1016 (Can't open file: 'cartella.MYI'. (errno: 145))
Session
Hello,
Recently I've been needing high-resolution timestamps
(year/month/day/hour/minute/seconds/microseconds) in MySQL (to store
network packets, mmm). Is this a planned feature for MySQL in the
future?
Cheers, Leon
--
Leon Brocard.http://www.astray.com/
Hello all,
I've a table like this :
site_1 pkg_name_1 version
site_1 pkg_name_2 version
site_1 pkg_name_3 version
...
site_1 pkg_name_n version
site_2 pkg_name_1 version
site_2 pkg_name_2 version
...
site_2 pkg_name_n version
...
site_n pkg_name_1 version
...
site_n pkg_name_n
David T-G [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G [EMAIL PROTECTED] wrote:
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql
MySQL 4.0.14
Possible to query for existence of a DB. For example
connect to MySQL and run run a command to check if
Database (Test2) existed.
regards
___
Yahoo! Messenger - Communicate
James,
I try to start it at the command line using - mysql, mysqld, mysqld_safe - I've tried
it as root and non-root.
Yes, I get errors - they were listed in my origional post - I don't have then handy
now.
-
I tired mysqld_safe, as you suggested, it bombed but the good thing
Hi I am using replication to do online backups for my tables. Now my next
task is to automate cleaning up of binary log files from Master server.
Assuming I have more than one slave running, and may be at the time of
clean up one of the slave is down for backup, how can I be sure that my
clean up
A Z [EMAIL PROTECTED] wrote:
MySQL 4.0.14
Possible to query for existence of a DB. For example
connect to MySQL and run run a command to check if
Database (Test2) existed.
Use SHOW DATABASES command:
SHOW DATABASES LIKE 'Test2';
Mark,
Did you ever have any luck looking into this? I have
found that if I explicitly set the user and
password parameters for each database in WebSphere
(rather than using a container managed JAAS
authentication entry), I still get the error listed
below, however the database connections will
Kevin Carpenter [EMAIL PROTECTED] wrote:
I try to start it at the command line using - mysql, mysqld, mysqld_safe - =
I've tried it as root and non-root.
Yes, I get errors - they were listed in my origional post - I don't have =
then handy now.
-
I tired mysqld_safe,
Hi,
I'm trying to understand LOCKing mechanism, but it is not enough described in the
manual, so I have to test it myself.
To see what happens when I use tables I haven't locked, I created a PHP script like
this:
$sql = USE fakturace; if(!$res =
I would like to join the group.
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
In the last episode (Mar 23), Emiliano said:
how is possible that crashing a client that was quering a mysql db
located in a server this db(not sure a dbms...) it reports the
errors:
Got error 127 from table handler
and
Database error: Metadata query failed. MySQL Error: 1016 (Can't
Hi,
Everybody talks about setting up replication, but any
documentation on turning off replication?
Regards,
Sam
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
Are you wanting to turn off replication from the master or the slave?
On Tue, 23 Mar 2004, Sam Yathira wrote:
Content-Type: multipart/alternative; name=unnamed
Content-Transfer-Encoding: 7bit
Content-Description:
That was quick!
I am trying to turn it off from master.
--Sam
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 12:34 PM
To: Sam Yathira; [EMAIL PROTECTED]
Subject: Re: How to turn-off the replication?
Are you wanting to turn off
It sounds like the client didn't crash, but the server did. If mysqld
crashed, then any MyISAM tables that were in use at the time of the
crash would definitely need reparing. If you want to ensure that
crashes don't affect tables, use InnoDB or BDB tables instead.
the machine that crashed
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence. I will
use this ID field in another part of the program so I need to make sure
I get all of
At 18:37 +0100 3/23/04, Emiliano wrote:
It sounds like the client didn't crash, but the server did. If mysqld
crashed, then any MyISAM tables that were in use at the time of the
crash would definitely need reparing. If you want to ensure that
crashes don't affect tables, use InnoDB or BDB
Hello,
I have been running mysql3.23 on FreeBSD server for a long time.Lately i decided to
upgrade mysql3.23 to mysql4 using ports. So i first did make uninstall in
usr/ports/databases/mysql323-client and mysql323-server. Than, from
/usr/ports/databases/mysql40-server i gave make install
Hi,
I have a table that looks like this:
CREATE TABLE inventory (
inventoryid int(11) NOT NULL,
sunday int(3),
monday int(3),
tuesday int(3),
wednesday int(3),
thursday int(3),
friday int(3),
saturday int(3),
PRIMARY KEY (inventoryid)
);
And I'm trying to run a command like
SELECT
In the last episode (Mar 23), Jacque Scott said:
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence. I will
use this ID field in another
I have something like A001C, B689, B1001 etc...
Dan Nelson [EMAIL PROTECTED] 3/23/2004 10:07:43 AM
In the last episode (Mar 23), Jacque Scott said:
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that
when
Remove log-updates option from the my.cnf file.
And remove the master info from the slaves.
On Tue, 23 Mar 2004, Sam Yathira wrote:
That was quick!
I am trying to turn it off from master.
--Sam
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
On Tue, 2004-03-23 at 09:54, Jacque Scott wrote:
I need to create a query that will sort by a alpha numeric field. I
need the ID field returned and one problem that I will face is that when
it sorts in alpha numeric the ID field will be out of sequence. I will
use this ID field in another
Dear all,
I am new to mysql replication. I know how to use
the --replicate* options but I would like to know
whether the options act as filter on the master or
on the slave...
From the documentation, it says:
The --replicate-* rules are evaluated as follows
to determine whether a statement will
In the last episode (Mar 23), Jacque Scott said:
I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the
subject of Natural Sorting. There's no builtin function for doing
this, but one solution would be to write a UDF that finds runs of
Hi,
I am a total linux and mysql newb, I am preparing this info as best as
possible. Below is the output from the mysqlbug utility.
I followed the directions for installing mysql based on this page
http://www.mysql.com/doc/en/Installing_binary.html
From: root
To: [EMAIL PROTECTED]
Subject:
Hi,
I would appreciate help with the following.
I have a table where each of the values in a column consists of a
combination of letters and numbers followed by a decimal then a single digit.
Examples of the two types of entries that could be found in this column(accession_num)
are:
BQ877252.1
I am trying to push the performance of a Mysql database a little more,
it's pretty busy, but I hope to squeeze a tad more out of it.
I am a newbie/pretty clueless wrt MySQL in general, so ...
I run the status command, and see the following.
mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)
I will give that a try.
Thank you
Dan Nelson [EMAIL PROTECTED] 3/23/2004 11:31:50 AM
In the last episode (Mar 23), Jacque Scott said:
I have something like A001C, B689, B1001 etc...
Aah. This question pops up about once a year, usually under the
subject of Natural Sorting. There's no
I have something like A001C, B689, B1001 etc...
I had to do something like this, and someone suggested the following:
order by
case
when substring(YourField,1,1) between '0' and '9'
then ''
when substring(YourField,2,1) between '0' and '9'
then left(YourField,1)
On Tue, Mar 23, 2004 at 11:34:13AM -0800, Jim Richardson wrote:
I am trying to push the performance of a Mysql database a little more,
it's pretty busy, but I hope to squeeze a tad more out of it.
I am a newbie/pretty clueless wrt MySQL in general, so ...
I run the status command, and see the
John Brown [EMAIL PROTECTED] wrote:
Hi,
I am a total linux and mysql newb, I am preparing this info as best as
possible. Below is the output from the mysqlbug utility.
I followed the directions for installing mysql based on this page
http://www.mysql.com/doc/en/Installing_binary.html
Chua Choon Keng [EMAIL PROTECTED] wrote:
Dear all,
I am new to mysql replication. I know how to use
the --replicate* options but I would like to know
whether the options act as filter on the master or
on the slave...
On the slave.
From the documentation, it says:
The --replicate-*
There is not a file with that name in
/var/lib/mysql/
or
/var/lib/mysql/mysql
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Trouble Starting DB - First Time Installer
Date: Tue, 23 Mar 2004 22:15:22 +0200
John Brown [EMAIL PROTECTED] wrote:
Hi,
I am a total linux and
Is there a limit on what innodb_buffer_pool_size can be set in 4.0.17
(64-bit Solaris 9)?
I tried setting it to 4G in my.cnf and SHOW VARIABLES says it's 0.
-keith
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote:
tcp0 0 *:3307 *:*
LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ]
A few weeks ago I download the windows version for 5.0.0 and installed
it on my machine. After successfully installing the new version I was
able to connect with all of my old tools including MyCC 0.9.3,
MySQLFront, SQLyog, cmd and MySQL Administrator.
Yesterday I downloaded the 5.0.0 RPM's for
You need to install the default databases.
-Original Message-
From: Kevin Carpenter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 11:32 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Can't Start Deamon - Installed MySQL 4.0.15 using YaST (
SuSE 9.0 Pro)
James,
I
I recently upgraded to mysql 4.0.18. In the past you
could set the option safe-show-databases and that
allowed users to list databases, but only those they
have permissions to see. It seems that this 4.0.18
will only allow users to see ALL databases, or NO
databases, depending on the
n Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote:
tcp0 0 *:3307 *:*
LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM
Hi,
A quick question, which is the most stable version of mysql to run on a very busy and
commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
4.1 seems stable enough, been running it since it was released.
in production, busy, commercial, enterprise environment.
plus it fixes some bugs in 4.0 and adds some (could be potentially)
necessary functions
Dan.
On Tue, 23 Mar 2004 [EMAIL PROTECTED] wrote:
Hi,
A quick question, which is
the mysql group has every permission possible for that directory,
and I installed the binary, not rpm. To be honest, i dont know the
difference, so I went back and looked at the dl path I took I saw the
difference in file names for rpm and binary, my file ended it .tar.gz
From: J.R.
That's weird, since I have only seen the RPM install the databases into
/var/lib/mysql, while the binaries install into /usr/local/mysql
Did you find the hostname.err file in /var/lib/mysql/data?
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
You can get millisecond resolution in MySQL 4.1. Considering most systems
don't even support *true* millisecond resolution, I don't think you're going
to find anything that supports microsecond resolution.
j- k-
On Tuesday 23 March 2004 07:18 am, Leon Brocard wrote:
Hello,
Recently
Sami Maisniemi [EMAIL PROTECTED] writes:
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM LISTENING 3307 public/showq
...
I tried to connect to socket #3307 as
i have mysql folders in both those paths you mention. I can not find a file
with the .err extension at all.
I did a third re-install of mysql, deleting everything first... including
the directories in var/lib/mysql ( I didnt even know those were there until
the other respondant mentioned that
I'm a beginner so don't quote me. I beleive you need something like:
Select hs_identifiers.hs_id_num from hs_identifiers,
where (accession_num LIKE (result of another select statement)%);
I beleive that should give you the first part and if there is anything after
it.
Respectfully,
Ligaya
So what are you asking? I'm confused. Are you asking just to get
'Tuesday'? (SELECT DAYNAME('2004-03-23');) The value of Tuesday where
inventoryid = 1? (SELECT DAYNAME('2004-03-23') FROM inventoryRoom WHERE
inventoryid='1'; which you already had.) Or all the values in Tuesday?
(SELECT
Maybe something like:
Select LIKE pkg_name%, LIKE site_%, version from table group by LIKE
pkg_name% , LIKE site_%;
but I'm still a beginner.
Respectfully,
Ligaya Turmelle
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello all,
I've a table like this :
site_1 pkg_name_1
Greetings All!
We have setting up a mailing list for people who are interested in the
MySQL Users Conference (http://mysql.com/events/uc2004/)
If you are attending, planning to attend or want to know more about the
event, we urge you to join this list by visiting
[EMAIL PROTECTED] wrote:
Hi,
A quick question, which is the most stable version of mysql to run on a very busy and commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
4.0 is a released and stable version.
4.1 is a developement version which is alpha, but quite stable :)
--
MySQL
Gordon wrote:
A few weeks ago I download the windows version for 5.0.0 and installed
it on my machine. After successfully installing the new version I was
able to connect with all of my old tools including MyCC 0.9.3,
MySQLFront, SQLyog, cmd and MySQL Administrator.
Yesterday I downloaded the
Hi
(Sorry by my english, i speak spanish)
I have problem with a Query.
It does not recognize EXISTS nor IN nor NOT IN
My version is MySQL 4.0.11a-gamma
But I do not know if it recognizes those clauses.
I have dealed with the two forms:
1. SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT
Is there a way to do a SQL Select and get a record without specifying the
primary key. Example. I have two tables CANDLE and VOTIVES. Can I define
a select that says SELECT * FROM TABLE WHERE PRIMARY_KEY=...
John Meyer
_
FREE
This works on 4.1.1, not sure if it works on 4.0.14:
show databases like '%backups%'
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 12:33 AM
Subject: If DataBase Exists
MySQL 4.0.14
Possible to query for existence of a DB.
What about using binlog-do-db=database_name
option? In this case only updates will be logged if
the current database is database_name
What if I only wish to replicate a few tables of a
database? Using binlog-do-db=database_name does
limit to this particular database but there is no
[EMAIL PROTECTED] wrote:
Hi
(Sorry by my english, i speak spanish)
I have problem with a Query.
It does not recognize EXISTS nor IN nor NOT IN
My version is MySQL 4.0.11a-gamma
But I do not know if it recognizes those clauses.
I have dealed with the two forms:
1. SELECT usu_id FROM usuario
To date, my understanding is that mysql do not support sub-query.
My suggestion will be by using 2 sql statement.
The first statement will select value from the reference table.
The value retrieve from first statement can be used to construct the second
statement.
Your first sql will be like :
Not sure why you don't get Tuesday. At my place ( I am using 5.1 beta
version). It did return Tuesday for this statement SELECT
DAYNAME('2004-03-23').
Anyway, I can get similar output by using
select date_format('2004-3-23','%W').
-Original Message-
From: Ligaya Turmelle
Hello
Any help would be appreciated.
i have problem adding user to mysql. I can create a database and there is no
problem however I got this ERROR 1047: Unknown command when I tried to add
new user. I don't think I have this problem before.
I run this command
GRANT ALL ON *.* TO
Hi Robert / Victor /. !
Tried your method and got:
error : Failed dependencies
MySQL-server conflicts with
mysql-server-3.23.54a-11
mysql conflicts with mysql-3.23.54a-11
rpm -i mysql-server-3.23.58-1.i386.rpm
error:Failed dependencies:
libmysqlclient.so.10 is needed by
I don't think he wants to return a Value of 'Tuesday', he wants to return
the value of the column NAMED Tuesday.
So instead of
SELECT Tuesday FROM inventoryRoom WHERE inventoryid='1';
He's trying to specify the Tuesday column with DAYNAME('2004-03-23');
I have no idea if that's possible.
You need to download Dynamic client libraries - (including 3.23.x
libraries) to satisfy these dependencies. This is available on mysql
download page. Choose for your particular version.
And if that helps, read the installation procedure, next time before
installation.
Hope that helps
Nitin
you can very well use those files, though, im not sure, if you can check the
table structure bafore restoring it.
HTH
Nitin
- Original Message -
From: dan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 9:34 PM
Subject: using old frm files
we had a database
89 matches
Mail list logo
