Problem with HAVING
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
FROM pa_ch2
WHERE x_status IN ("", "C")
AND dch_acc IN ('231000', '31')
GROUP BY din_no
HAVING dch_sum # 0
It remove all record that contain absolute value between 0 and 0.99
Change query to:
SELECT din_no, SUM(IF(tran_type = "D", dch_pri, -dch_pri)) AS dch_sum
FROM pa_ch2
WHERE x_status IN ("", "C")
AND dch_acc IN ('231000', '31')
GROUP BY din_no
HAVING dch_sum <> 0
It will retain all result record which dch_sum = 0
Change the HAVING dch_sum # 0 to HAVING dch_sum # 0.00
Or
Change the HAVING dch_sum <> 0 to HAVING dch_sum <> 0.00
Doesn't improve.
Any idea?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: general question
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 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets ...
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 > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: Do-Risika RAFIEFERANTSIARONJY <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, April 20, 2002 6:15 PM > Subject: Got an error reading communication packets ... > > > > > 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: `localhost' (Got an error reading communication packets) > > 020420 16:45:57 Aborted connection 171 to db: 'radius' user: 'radiusd' > > host: `localhost' (Got an error reading communication packets) > > 020420 16:45:57 Aborted connection 170 to db: 'radius' user: 'radiusd' > > host: `localhost' (Got an error reading communication packets) > > 020420 16:45:57 Aborted connection 178 to db: 'radius' user: 'radiusd' > > host: `localhost' (Got an error reading communication packets) > > 020420 16:45:57 Aborted connection 177 to db: 'radius' user: 'radiusd' > > host: `localhost' (Got an error reading communication packets) > > 020420 16:45:57 Aborted connection 179 to db: 'radius' user: 'radiusd' > > host: `localhost' (Got an error reading communication packets) > > 020420 16:47:37 Aborted connection 165 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:47:37 Aborted connection 164 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:47:37 Aborted connection 166 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:47:38 Aborted connection 168 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:47:38 Aborted connection 167 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:50:23 Aborted connection 199 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > 020420 16:50:23 Aborted connection 198 to db: 'mail' user: 'smtpd' > > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > > communication packets) > > > > Regards, > > > > -- > > Do-Risika RAFIEFERANTSIARONJY, SysAdmin > > mailto:[EMAIL PROTECTED] > > > > Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg > > Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
general question
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.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: problem with load data local infile
> >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 MySQL client. The host machine runs the actual MySQL server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select first or last row
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 PROTECTED]>
Sent: Sunday, April 21, 2002 4:50 AM
Subject: select first or last row
> 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 desc limit 1
> select * from names order by id asc limit 1
> select * from names limit 1
>
>
> if I run the following sql queries with the explain command it returns the
> following results
>
>
> table type possible_keys key key_len ref rows Extra
> - - --- --- --- -
> names index NULL PRIMARY 4 NULL 61368
> *
>
> No matter what I do, and what indexes I use, I cannot seem to find a way
of
> selecting the last or first row without scanning the whole table.
>
>
> A few times recently I've wished for a new table type, a table that acts
> more like a pipe or stack just to solve this problem.
>
> Thanks
> Pete Kelly
>
>
> Other Items on my MySql wish list.
>
> 1 . It would also be nice to combine a select and a delete command
together
> to form a whole new command, (Retrive data and auto delete the row)
> 2 . Another new command I would like to see is "Show Processlist History",
> basically this would show the last 30 or so queries run on the server.
> 3. I often run queries like this
>
> SELECT id FROM users WHERE name = 'pete'
> if the row exists
> UPDATE users SET visits=visits+1 WHERE name = 'pete'
> else
> INSERT INTO users (name) VALUES ('pete')
>
> It would be nice to make this type of code quicker.
>
>
>
>
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
select first or last row
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 desc limit 1
select * from names order by id asc limit 1
select * from names limit 1
if I run the following sql queries with the explain command it returns the
following results
table type possible_keys key key_len ref rows Extra
- - --- --- --- -
names index NULL PRIMARY 4 NULL 61368
*
No matter what I do, and what indexes I use, I cannot seem to find a way of
selecting the last or first row without scanning the whole table.
A few times recently I've wished for a new table type, a table that acts
more like a pipe or stack just to solve this problem.
Thanks
Pete Kelly
Other Items on my MySql wish list.
1 . It would also be nice to combine a select and a delete command together
to form a whole new command, (Retrive data and auto delete the row)
2 . Another new command I would like to see is "Show Processlist History",
basically this would show the last 30 or so queries run on the server.
3. I often run queries like this
SELECT id FROM users WHERE name = 'pete'
if the row exists
UPDATE users SET visits=visits+1 WHERE name = 'pete'
else
INSERT INTO users (name) VALUES ('pete')
It would be nice to make this type of code quicker.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: problem with load data local infile
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 error message then can't get stat of 'filename' (Errcode 2)? Thanks for your help and patience Darren - Original Message - From: "Fiasco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 7:36 PM Subject: Fw: Re: problem with load data local infile > > - 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 *filename*? Don't make up error messages, report them > > exactly. > > > > > > > Can't get stat of 'filename' (Errcode 2) > > Filename being the fully qualified path of whatever file I am trying to > > infile. > > > > > > > >I tried local infiling the following two files > > > >/usr/bin/znew (exists on both machines) > > > >/usr/games/worms (exists only on client machine) > > > > > > What are the modes on both files? > > > > > > > Both files are world readable. > > > > > > > > > >Even though I specified local on the infile > > > >statement, mysql successfully imported > > > >/usr/bin/znew into the specified table. > > > >/usr/games/worms was returned the same > > > >can't stat file (errcode 2) message. > > > > > > Then its mode is probably different. Perhaps execute-only. > > > > Modes are the same. > > > > > > > > > > > > >It looks like the LOCAL argument is being > > > >ignored all together. > > > > > Mmm ... doubt it. > > > > Why is the load data local infile statement successfully importing files > > that reside > > on the mysql host but not the mysql client machine? With local specified, > > the host > > shouldn't even be looking for files located on it should it? > > > > > > > > > > > > >Is it posible that my host is 3.23.23-beta, and > > > >that my client is a newer version of mysql and > > > >that the client has local disabled? Whats the > > > >quickest way to find the version of my client? I only > > > >have access to mysql through perl/php > > > > > > Invoke the mysql_get_client_info() function. It'll tell you > > > the version of the client library. > > > > I only have access to the database via perl or php. How do I call > > the C API function mysql_get_client_info() from perl? > > > > > > > > It's entirely possible, likely even, that the client library has been > > > updated. But based on your /usr/bin/znew, /usr/bin/games experience, > > > that seems unlikely. > > > > > > > > > > >Is there a way to find out what startup options > > > >were specified for Mysql through perl dbi or > > > >php access? > > > > > > Not that I know of. > > > > > > >- Original Message - > > > >From: "Paul DuBois" <[EMAIL PROTECTED]> > > > >To: "Darren Vollmer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > > "Victoria > > > >Reznichenko" <[EMAIL PROTECTED]> > > > >Sent: Saturday, April 20, 2002 5:12 PM > > > >Subject: Re: Re: problem with load data local infile > > > > > > > > > > > >> 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 the databases directory on the Mysql host. The > > > >server > > > >> >found the file even though I specified local. Don't know if that > > means > > > >> >anything or not, or if that is normal mysql behavior. > > > >> > > > > >> >exp; > > > >> >load data local infile 'table.frm' replace into table testtable > > > >> > > > > >> >Shouldn't mysql be looking for table.frm on my client machine and > not > > the > > > >> >server? > > > >> > > > >> LOCAL requires only that you be able to read the file. > > > >> > > > >> With the LOCAL keyword, the program on the client machine reads the > > file > > > >> and sends it to the server to be inserted into the table. The MySQL > > > >server > > > >> takes those records, and it's what accesses the table.frm file. > > > >> > > > >> How could the client access table.frm? That file isn't even on the > > client > > > >> host necessarily. > > > >> > > > >> Something that might account for the difficulty, if you've upgraded > > MySQL > > > >> recently: > > > >> A change was made in MySQL 3.23.49 that causes LOCAL to be disabled > > (by > > > >> default?). You may be able to re-enable it by invoking mysql with > the > > > >> --local-infile option. Try mysql --help to see if that option is > > listed > > > >
Fw: Re: problem with load data local infile
- 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 *filename*? Don't make up error messages, report them > exactly. > > > > Can't get stat of 'filename' (Errcode 2) > Filename being the fully qualified path of whatever file I am trying to > infile. > > > > >I tried local infiling the following two files > > >/usr/bin/znew (exists on both machines) > > >/usr/games/worms (exists only on client machine) > > > > What are the modes on both files? > > > > Both files are world readable. > > > > > > >Even though I specified local on the infile > > >statement, mysql successfully imported > > >/usr/bin/znew into the specified table. > > >/usr/games/worms was returned the same > > >can't stat file (errcode 2) message. > > > > Then its mode is probably different. Perhaps execute-only. > > Modes are the same. > > > > > > > > >It looks like the LOCAL argument is being > > >ignored all together. > > > Mmm ... doubt it. > > Why is the load data local infile statement successfully importing files > that reside > on the mysql host but not the mysql client machine? With local specified, > the host > shouldn't even be looking for files located on it should it? > > > > > > > > >Is it posible that my host is 3.23.23-beta, and > > >that my client is a newer version of mysql and > > >that the client has local disabled? Whats the > > >quickest way to find the version of my client? I only > > >have access to mysql through perl/php > > > > Invoke the mysql_get_client_info() function. It'll tell you > > the version of the client library. > > I only have access to the database via perl or php. How do I call > the C API function mysql_get_client_info() from perl? > > > > > It's entirely possible, likely even, that the client library has been > > updated. But based on your /usr/bin/znew, /usr/bin/games experience, > > that seems unlikely. > > > > > > > >Is there a way to find out what startup options > > >were specified for Mysql through perl dbi or > > >php access? > > > > Not that I know of. > > > > >- Original Message - > > >From: "Paul DuBois" <[EMAIL PROTECTED]> > > >To: "Darren Vollmer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > "Victoria > > >Reznichenko" <[EMAIL PROTECTED]> > > >Sent: Saturday, April 20, 2002 5:12 PM > > >Subject: Re: Re: problem with load data local infile > > > > > > > > >> 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 the databases directory on the Mysql host. The > > >server > > >> >found the file even though I specified local. Don't know if that > means > > >> >anything or not, or if that is normal mysql behavior. > > >> > > > >> >exp; > > >> >load data local infile 'table.frm' replace into table testtable > > >> > > > >> >Shouldn't mysql be looking for table.frm on my client machine and not > the > > >> >server? > > >> > > >> LOCAL requires only that you be able to read the file. > > >> > > >> With the LOCAL keyword, the program on the client machine reads the > file > > >> and sends it to the server to be inserted into the table. The MySQL > > >server > > >> takes those records, and it's what accesses the table.frm file. > > >> > > >> How could the client access table.frm? That file isn't even on the > client > > >> host necessarily. > > >> > > >> Something that might account for the difficulty, if you've upgraded > MySQL > > >> recently: > > >> A change was made in MySQL 3.23.49 that causes LOCAL to be disabled > (by > > >> default?). You may be able to re-enable it by invoking mysql with the > > >> --local-infile option. Try mysql --help to see if that option is > listed > > >> in the help message. > > >> > > >> By the way, what was the error message you got? > > >> > > >> > > > >> > > > >> >- Original Message - > > >> >From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > > >> >To: <[EMAIL PROTECTED]> > > >> >Sent: Saturday, April 20, 2002 6:14 AM > > >> >Subject: Re: Re: problem with load data local infile > > >> > > > >> > > > >> >> 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 > > >> > > >> > > > --
Fw: Re: problem with load data local infile
- 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 about disabling > local in the documentation but I am using mysql > verson 3.23.23-beta (host) not sure what the client > is. > > Which can't stat the file, the MySQL host server, > or the MySQL client? > > I did some more testing. > > I tried local infiling the following two files > /usr/bin/znew (exists on both machines) > /usr/games/worms (exists only on client machine) > > Even though I specified local on the infile > statement, mysql successfully imported > /usr/bin/znew into the specified table. > /usr/games/worms was returned the same > can't stat file (errcode 2) message. > > It looks like the LOCAL argument is being > ignored all together. > > Is it posible that my host is 3.23.23-beta, and > that my client is a newer version of mysql and > that the client has local disabled? Whats the > quickest way to find the version of my client? I only > have access to mysql through perl/php > > Is there a way to find out what startup options > were specified for Mysql through perl dbi or > php access? > > - Original Message - > From: "Paul DuBois" <[EMAIL PROTECTED]> > To: "Darren Vollmer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Victoria > Reznichenko" <[EMAIL PROTECTED]> > Sent: Saturday, April 20, 2002 5:12 PM > Subject: Re: Re: problem with load data local infile > > > > 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 the databases directory on the Mysql host. The > server > > >found the file even though I specified local. Don't know if that means > > >anything or not, or if that is normal mysql behavior. > > > > > >exp; > > >load data local infile 'table.frm' replace into table testtable > > > > > >Shouldn't mysql be looking for table.frm on my client machine and not the > > >server? > > > > LOCAL requires only that you be able to read the file. > > > > With the LOCAL keyword, the program on the client machine reads the file > > and sends it to the server to be inserted into the table. The MySQL > server > > takes those records, and it's what accesses the table.frm file. > > > > How could the client access table.frm? That file isn't even on the client > > host necessarily. > > > > Something that might account for the difficulty, if you've upgraded MySQL > > recently: > > A change was made in MySQL 3.23.49 that causes LOCAL to be disabled (by > > default?). You may be able to re-enable it by invoking mysql with the > > --local-infile option. Try mysql --help to see if that option is listed > > in the help message. > > > > By the way, what was the error message you got? > > > > > > > > > > >- Original Message - > > >From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Saturday, April 20, 2002 6:14 AM > > >Subject: Re: Re: problem with load data local infile > > > > > > > > >> 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 > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Many clients working with distinct records
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 a tinyint field called "updated" that is setted to "1" by a client after the job is done) 3) Each client should get distinct records. (Example: machine01 get the 001-100 records, machine02 get the 101-200, and so on) 4) The clients don't comunicate one to another. Anyone here has an idea about how can i do that? BTW: i'm using the C API Thank u very much, Dirso. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: problem with load data local infile
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 the databases directory on the Mysql host. The server >found the file even though I specified local. Don't know if that means >anything or not, or if that is normal mysql behavior. > >exp; >load data local infile 'table.frm' replace into table testtable > >Shouldn't mysql be looking for table.frm on my client machine and not the >server? LOCAL requires only that you be able to read the file. With the LOCAL keyword, the program on the client machine reads the file and sends it to the server to be inserted into the table. The MySQL server takes those records, and it's what accesses the table.frm file. How could the client access table.frm? That file isn't even on the client host necessarily. Something that might account for the difficulty, if you've upgraded MySQL recently: A change was made in MySQL 3.23.49 that causes LOCAL to be disabled (by default?). You may be able to re-enable it by invoking mysql with the --local-infile option. Try mysql --help to see if that option is listed in the help message. By the way, what was the error message you got? > > >- Original Message - >From: "Victoria Reznichenko" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, April 20, 2002 6:14 AM >Subject: Re: Re: problem with load data local infile > > >> 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: licence
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 > > company who sold me the use of MySQL cover the licence? If you don't distribute MySQL (i.e. in you situation you just use MySQL as web site backend), you don't need to purchase MySQL license. Of course you can buy a license, if you want to support MySQL development. If that installation is mission critical for your business, you should consider buying MySQL support. Our various support are listed at http://www.mysql.com/support/ Kind Regards, MySQL AB Iko Rein -- For technical support contracts, goto https://order.mysql.com/?ref=imr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Iko Rein <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Director of Online Sales /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: group by help?
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 a third party group, and I must say at this point that I have >nothing but praise for the ensembl group for the difficult job that they have >done very well (see http://www.ensembl.org) > >So, I realise this is not the problem of mySQL, but what I want to try and >find out is really the internal workings of mySQL when it performs this >operation so that I can understand why my copy of ensembl, which is produced >from direct dumps of the main ensembl, behaves differently to the main >ensembl. I guess you won't want to hear this, but that is completely the wrong approach. You *might* be able to achieve the same query output on both machines by dumping the database on one machine, then dropping and reloading the tables on both machines using the same copy of the dump. Then presumably both tables will have both records loaded in the same order, and the query *might* produce the same result on both machines. - ...until the table gets modified - ...until MySQL is upgraded on one machine and not the other, and something happens in the query optimizer that changes the query output - ...etc. The group you're working with *must* change the queries to be correct. Otherwise, you're entirely at the mercy of any number of external factors that can change the output and over which you have no control. > >I guess from what you are saying, that the data is stored randomly, that there >is very little I can do to actually make my database behave the same as the >main database? Could it be affected in any way by operating system and/or >file system? Superficially the data is organised in exactly the same way in >both databases, but I have no doubt that things like memory locations are >completely different, but possibly if I could understand what the variables >are that affect this behaviour I could minimise the inconsistancy...? > >Thanks for your time > >Mick > >Richard Emery wrote: > >> mysql is acting correctly. >> >> GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your >> SELECT statement makes not such request. You have simply requested the >> value of a specific field. Data are stored in mysql databases randomly. >> Therefore, when you request a field's data, you are getting whatever is >> first in the list of records matching your WHERE clause. >> >> Bottom line: you are NOT using GROUP BY as it is supposed to be used. Your > > SQL is in error, not mysql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: missing foreign keys
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 UNSIGNED NOT NULL AUTO_INCREMENT,
> name CHAR(60) NOT NULL,
> PRIMARY KEY (id)
>);
>
>CREATE TABLE shirts (
> id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
> style ENUM('t-shirt', 'polo', 'dress') NOT NULL,
> color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL,
> owner SMALLINT UNSIGNED NOT NULL REFERENCES persons,
> PRIMARY KEY (id)
>);
>
>INSERT INTO persons VALUES (NULL, 'Antonio Paz');
>
>INSERT INTO shirts VALUES
>(NULL, 'polo', 'blue', LAST_INSERT_ID()),
>(NULL, 'dress', 'white', LAST_INSERT_ID()),
>(NULL, 't-shirt', 'blue', LAST_INSERT_ID());
>
>How do you do the same thing later though, when LAST_INSERT_ID() won't work
>any more? How can I insert into shirts later, when 'Antonio Paz' isn't the
>last thing inserted? In my prior SQL experience, I'd do something like this:
>CONSTRAINT personWithShirts FOREIGN KEY () REFERENCES Person ()). How in
>MySql?
Look up the key later when you need it.
You're saying that adding a constraint to shirts magically allows the
database to figure out which id from the persons table to associate with
new shirts records?
>
>Thanks,
>RD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
regarding replication in mysql
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 but the
following case doesn't work
1)The ethernet cable which connects A to the network is removed that is
the master is running but it can't see the slave.
2) INSERTS are made to B
3) A is brought back to the network
Now when it is checked for with a select statement.
some additional updates are seen on the table in A,
i.e. all the updates and inserts made on B right from the beginning are
re-entered into the table on A
e.g.
1) on B
insert into customer('ronak',24);
insert into customer ('raghu', 25);
on A
select * from Customers;
ronak 24
raghu 25
would be the output.
2)The ethernet cable of A is removed removing it from the network.
3) on B the following inserts and updates are made.
insert into customer('ramveera',23);
insert into customer('rocky',23);
4) A is bought back to the network
select * from customers.
would give
ronak 24
raghu 25
ronak 24 // added again
raghu 25 // added again
ramveera 23
rocky 23
whereas the output one would expect is
ronak 24
raghu 25
ramveera 23
rocky 23
Could anyone please suggest a solution to this.
regards,
Shivam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: some good tutorial
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 PROTECTED] Subject: some good tutorial hi everybody, i have just joined the list and wanted to know something about mysql. is there some really good tutorial you think might be good for a starter in mysql. i am a master's student and have some knowledge of databases like ms access, oracle. hope to get some good stuff. regards ashish See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02 0201/splash.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Seeking Freelancer
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 http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Will K. [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 7:07 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Seeking Freelancer Greets Folks, I need help with some too-involved-for-me CGI stuff, and I'd like to work with a freelance programmer/consultant. The consulting will be for a mature themed site, and I am running on a limited budget, so open minds only please. The project is for a paid membership site using Perl/MySQL. The site will also run a number of other CGI programs, namely eCards, bulletin boards, auction and image galleries. Some of the work I can handle myself, but other times I may need direct assistance. Thanks, Will _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table Locks...
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, pool and more http://games.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Demande de confirmation d'inscription à mysql-france
- 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, le nouveau service de communautés de Yahoo!. Pour vous inscrire, vous devez confirmer votre demande en répondant à ce message. Si vous n'avez pas demandé ou ne souhaitez pas vous inscrire au groupe mysql-france, veuillez ignorer ce message. Cordialement, L'équipe support Yahoo! Groupes L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des Conditions d'utilisation et de la Charte sur la vie privée, disponibles respectivement sur http://fr.docs.yahoo.com/info/utos.html et http://fr.docs.yahoo.com/info/privacy.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syntax error with merge tables
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 tables were supported before. > If this is the case the documentation needs to be updated to show > which version supports what. >From http://www.mysql.com/doc/C/R/CREATE_TABLE.html: -- If you want to insert data in a MERGE table, you have to specify with INSERT_METHOD into with table the row should be inserted. See section 7.2 MERGE Tables. This option was introduced in MySQL 4.0.0. -- IMHO, specific enough. Regards, Benjamin. > On Sat, 20 Apr 2002, Benjamin Pflugmann wrote: > > > > AFAIK, insert for MERGE tables was introduced in version 4.0.0. Let's > > see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so. [...] -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
missing foreign keys
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 NULL,
PRIMARY KEY (id)
);
CREATE TABLE shirts (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
style ENUM('t-shirt', 'polo', 'dress') NOT NULL,
color ENUM('red', 'blue', 'orange', 'white', 'black') NOT NULL,
owner SMALLINT UNSIGNED NOT NULL REFERENCES persons,
PRIMARY KEY (id)
);
INSERT INTO persons VALUES (NULL, 'Antonio Paz');
INSERT INTO shirts VALUES
(NULL, 'polo', 'blue', LAST_INSERT_ID()),
(NULL, 'dress', 'white', LAST_INSERT_ID()),
(NULL, 't-shirt', 'blue', LAST_INSERT_ID());
How do you do the same thing later though, when LAST_INSERT_ID() won't work
any more? How can I insert into shirts later, when 'Antonio Paz' isn't the
last thing inserted? In my prior SQL experience, I'd do something like this:
CONSTRAINT personWithShirts FOREIGN KEY () REFERENCES Person ()). How in
MySql?
Thanks,
RD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GUI for mySQL
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 this - "In > Access I can quickly create queries and export the results in all manner > of ways. What do I do if we let you talk us into mySql?" > > Where indeed? Are there any nice, user friendly GUI available for mySQL > ad-hoc query and report design? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Got an error reading communication packets ...
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-Risika RAFIEFERANTSIARONJY <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:15 PM Subject: Got an error reading communication packets ... > > 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: `localhost' (Got an error reading communication packets) > 020420 16:45:57 Aborted connection 171 to db: 'radius' user: 'radiusd' > host: `localhost' (Got an error reading communication packets) > 020420 16:45:57 Aborted connection 170 to db: 'radius' user: 'radiusd' > host: `localhost' (Got an error reading communication packets) > 020420 16:45:57 Aborted connection 178 to db: 'radius' user: 'radiusd' > host: `localhost' (Got an error reading communication packets) > 020420 16:45:57 Aborted connection 177 to db: 'radius' user: 'radiusd' > host: `localhost' (Got an error reading communication packets) > 020420 16:45:57 Aborted connection 179 to db: 'radius' user: 'radiusd' > host: `localhost' (Got an error reading communication packets) > 020420 16:47:37 Aborted connection 165 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:47:37 Aborted connection 164 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:47:37 Aborted connection 166 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:47:38 Aborted connection 168 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:47:38 Aborted connection 167 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:50:23 Aborted connection 199 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > 020420 16:50:23 Aborted connection 198 to db: 'mail' user: 'smtpd' > host: `simicro-193-251-140-214.simicro.net' (Got an error reading > communication packets) > > Regards, > > -- > Do-Risika RAFIEFERANTSIARONJY, SysAdmin > mailto:[EMAIL PROTECTED] > > Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg > Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Got an error reading communication packets ...
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: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 171 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 170 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 178 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 177 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:45:57 Aborted connection 179 to db: 'radius' user: 'radiusd' host: `localhost' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 165 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 164 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:37 Aborted connection 166 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 168 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:47:38 Aborted connection 167 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 199 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) 020420 16:50:23 Aborted connection 198 to db: 'mail' user: 'smtpd' host: `simicro-193-251-140-214.simicro.net' (Got an error reading communication packets) Regards, -- Do-Risika RAFIEFERANTSIARONJY, SysAdmin mailto:[EMAIL PROTECTED] Simicro Internet, mailto:[EMAIL PROTECTED], http://internet.simicro.mg Tel : (+261) 20 22 648 83 (GMT +3), Fax : (+261) 20 22 661 83 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: problem with load data local infile
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 DV> FRM file that is in the databases directory on the Mysql host. The server DV> found the file even though I specified local. Don't know if that means DV> anything or not, or if that is normal mysql behavior. DV> exp; DV> load data local infile 'table.frm' replace into table testtable DV> Shouldn't mysql be looking for table.frm on my client machine and not the DV> server? Have you changed the client software? What is your client version? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: problem with load data local infile
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 found the file even though I specified local. Don't know if that means anything or not, or if that is normal mysql behavior. exp; load data local infile 'table.frm' replace into table testtable Shouldn't mysql be looking for table.frm on my client machine and not the server? - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:14 AM Subject: Re: Re: problem with load data local infile > 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 technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: problem with load data local infile
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 technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do i applying an equation to every row of a result set?
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 out that I can get the minimum value using a query like >SELECT least(min(colOne),min(colTwo)) FROM myTable > >Is there a way I can do the normalization in a single query? >Ideally, something like... >SELECT colOne-least(min(colOne),min(colTwo)) FROM myTable > >I realize that that does not work and maybe I need some kind of join. Is it >possible to apply that subtraction to every row of the result set when it is >returned? (instead of normalizing after I retrieve the result) > >thx > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Specifying Error Log
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 (access/activity log) > log bin > log bin index > log update > log isam > log slow-queries > innodb_log_* > > I would love to be able to specify the error log on the command line. > log error > ( by default-only it is $MYSQL_ROOT/var/`hostname`.err ) > mysqld --log-error=/usr/mysql/logs/error.log > > Maybe some people don't like that it is flagged as an "error" log. > I really don't care what it is referred to as long as I can actually > specify the name and location of the log. > > Does anyone else have an opinion on this? > -RG > Hi! We have in our WorkLog an entry that would handle the above option, only this is not such a high priority for us and most of our users. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with load data local infile
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, 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 get is a > DV> can't stat file errcode2 message. > > DV> I know that the pathname I am using is correct. > DV> What would keep the mysql server from being able to see the file? > > 1. Does the file exist there? > 2. Does MySQL have permissions on the file and dirs? > > DV> Thanks > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: moodss-15.12
### 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 management in canvas area - added values table viewer that simply displays current cell values, useful for keeping important cells visible, now that module data tables can be iconified - pie viewers now handle long cell labels better by displaying them in a new line - when resized to a small width, bar chart and graph viewers keep displaying a minimally sized graphical area instead of axises remnants - in myhealth MySQL module, added key efficiency indicator (as in the mytop software) - in ps module, added --files switch for displaying the number of open files per process - slightly improved moodss and moomps daemon startup time ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 15.12. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a "lifesaver". Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later reused through a command line switch, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myerrorlog, myhealth, myprocs, myquery, myreplication, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running "wish moodss ps cpustats memstats" mimics the "top" application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://tktable.sourceforge.net/ the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the option of using the moodss rpm file (als
Re: problem with load data local infile
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 get is a DV> can't stat file errcode2 message. DV> I know that the pathname I am using is correct. DV> What would keep the mysql server from being able to see the file? 1. Does the file exist there? 2. Does MySQL have permissions on the file and dirs? DV> Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I have a problem!
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 Sorumlusu Gokce Akkaya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Syntax error with merge tables
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 for MERGE tables was introduced in version 4.0.0. Let's > see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so. > > Regards, > > Benjamin. > > > PS: The syntax you used should be fine with a version supporting it > > > > On Fri, Apr 19, 2002 at 04:00:02PM -0700, [EMAIL PROTECTED] wrote: > [...] > > > I always get a syntax error when using INSERT_METHOD in creating merge > > > tables. If I leave off the INSERT_METHOD part it works fine. I have > > > tried this on many versions in the past and now on 3.23.49a. I am > [...] > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUI for mySQL
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 in one office tackled me on this - "In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql?" Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia 2540 http://www.finalfiler.com "If it feels good, do it!" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tunning Process
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. Now the condition arise on what percentage I have to take backup of my database. with mediumtext or without mediumtext. Thax In Advance Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
