On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
you are correct - subselects are NOT allowed until version 4
4.1 as opposed to 4.0.x.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51:
It depends on what kind of comparing you will be doing. Text is
case-Insensitive for comparisons, blob is case-Sensitive.
Generally I find that for pure text, TEXT type is better. For files and
texts that need to be compared case-sensitively, use BLOB.
Either way, for images, and any other
Hi all,
Pure randomly my server tells me the its
Lost connection to MySQL server during query at ...
This all happened after my upgrade to version 3.23.54. I searched google
and read some threads here.
A possible solution is to DOWNGRADE some libc files? Tell me is this the
only solution ?
This old bug reappeared after the upgrading mysql from version 3.23.54a
(rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by
mysql.com as well).
Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this problem)
This server has glibc 2.2.4-31 installed for quite a while,
Lynn David Newton wrote:
It's the first KEY definition it doesn't like. If I
comment out KEY field(field), it works, except of
course then the field called 'field' is not set as an
index. The same exact problem occurs in two places in
the mysqldump file. With them commented out the DB
reloads.
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
you are correct - subselects are NOT allowed until version 4
Subselects will be available in version 4.1
--
Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications
it looks as though you have created the newsletter user with plain text password.
mysql will compare the user password against the encrypted password and will fail.
you can do this:
mysql set password for newsletter@localhost=PASSWORD(testPass);
or
mysql update user Set
Hello.
Please start a new thread instead of replying to an existing one. Or
else, your message will be sorted with the original thread for people
with decent mail readers.
On Wed 2003-01-15 at 14:42:05 -0500, [EMAIL PROTECTED] wrote:
How do you query the table that is the results of a query?
please look at page 194 of the reference manual...
(and if so how do you ask MySQL to create a temp table from the
results of aquery?)
here's an example:
mysql create temporary table tmp (name varchar(20), owner varchar(20, species
varchar(10));
mysql insert into tmp select name, owner,
On Wed, Jan 15, 2003 at 03:47:33PM -0500, Will Standley wrote:
Will PhpMyAdmin do more than simply create a MySQL db ?
Please cc me directly on any post at [EMAIL PROTECTED]
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
I use ext3 and have a qps of anywhere from 2800-8000 and use the
defaults with no problems. Have you tried:
iostat -k 1
to look at your disk access? What kind of disks are they anyhow? IDE or
SCSI? RAIDed? In what fashion?
Lastly, you said that this is a script that is running, right? The
This is my first time installing MySQL.
I'm attempting to install MySQL on my Apple PowerBook G4 OSX 10.2.
After downloading and unpacking mysql-3.23.53.tar.gz, my attempt to
run ./configure failed.
I'm including content from config.log, any help you might have would be
appreciated.
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a
On Tue, Jan 14, 2003 at 01:22:32PM +0100, harm wrote:
Hello,
Because I switched some large tables back to myisam from innodb (sorry
Heikki) my innodb datafile has a few gig 'empty'. I would like to reclaim
that space.
Can I expect a problem if I:
- make _all_ innodb tables myisam (And
I am trying to install MySQL 4.0.9 from source on AIX 5.1. I used gcc 3.2.1
as compiler. Here is my configurations:
CC=gcc CFLAGS=-O2 -mcpu=powerpc -Wa,-many
CXX=gcc CXXFLAGS=-O2 -mcpu=powerpc -Wa,-many -felide-constructors
-fno-exceptions -fno-rtti
./configure
Hi Steven,
Shame on me, but I have no idea what the output of iostat tells me -- though
I know I should. Can you point me to a good reference to flesh out the man
page?
I have 2 18GB Seagate drives -- from dmesg:
Vendor: SEAGATE Model: ST318406LC
(scsi0:A:0): 160.000MB/s transfers (80.000MHz
For reasons too boring to warrant going into here, I have
a slave server which is synchronised with the master up to the
very start of binary log 007, but I have no valid master.info
file.
I don't want to stop the master if at all possible. All I want to
do is to re-create a suitable master.info
If I understand you correctly you like to have the result for the specific table in
your mail to look like this:
200 -- this is the total price of item1 (1 * 200)
150 -- this is the total prices of partAs (2 * 75)
300 -- this is the total price of partBs (2 * 150)
for this you are better off
Hi all,
I'm encountering some problems with code on a PHP/MySQL driven site. It's a
long story to document, but the end result is that I have to look at my
entire code library looking for problems :)
One area that I'm seeking further knowledge about is how MySQL behaves under
load. I have a
I'm trying to determine the more efficient syntax between a left join and
this other thing, maybe its a cross join or just a join. I used explain and
the left join has more NULL Keys but seemingly less rows to look at. Are
the multiplied number of rows pretty much the word on efficiency. They both
Where does mysql places the databases in 4.0.9 when installing from source?
The var directory does not seem to be there anymore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello,
I found more following messages in my mysql log:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning
Keith,
There's a formula to calculate the row length for dynamic MyISAM
tables here:
http://www.mysql.com/doc/en/Dynamic_format.html
Thanks for the hint, but this doesn't explain fixed length row
calculations where char(10) will give an average row length of 11
(bytes), or does it?
Except with stunnel (often recommended) or SSH (which I've had running
for months doing this). PS, as with the MySQL daemon, I run my ssh
tunnel under 'supervise' so as to make sure its always there and
restarts if it gets killed / dies / is stupid / upgraded.
Right. I should have
Russell,
Sounds like you don't have developer tools installed. You need the developer
tools to build mysql on OSX. Though I think you can get hold of a pre-built
distro as well - try versiontracker to find the link.
Peter
This is my first time installing MySQL.
I'm attempting to install
hello,
SELECT DISTINCT price FROM sys_bld_foo WHERE catNum IN
('item1', 'partA', 'partB', 'partB');
problem --|--|
partB is duplicated in the IN list. i need IN to find a DISTINCT price for EACH
element in the list.
Gerald's solution i think gives me the same incorrect sum
What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master
and then starting the slave without a master.info file? I think that will
recreate it for you -- but you should research this before trying...
--jeff
- Original Message -
From: James Fidell [EMAIL PROTECTED]
To:
you can do this:
mysql set password for newsletter@localhost=PASSWORD(testPass);
or
mysql update user Set Password=Password(testPass)
- where user=newsletter;
Don't forget the flush privileges thing after the update command.
__
/ \\ @ ____@ Adolfo Bello
My feeling is that MySQL shouldn't allow reserved words / characters
like this, whether they are in quotes or not.
...
Does anyone know the logic behind allowing reserved words when inside
quotes like this? It clearly causes problems - especially for people
using GUIs - and these people will be
You can use --skip-name-resolve when starting mysqld, but this is not a real
solution.
Even doing that,'I'm still having some odd problems I never had before, like
table corruption (I'm on 4.0.8 though)
- Original Message -
From: Patrick de Kievit [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi Russell,
You donĀ¹t have a suitable compiler installed.
For everything you need to know regarding installing MySQL on OS X go to
http://www.entropy.ch/software/macosx/mysql/
Here you will find preconfigured mysql installs for OS X, plus step by step
instruction on how to get it up and
hello,
how can i view privileges for a table in a db? thank you, addison
sql,query,queries,smallint
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
hi all,
i get the following error logdid anyone try to compile mysql with ssl before?
030116 14:34:13 InnoDB: Started
/usr/local/mysql-4.0.9-gamma/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of
On Thu, 16 Jan 2003 [EMAIL PROTECTED] wrote:
sql,query,queries,smallint
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consultant
Director, Software Development
Escapade Server-Side Scripting Engine
hi,
I upgraded from the gcc-2.96 because of warnings in the notes about possible bugs, so
I got the newest redhat gcc package which is gcc-3.2.1-1.i386.rpm. I also upgraded to
glibc-{devel common utils}-2.3.1-6 and am trying to compile the new mysql-4.0.9-gamma
and am running into problems
101 - 135 of 135 matches
Mail list logo