Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named "dch_pri" contain some account transaction data in
format of DECIMAL (14,2).
When running following query:
SELECT din_no, SUM(IF(tran_type = "D", dch_pri, -dch_pri)) AS dch_sum
Yes, and it is the same standard used to assign ports -- RFC 1700.
Paras Mukadam wrote:
> Why only port 3306 is used by MySQL? Is there some standard used like used
> for FTP, localhost ports ?
> Thanks !!!
> -- Paras
>
> -
> B
Gelu wrote:
>
> Hi,
> Problems on the network.High risq for corrupting tables.
What kind of network problem it should be because the clients are on the
local machine.
Regards,
@+
--
DouRiX
> Regards,
> Gelu
>
> _
> G.NET SOFTWARE COMPANY
>
Why only port 3306 is used by MySQL? Is there some standard used like used
for FTP, localhost ports ?
Thanks !!!
-- Paras
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
> >Both files are world readable.
>
> How do you know this?
Because FTP tells me they are.
>
> Also, when you say "client machine", what do you mean? In particular,
> are the web server and the MySQL servers running on the same machine?
>
Client machine is the machine running the webserver and
Hi,
For the first question you can make it in two step :
SELECT MIN(id) FROM names;
SELECT * FROM names WHERE id = min ;
SELECT MAX(id) FROM names;
SELECT * FROM names WHERE id = max ;
Regards,
Jocelyn Fournier
PresencePC
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROT
Hi
MySql Details My server is running MySQL 3.23.45 and I have
4.0.0-alpha-nt on my local test machine.
What is the fastest way to select the first or the last row from a database?
I have tried queries like this
(id is an auto incrementing primary key)
select * from names order by id de
I used the perl exec command to run 'mysql --help'. The returned info
says that the client version is 3.23.49. The local infile option was not
listed
in the help.
I assume the client needs to be started like
mysql --local-infile=1 ?
And if local infile is disabled wouldn't I get a different er
- Original Message -
From: "Fiasco" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 7:28 PM
Subject: Re: Re: problem with load data local infile
>
>
> > >The error I receive is:
> > >Can't stat file 'filename' (errcode 2)
> >
> > It can't stat *f
- Original Message -
From: "Fiasco" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 6:28 PM
Subject: Re: Re: problem with load data local infile
> The error I receive is:
> Can't stat file 'filename' (errcode 2)
>
> I noticed what you mentioned a
Hi,
I'm building an appl that will be running in at least 10 machines in the
same time connected to the same mysql server. They will working on the same
table this way:
1) A client ask for 100 records, work with them and update them
2) Each record must be used just once (cause this, the table has
At 6:34 -0500 4/20/02, Darren Vollmer wrote:
>The file is in a world readable directory tree.
>
>Shouldn't the LOCAL qualifier make mysql read the file from the client
>running and not the host?
>
>I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
>FRM file that is in th
Hello,
> Klym writes:
> > I hope I'm not out of line by asking a licensing question. I am
> > working on a MySQL database for a web-based survey. We will be
> > charging a fee to complete the survey and receive reports. Am I
> > required to purchase a MySQL licence for this or does my hosting
At 13:34 +0100 4/19/02, Mick Watson wrote:
>Thank you :-)
>
>I do realise the SQL is not being used as it should be, but as it is not my
>database and nor is it my SQL, there's not much I can do to really change
>either of these I merely have to work with a database that has been
>produced by
At 18:22 +0200 4/20/02, Robert Douglass wrote:
>Hello,
>I'm trying to apply my limited SQL knowledge to my newly acquired MySql
>database and am running into the following problem:
>In the (very good) manual on the mysql website, this example is given
>CREATE TABLE persons (
> id SMALLINT UNSI
Hi,
I followed the steps for two-way replication as described in the
documentation for mysql in section 4.10
We have two servers on suse linux running mysql, lets call them A and B,
considering A as the master and B as the slave
updates and inserts made at both A and B are seen on each other
Check out the Articles & Tutorials at http://www.weberdev.com
Sincerely
berber
Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.
-Original Message-
From: Ashish Joy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 9:01 PM
To: [EMAIL PROT
Hi
A good place to put this would be either in the projects area of
WeberDev.com :
http://www.weberdev.com/index.php3?GoTo=jobmatching/about.php3
or the jobs area of WeberDev.com :
http://www.weberdev.com/index.php3?GoTo=jobs/Jobs.php3
Sincerely
berber
Visit htt
Hi,
Lets say that I am the admin on mysql server, how can
i know which tables currently are locked? And if
they are locked by someone else, how to do I remove
the locks.
Thank you.
Rajan.
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, p
- Original Message -
From: Yahoo! Groupes
<[EMAIL PROTECTED]
r>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 10:56 PM
Subject: Demande de confirmation d'inscription à mysql-france
Bonjour,
Nous avons reçu votre demande d'inscription au groupe
mysql-france sur Yahoo! Groupes, l
Hi.
On Sat, Apr 20, 2002 at 01:12:14AM -0700, [EMAIL PROTECTED] wrote:
> Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
> merge tables themselves work in later 3.23 versions.
As I said, "INSERT for MERGE" was introduced in 4.0 (including
INSERT_METHOD). Of course, MERGE ta
Hello,
I'm trying to apply my limited SQL knowledge to my newly acquired MySql
database and am running into the following problem:
In the (very good) manual on the mysql website, this example is given
CREATE TABLE persons (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT NU
Have a look at urSQL (http://www.urbanresearch.com/ursql) -- it allows you
to run ad hoc queries and export the results to several different formats
(ie HTML, MS Word, Excel, Text, etc).
On Sat, 20 Apr 2002, Pierre du Parte wrote:
>
> However, the head bean counter in one office tackled me on th
Hi,
Problems on the network.High risq for corrupting tables.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Do-R
Hi all,
Does somebody know what cause these errors ? (the option 'warnings' is
turned on)
It's debian 3.0, mysql 3.23.47-log, the application which use mysql are
freeradius, postfix and courier (all in localhost).
020420 16:45:57 Aborted connection 172 to db: 'radius' user: 'radiusd'
host: `l
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV> The file is in a world readable directory tree.
DV> Shouldn't the LOCAL qualifier make mysql read the file from the client
DV> running and not the host?
DV> I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
The file is in a world readable directory tree.
Shouldn't the LOCAL qualifier make mysql read the file from the client
running and not the host?
I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
FRM file that is in the databases directory on the Mysql host. The server
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV> The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV> Darren
--
For
Hi,
This might work for you but with two quries:
SELECT @minval := least(min(colOne),min(colTwo)) FROM myTable;
SELECT colOne-@minval FROM myTable;
Anvar.
At 06:26 PM 19/04/2002 -0400, you wrote:
>I am trying to normalize a data set based on the minimum values of certain
>columns.
>
>I figured
On Fri, 19 Apr 2002 16:03:44 -0500 (CDT)
Russell E Glaue <[EMAIL PROTECTED]> wrote:
>
> I think it would be a good idea to be able to specify the error log on
> the command line when starting mysqld. Right now mysql users can only
> specify the following logs on the command line:
> log (ac
The file does exist. The file and its directory are 0777 permission.
Darren
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 20, 2002 4:32 AM
Subject: Re: problem with load data local infile
> Darren,
> Friday, April 19
### CHANGES ###
--- version 15.12 ---
- module tables can now be iconified so that they do not clutter
dashboards
- added minimize button to module tables
- save module tables minimize state and icon coordinates in
configuration (save) files
- implemented automatic intelligent icon managemen
Darren,
Friday, April 19, 2002, 3:33:50 PM, you wrote:
DV> I am having problems with load data local infile.
DV> The mysql host server is running 3.23.23
DV> I was able to successfully use load data local infile before to import data
DV> off of a client machine onto the mysql host but now all i
I use phpBB.
When I change default character set in mysql I have a problem in phpBB so:
Warning: Supplied argument is not a valid MySQL result resource in
/../functions.php on line 230
Unable to query db!
But /../admin/index.php regularly runs.
What my problem is?
thanks
Edakom Internet Soru
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
merge tables themselves work in later 3.23 versions. If this is the
case the documentation needs to be updated to show which version
supports what.
Eric
On Sat, 20 Apr 2002, Benjamin Pflugmann wrote:
> Hi.
>
> AFAIK, insert
I am gradually winning the war in promoting opensource to a number of my
key customers. Notably a couple have made the move to OpenOffice.org,
albeit on Windows. I am currently re-writing a key application to use
mySQl (previously Access), so in all I'm pleased.
However, the head bean counter
Hi ,
I am working on Performance Management in MySQL. I got the information of
table and the type of data is.
Now the problem is that how can I work on performance.
For Example :- As we know that mysql support 4GB Data per table
and we also knows that mediumtext can support 4GB data per column.
N
37 matches
Mail list logo
