Hi,
I am guessing this is the kind of problem that would be easier to solve with
a sub select
SELECT
simpleparts.category,simpleparts.partnumber,simpleparts.manufacturer,simplep
arts.descrp,ABS(packagesParts.pri) as abPRI,categories.sortorder
FROM ((packagenames LEFT JOIN packagesParts ON
±i®p»Ê wrote:
Hi, happy new year!!
Yesterday morning, I operated MySQL (3.23.28) insert some data into a table ,
I found a error and could not find any one can help with:
Has anyone done testing to show the difference between:
#1 - having MySQL on the same server as Apache/PHP
vs.
#2 - having MySQL on its own dedicated computer, TCP/IP connected to the
main Apache box
NOTE: We use lots of little MySQL lookups in our PHP scripts. Nothing
that intensive.
Nope, i didn't, but i compiled using the same options as the ports-version.
But i'll give it a try right away.
How about someone using both mysql/php/FreeBSD4.2 ? Aren't there any with
that configuration, who has has the problems as i have? I strongly believe
the problem is related to something
Hello,
Problem description:
I have posted several emails to this list during the last few
days because of mysqld crashes and index corruptions. After
upgrading from 3.22.32 to 3.23.30 server crashes have
disappeared but with still had index corruptions (between one
and two tables corrupted every
Hi.
On Tue, Jan 16, 2001 at 12:20:50AM -0800, [EMAIL PROTECTED] wrote:
On Tue, Jan 16, 2001 at 08:01:26AM +, John Dean wrote:
At 23:38 15/01/2001 -0800, you wrote:
Probably in version 4.1 or so.
Is that a fact. Well that's news to me :o)
I could probably dig up the e-mail in
Hi!
"David" == David Mechner [EMAIL PROTECTED] writes:
David Hi,
David My license number is 7697. I don't know what the expiration date is. I'm
running 3.23.28-gamma msqld-opt under w2k.
David I'm trying to use a HEAP table to speed up data access, but every select I do
which references an
Hi ,
I'm using mysql driver for JDBC ("org.gjt.mm.mysql.Driver").
I am using result set and i want to update a record that exists in the set.
In order to do so i used the following code:
rs.updateString(4,"");
rs.updateRow();
and i got
Bonjour,
Je suis novice en configuration de bases de données.
J'ai installé php3, apache, mysql et phpMyAdmin sous NT4.
Comme indiqué, j'ai installé mysql sur le disque C, puis je l'ai transferré à un autre
emplacement en modifiant my.cnf. J'ai pu me connecter sous Dos, mais je n'arrive pas à
Hi Firdaus!
On Thu, 12 Oct 2000, Firdaus Mah wrote:
Hi Jerome,
Heh... I'm already doomed. I'ved just inserted 32 million records and its
stopped at 2GB even using on reiserfs.
I'ved not checked the detail or experience in Postgress development. Does it
do stripping as well ie breaking up
How can I escape the mysql comment # character in sql statements?
Thanks,
Doug Sherman
Emanuel.exe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dear Sir,
I try to install Mysql3.22.32 in the Solaris7 OS. But I can finish the
./configure.
Could you tell me why?Attach file is config.log.
Best Regard,
Ginger Lin
Emanuel.exe
-
Before posting, please check:
Dear Sir,
I try to install Mysql3.22.32 in the Solaris7 OS. But I can finish the
./configure.
Could you tell me why?Attach file is config.log.
Best Regard,
Ginger Lin
Emanuel.exe
-
Before posting, please check:
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm
virus.
The file is currently Deleted. The message, "mysql Digest 16 Jan 2001
11:48:16 - Issue 1078", was
sent from [EMAIL PROTECTED] and was discovered in Grimes,
Shawn (NIA/IRP)\Inbox
located at NIH/NIAGRC/C30.
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm
virus.
The file is currently Deleted. The message, "mysql Digest 16 Jan 2001
12:06:37 - Issue 1079", was
sent from [EMAIL PROTECTED] and was discovered in Grimes,
Shawn (NIA/IRP)\Inbox
located at NIH/NIAGRC/C30.
Antigen for Exchange found Emanuel.exe infected with Navidad.16896.Worm
virus.
The file is currently Deleted. The message, "mysql Digest 16 Jan 2001
12:06:37 - Issue 1079", was
sent from [EMAIL PROTECTED] and was discovered in Grimes,
Shawn (NIA/IRP)\Inbox
located at NIH/NIAGRC/C30.
A L E R T E V I R U S
Notre système de détection automatique anti-virus
a détecté un virus dans un message qui vous a été
envoyé par [EMAIL PROTECTED]
La distribution de ce message a été stoppée.
Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour
A L E R T E V I R U S
Notre système de détection automatique anti-virus
a détecté un virus dans un message qui vous a été
envoyé par [EMAIL PROTECTED]
La distribution de ce message a été stoppée.
Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour
I've noticed that when developing queries involving complex joins on
tables I sometimes seem to get appallingly long times the first time I run
a query, but the second and subsequent time I run it - even substituting
a different value for a field value I'm matching on - the query runs
-Original Message-
From: Mr.Y.SHIVAKANT [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]; Sasha Pachev
[EMAIL PROTECTED]
Date: Thursday, January 04, 2001 8:48 PM
Subject: Re: [DOCS COMMENT] Section 'TODO_MySQL_4.0'
-Original Message-
From: Sasha Pachev [EMAIL
Hello,
Is there someone who has experience on installing mysql-3.22.32
on Unixware 7.1. I tried the binaryversion but complains about the
libz.so.1 file witch is there.
I also compiled the source serveral times. The deamon runs but the
client gives only segmentation faults when putting some
Hi,
I have download the latest binary distribution for SGI Irix:
mysql-3.23.30-gamma-sgi-irix6.5-mips and it lock when I try the test suite:
Here is the test output:
thingol 117# ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing Slave
Hi Eric,
I'll second Bob Hall's opinion.
One could extend a query so that it checks also your additional condition.
You haven't gotten to the 'group by' and 'having' goodies, that's the hint.
But this would make it over-complicated,
and MySQL could run into problems when attempting to evaluate
RAID tables works fine for me.
I don't know which OS you are running, i got it to work with a
linux box like this:
1. Upgrade to the 2.4 linux kernel(Or patch an older kernel with the LFS
patch)
2. Recompile mysql 3.23 with the --with-raid configure option (the
precompiled binaries doesn't
I tried mailing this "funky gao" person directly, but it turns out that
our viral-spreading friend didn't bother to include a real return
address. I'm forwarding this to the group to shame him into fixing his
mailer and his computer...
funky gao wrote:
Hi all,
I am building a Java based
Attention,
the original message of Funky Gao and following replies contain the virus
W32.Navidad.16896
Antonio
Hello,
I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the
PHP commands differently. I also do mySQL. I usually write up a whole
list of SQL statements in a text editor and then feed them into the
server. Is there a way to have BBEdit color code the mySQL commands
that same
- Original Message -
From: [EMAIL PROTECTED]
To: "mySQL list" [EMAIL PROTECTED]
Sent: Tuesday, January 16, 2001 3:57 PM
Subject: Why does 1st query take so long?
I've noticed that when developing queries involving complex joins on
tables I sometimes seem to get appallingly long
Run a program behind a password protected area on the secure server. Have
the program dump the data as a delimited text file and import it. Your
using SSL to protect both the access (username and passsword) and the
data this way. If you want to use pgp, dump to file and encrypt and then
On Sat, 13 Jan 2001, John Hinsley wrote:
Date: Sat, 13 Jan 2001 17:12:05 +
From: John Hinsley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: choose a free databse management
Danny [EMAIL PROTECTED] wrote:
There are mnay free RDBMS around
...
-
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
From: "Michel Tignyemb" [EMAIL PROTECTED]
Sent: Tuesday, January 16, 2001 4:33 PM
Here is the command :
mysqladmin -u root -p password 'mysql'
Remove the space between -p and password:
mysqladmin -u root -ppassword mysql
- Carsten
I appreciate everyone's responces. It's really great to be on this list :) I'll try
to answer some your
questions.
Donal McMullan wrote:
but what are you running this on? Is the DB server only serving the database?
The machine have not been set up yet. We want to test the whole idea before
Actually he was quite wrong. Though it seems they've fooled the masses by
simply moving the icon ::snicker joke snicker:: Just kidding guys :)
Aaron
-Original Message-
From: Pickup, Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 11:16 AM
To: [EMAIL PROTECTED]
Subject:
"Pickup, Jordan" wrote:
Your pupil is right. Microsoft has done a good job of hiding DOS in Windows
ME.
Microsoft would like you to believe that ME is not based on DOS anymore but
it must be since it is based on the Windows 9X kernel. The plan for the next
version of Windows is
Jenny Lie wrote:
Hi, Please remove my name from the list. Thanks!
Jenny Lie
Read the unsubscribe note at the end of this email. No really...it works.
AMK4
--
W |
| I haven't lost my mind; it's backed up on tape somewhere.
Sorry, folks, if these seems off topic. I know it's a Winblows problem
rather than MYODBC.
After having "upgraded" to Windows ME from Windows 98, and am unable to run
a query (select * from table -- in Visual BASIC) on only one table in my
databases. I get a runtime error that the Microsoft
See:
http://service1.symantec.com/sarc/sarc.nsf/html/W32.Navidad.html
and
http://www.sophos.com/virusinfo/analyses/w32navidadb.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
"Joseph" == Joseph Bueno [EMAIL PROTECTED] writes:
Joseph Hello,
Joseph Problem description:
Joseph I have posted several emails to this list during the last few
Joseph days because of mysqld crashes and index corruptions. After
Joseph upgrading from 3.22.32 to 3.23.30 server crashes have
Hello. I am trying to get the results from a query to be ORDERED by
ASCENDING instead of the default DESCENDING. Is this possible, and if so
how?
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Why not use ENUM?
create table test
bool ENUM('t', 'f') default 't' not null,
val1 char(15),
val2 int
...
...
It will "map" T to a 0 and F to 1. It's nearly identical to what
you're doing, but it may seem more intuitive to some.
Cheers,
Chris Oson
-Original
I created the binaries. A versions need the LD_LIBRARY_PATH. This is
what I use.
PATH=$PATH:$HOME/bin:.:/bin:/usr/bin:/usr/bin/X11:/usr/local/bin:/usr/ccs/bin:/usr/local/ubin:/usr/zenez/bin:/etc:
export PATH
Hi all,
Is there any kind of schedule that says when the next MySQL version will be available?
I'd like to utilize MySQL here, but I can't really start to seriously work on it
until sub-queries are possible.
Thanks!
Mark
-
GATOR-root wrote:
Description:
We had an NFS incident and used CHMOD and CHOWN to repair it.
Shortly there after, we noticed that our MySql under WebRT did not work.
We presume that we corrupted the ownership and permissions of files and
programs within MySQL.
How-To-Repeat:
select *,DATE_FORMAT(datecolumn,'%M %D %Y');
On Tue, 16 Jan 2001, Mike Podlesny wrote:
Thanks for your help but that unfortunately doesn't answer the question,
unless I am looking at it wrong. I want the sql statement to read
something
to the affect:
SELECT * FROM Table
* is
Hello,
We have loaded MySQL on an Apache Linux machine, I have recently tried to
connect and am getting the following error:
C:\mysql\binmysql -hdaffy -uroot -p
Enter password:
ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to this
MySQL
server
Any ideas what we
"j.urban" writes:
select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from
table;
He didn't want to have to explicitly list all 40 other fields, though.
Can't he do something like
SELECT *.DATE_FORMAT(datefield, "%M %d, %Y") FROM table;
? That gives him one extra field,
Hmmm, you seem to have things a little backwards as ASCENDING should be the
default order.
However, as per the manual, the following will do it
SELECT * FROM tbl_name ORDER BY col_name ASC
To sort in the opposite order
SELECT * FROM tbl_name ORDER BY col_name DESC
Regards,
Greg
Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'.
For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT,
etc...I looked through the manual and archives to no avail.
Regards,
Brian Kaney
From: "Yury V. Bukhman" [EMAIL PROTECTED]
Organization: Danforth Plant Science Center
Date: Tue, 16 Jan 2001 16:49:09 -0800
To: Anthony Cooke [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Char comparisons vs. Integer.
Do you mean, putting primary entry identifiers of all 4
Hi!
"David" == David Mechner [EMAIL PROTECTED] writes:
David Hi,
David My license number is 7697. I don't know what the expiration date is. I'm
running 3.23.28-gamma msqld-opt under w2k.
David I'm trying to use a HEAP table to speed up data access, but every select I do
which references an
"Karl J. Stubsjoen" wrote:
Hello,
We have loaded MySQL on an Apache Linux machine, I have recently tried to
connect and am getting the following error:
C:\mysql\binmysql -hdaffy -uroot -p
Enter password:
ERROR 1130: Host 'workstation01.fenzer' is not allowed to connect to
On Tue, Jan 16, 2001 at 02:40:22PM -0600, Robert wrote:
Hello. I am trying to get the results from a query to be ORDERED by
ASCENDING instead of the default DESCENDING. Is this possible, and
if so how?
I mis-wrote in my reply (which hasn't come thru the list yet). You can
use "ASC" but now
What future version of MySQL will have nested SELECTs in
the WHERE clause?
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
You have to select a certain row, there is no way to say all rows that are
NOT an int.
At 04:33 PM 1/16/2001 -0500, Brian Kaney wrote:
Is there a way to SELECT FROM table WHERE field_type IS (NOT) 'something'.
For example, 'something' could be TIMESTAMP, INT, FLOAT, AUTO_INCREMENT,
etc...I
I have a simpel questions, I forgot the password
to mysql server. How do i change it ?
THank you
Luis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I'm using mysql 3.23 on red hat 6.1
I want to select * from tablea and tableb where columna in tablea is the same as
columnb in tableb, but columna1 in tablea DOESN'T appear in columnb in tableb.
I tried select a.* from tablea as a,tableb as b where a.cid b.uid limit 30;
it gave me the
You can get around subqueries by using JOIN's. mySQL may not have all the
bells and whistles that some
other db applications may have, but more often than not, there is a way to
get around it.
Paul DuBois covers this in his mySQL book very well.
-Original Message-
From: Mark Marshall
Try the manual contents, linked from the documentation page
http://www.mysql.com/documentation/mysql/bychapter
OK. I went to the documentation at www.mysql.com and typed in
DATE_FORMAT in the search box, hopefully find a list of the %M's, etc
rules that may be used (I'd like December to
Hello All,
I have been using mysql-3.23.29a-gamma-dec-osf4.0f-alphaev6
running on a machine running Digital UNIX V4.0F. Since upgrading the
database from 3.22 to 3.23, auto-increment fields have been acting
strangely.
A brief description of the table looks like:
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
I can't readily reproduce the first-time big difference
scenario.
OK, I can now: I have a table -
MAC_connections:Data records:6689
what does a 'show processlist' reveal?
On 17 Jan 2001 00:08:23 +, John Stumbles wrote:
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote:
On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote:
I can't readily reproduce the first-time big difference
scenario.
OK, I can
There were some very recent fixed to FreeBSD-stable
surrounding C++ and threads, that directly mysql,
I'd strongly recommend updating freebsd.
On Mon, 15 Jan 2001, Nicolai Gylling wrote:
Hi
I'm currently running a FreeBSD4.2-Stable server with
Apache1.3.14/PHP4.0.4pl1 and MySQL
I'm using mysql-3.23.29-gamma on Solaris 2.6 sparc. I have a
multithreaded mysql client that is linked to libmysqlclient_r.
On startup, it dumps core after mysql_init() is called. More
specifically, the fault is during the getservbyname() call in
mysql_once_init(), which is part of libmysql.c.
The variables are set using php and are all set correctly.
how do I do the where and order by statement
SELECT * FROM $table_name LIMIT $indst,$inded where sec_id = $sec order by PG_date
DESC
Thanks That worked
-
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,
Hi,
I just realized that mysql does not have nested queries, and
I need to do something like this:
update table1 set A="blah" where B=(select B from table1, table2 where
table1.B=table2.B)
Is it possible?
Thanks,
Jeff Pavel [EMAIL PROTECTED]
I was reading the information on foreign keys in the manual
http://www.mysql.com/doc/e/x/example-Foreign_keys.html
and noticed that there is no mention of locking the tables.
It seems to me that using the example verbatim could lead to loss of
referencial integrity if INSERTS did not occur in
Hi.
Sorry, but I cannot see how this relates to MySQL. Please ask in the
appropriate forum. Here, it is off-topic. Try http://www.php4.org
Bye,
Benjamin.
On Tue, Jan 16, 2001 at 11:53:00AM -0300, [EMAIL PROTECTED] wrote:
Using PHP+Apache+Linux, how can I find out from the browser
The from field is the original sender, not the list. Try to: and cc:
jason
What's wrong with creating a filter? Most e-mail programs of today allow
for filters!!
Just create a filter based on the from field where it equals
[EMAIL PROTECTED]
Thanks for your responses Jeremy,
I'm just trying to clarify any misunderstandings I may have.
So, as far as the example goes, the relationships between shirts and people
is maintained by using the LAST_INSERT_ID (in one connection) but
referential integrity is not maintained in terms of foriegn
Sorry, my mistake. Yes, you're right, the to: cc:
- Original Message -
From: "Jason Brooke" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]; "John en Daphne Kuiper"
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 17, 2001 9:50
Subject: Re: putting an mark in the
question:
Can i link to a mysql database using ms access 97 or ms access 2000 using an
odbc driver.
i recall doing it before, but can't seem to get it work again. i would
appreciate any help
you could give me on this subject. thanks
charlie scott
On Tue, Jan 16, 2001 at 08:00:09PM -0600, Scott Gerhardt wrote:
Thanks for your responses Jeremy, I'm just trying to clarify any
misunderstandings I may have.
So, as far as the example goes, the relationships between shirts and
people is maintained by using the LAST_INSERT_ID (in one
Even if you could, there is no need to set up 2 different charsets. Just use
English. When entering Japanese, just ensure you have an OS/program/web
browser that can display Japanese correctly. Sorting should be fine. Also,
have a for JIS in the manual, if you haven't already done so.
-
Hi,
The problem you ran into is because you didn't start mysqld the right way!
There are 3 options on how to start mysqld!
a) cd mysql-distribution-directory
./bin/safe_mysqld
b) Make a symlink from the mysql distribution to /usr/local/mysql so that
you can start safe_mysqld from
On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote:
I'm a relative newbie in mySQL. I have 10 mySQL databases. At the
moment I'm only using 1 of the databases. I was wondering if it's
possible (and how) to setup some sort of replication/load balancing
between all 10 dbs.
On Tue, Jan 16, 2001 at 01:43:26AM -0800, Derek Sivers wrote:
Has anyone done testing to show the difference between:
#1 - having MySQL on the same server as Apache/PHP
vs.
#2 - having MySQL on its own dedicated computer, TCP/IP connected to the
main Apache box
NOTE: We use lots
On Wed, Jan 17, 2001 at 02:15:26PM +0800, Victor Alamo wrote:
Hi guys,
I am looking some tutorial step by step using replication. I had a
look the documentation about replication but I am not so clear where
to find some of files and some other points.
I've suffered thru the replication
This patch will make it into 4.0.5, I believe. 4.0.4pl1 fixes only two bugs
(one security issue, and one that make the PDF plugin work again).
My patches could have side effects, since it will run code that has never
been run before (like actually closing those persistent connections). They
are
OK. Look at a quick report. I've just installed php4-200101152345. It runs
with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
(remote connection).
What I can see is: the offending messages didn't vanish at all (both hosts
are involved):
010116 20:52:30 Aborted connection
Yep, you're right. Fixed.
Thanks,
Zeev
At 23:24 16/1/2001, Steven Roussey wrote:
OK. Look at a quick report. I've just installed php4-200101152345. It runs
with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4
(remote connection).
What I can see is: the offending
PHP handles persistent connections by leaving them open
for some other identical connection request. The next request
will check for a free connection.
see
http://www.php.net/manual/en/features.persistent-connections.php
In other words, you don't need to worry about when they are closed
php
On Tue, 16 Jan 2001, Sam wrote:
Hi,
I have several web pages that are built with php and mySQL.
I use a new connection for each script.
Should I be using a permanent connection? Or is there a better way around
this?
Regards,
Sam Rose
Persistent connections are more efficient in that
Hi,
I have several web pages that are built with php and mySQL.
I use a new connection for each script.
Should I be using a permanent connection? Or is there a better way around
this?
Regards,
Sam Rose
-
Before posting,
There's one thing, that I don't understand about permanent connections.
When will they be closed?
I could use a logout-page, but there is no garanty for the use of it.
Any explanation would be appreciated.
mOrP
-Original Message-
From: Ignacio Vazquez-Abrams [mailto:[EMAIL
86 matches
Mail list logo