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 datab
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
--
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.
-O
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
mysq
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 u
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 [mailto:[
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 :
[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
> 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
binlog-ignore
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 D
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
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
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 5.
[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 G
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
http://lists.mysql.com/list.ph
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_
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 DAYNAME('
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 Turme
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 p
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
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,
>
> Recentl
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 .err file in /var/lib/mysql/data?
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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. Bull
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
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 PROTECTE
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 ] S
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 SHOW_DATABASE
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 t
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 l
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
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 PR
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
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 --rep
"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.h
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 fo
> 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)
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
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)
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
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: [50
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
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 wil
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
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:
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 th
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
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 DAYNAME('2004
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" c
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 t
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
> 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 cras
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 replicati
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:
--
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
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: 10
I would like to join the group.
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
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 =
mysql_query($sql
"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
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
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';
http://www.mysql.com/doc/en/S
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 p
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
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 instantly..."P
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
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 v
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/
scribot.
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 hal
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 Li
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]
"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
>
>
> or will I have to so the A-B calculation in my applicat
-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.
...
%
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick, et al --
...and then Rick Emery said...
%
%
%
% Remove space between '-p' and the password in you command line.
% That is>>bash-2.05a$ mysql -uwcjporoot -pwc_jpo
Actually, wc_jpo is the name of the database, and -p without a password
pro
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 I had installed MySQL using rpm as detailed in a SAMS book
http://tinyurl.com/2pq27
It installed fine and worked ok - I connec
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
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
or will I have to so the A-B calculation in my application code instead?
Also can I use
select C from X where
Then
update X set C = (ret
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
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 AL
Remove space between '-p' and the password in you command line.
That is>>bash-2.05a$ mysql -uwcjporoot -pwc_jpo
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 23, 2004 6:36 AM
Subject: Re: created user but access denied
D
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 this
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 b
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
H
-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 af
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
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 wou
-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 app
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
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,
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 '/home/ri
"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:
http://www.mysql.com/doc/en/Co
89 matches
Mail list logo
