On Sat, Feb 23, 2002 at 07:28:04PM +0200, savaidis wrote:
> Instead of "binary" it sould be better to use a "case conversion" flag with
> reverse function - NOT set by default. "Binary" doesn't make sence to me.
> As for LIKE I think most WHERE commands use it so it is obvious it should be
> ther
Hi,
I seem to be getting intermittant crashes of mysql. The error log prints
the following,
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 against is corrupt, improperly built,
or misconfigured. This error
Nicole,
RTFM: 6.3 Functions for Use in SELECT and WHERE Clauses
in particular the String Functions
If the first space (in every row) can be taken as the 'marker' of what to remove
(including the space itself),
then take a look at the following:
SELECT catval, RIGHT( strcatdescr, POSITION( '
I've now tracked down the problem with signal 4 - glibc was configured for
i686 architecture. I have now fixed this and am currently building the
binaries.
As I said earlier, if you would like to volunteer for a pre-release test,
send me a mail.
--
MySQL Development Team
For technical suppo
If I rember well MySQLdump is a utility. I can run that at my local machine,
but how to do the reverse thing at the remote machine. I can't run much more
than HTML and PHP scripts there. Is there a tool that can convert the
MySQLdump export file into something that looks like a PHP script and t
On Fri, Feb 22, 2002 at 12:10:52AM -0700, [EMAIL PROTECTED] wrote:
> Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest
> 4-STABLE. Updated ports tree and did a make install in
> /usr/ports/databases/mysql323-server and received the following on the
> mysql_install_db part:
I have
I've got this problem that now since I updated mysql to ver 3.23.49 and recompiled
some of my working cgi scripts Apache is complaining about a server error. Premature
end of header scripts. If I use the cgi that I compiled before the upgrade everything
is fine. It's the exact same code.
I've
Sorry Dan, I had actually replied to Steve who had asked the same
question but I forgot to reply to the list with this:
here is the query:
select catval,catdescr from embiteccat
where catzid=$zid and catlid=$lid and catunder=$cat order by
catdescr;
Here is a some data:
36,1,1,,0,0,2
Hi Nicole,
Perhaps it's me, but I'm having trouble following you - as I did with the question
I've just finished responding
to...
> I have looked at the online documentation and the mysql books that I
> have but can find no answer. I have a field that looks like this:
>
> (8+2) Landscape
I tak
I am using mysql 4.0 on linux and mm.mysql 2.0.11, however I can't access
mysql from java application.
try {
Class.forName( "org.gjt.mm.mysql.Driver" ).newInstance();
Connection connection = DriverManager.getConnection
("jdbc:mysql://localhost/test?user=xxx&password=yyy" )
Hi Pinkesh,
> I've got item table as follwoing:
>
> itemno|item_name
> 1 item one
> 2 item two
> 3 item three
> 4 item four
> 2 item two
> 3 item three
>
>
> I want to right a query so I get three rows of each item I specify in WHERE
>
> f
At 19:54 +0200 2/23/02, savaidis wrote:
>I say "by default" means to do nothing, not to do the upercase conversion as
>I suppose it does to the fields.
As it happens, the standard SQL behavior for LIKE is to not be case
sensitive. Which is roughly equivalent to doing an uppercase conversion.
You
Um, hello?
I wasn't trying to turn this into a general bitch session
on the manual, and I really don't think that's appropriate.
Worse, it obscures and devalues the value of the bug report.
I'm just trying to draw attention to a possible software
malfunction in the "commentary" section of the o
I say "by default" means to do nothing, not to do the upercase conversion as
I suppose it does to the fields.
I haven't met since now the "binary" as an alternative to "case sensitive"
and I'm quite old in programming and age believe me :)
Also if I knew SQL already, then I didn't have to read the
I'm using still a very small MySQL database -just testing yet- but I read
many people talking about some Gigas of data. I wonder where can I find some
benchmarks about MySQL with various O.S.
I work with MySQLFront and:
Is there a way not to loose data when I change a field i.e from INT to
FLOAT
At 19:28 +0200 2/23/02, savaidis wrote:
>Instead of "binary" it sould be better to use a "case conversion" flag with
>reverse function - NOT set by default.
You have to have *something* on by default. I guess I don't understand
what you're getting at. I'd say BINARY is reasonably concise. Perh
[I didn't get a response from openbsd-sparc, so I'm trying here. Any help
would be appreciated!]
I'm trying to get a MySQL server running under a recent OpenBSD 3.0 snapshot
on an Ultra 5, but I'm not having much luck.
I tried installing the binary mysql-server package (from
3.0/packages/sparc6
Hi,
> -Original Message-
> From: Brian Reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 23, 2002 9:52 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC 3.51 build for Mac OSX
>
>
> Sorry, Im new here and Im sure this has been discussed ad naseum, but
> does anyone have information
Hi,
> -Original Message-
> From: D Nyberg [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 23, 2002 9:30 AM
> To: [EMAIL PROTECTED]
> Subject: Naming a Provider?
>
>
> Guys, I'm very new to ODBC, so please bear with, okay?
>
> I'm looking at example code in a particular windows
Hi,
I've got item table as follwoing:
itemno|item_name
1 item one
2 item two
3 item three
4 item four
2 item two
3 item three
I want to right a query so I get three rows of each item I specify in WHERE
for example
SELECT itemname from i
Instead of "binary" it sould be better to use a "case conversion" flag with
reverse function - NOT set by default. "Binary" doesn't make sence to me.
As for LIKE I think most WHERE commands use it so it is obvious it should be
there.
Makis
> -Original Message-
> From: Paul DuBois [mai
A humble suggestion for the development team
I went through and looked at some of the postings regarding using ALTER
TABLE with InnoDB tables and the resulting loss of foreign key constrains. I
was disappointed to learn about the need to use the create/drop workaround.
The main reason I con
Simon and others:
Signal 4 means "illegal instruction". This happens when the binary users an
instruction that is not compatible with your architecture. In theory, this
should not happen - to our knowledge, the binary should work just fine on any
architecture. However, if it does not, this mea
Sorry, Im new here and Im sure this has been discussed ad naseum, but
does anyone have information on where to get an installer for the Mac
OSX version of the MyODBC drivers? The latest build I could find on the
web is 2.5.
(mySQL, sql, query, etc.)
TIA
Brian
-
This matter was addressed this morning by Sasha Pachev in "3.23.49 Linux binary issues"
To paraphrase Yogi Berra, you can learn an awful lot just by reading; in this case
postings to the list in general
from the development team.
det
On Sat, 23 Feb 2002 08:22:15 -0500, S. William Schulz wrot
Guys, I'm very new to ODBC, so please bear with, okay?
I'm looking at example code in a particular windows binding package, and
see the following:
...
-- Open Database
Open (DB_Control.Database,
"Provider=Microsoft.Jet.OLEDB.4.0; " &
"Data Source=..\..\tutorials\adotest.md
Hi,
I have looked at the online documentation and the mysql books that I
have but can find no answer. I have a field that looks like this:
(8+2) Landscape
I want to sort on the alphabetic characters. My mysql query does an
order by this field and that returns a numeric order (which for me i
I don't think the manual is very amateur like. I find it very large,
somewhat imformative. I find it like hell to understand if you are a
novice
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 23, 2002 10:29 AM
To: savaidis; [EMAIL PROTECTED]
Su
At 16:01 +0200 2/23/02, savaidis wrote:
>Also there is not LIKE at all at SELECT command on MySQL manual!
http://www.mysql.com/doc/S/t/String_comparison_functions.html
http://www.mysql.com/doc/P/a/Pattern_matching.html
>I found manual very-very amateur work.
>I was trying about half hour to use
hi everyone,
I've got a mysql server, a quad xeon 700MHz, with 8 gigs of ram, and a
raid 50 disk array running as two 50 GB partitions, shared over 8 15,000
RPM disks, on a hardware raid card, with 128Mb Cache.
Running RedHat Linux 7.2, with Ext3 FS, and Kernel 2.4.9-21 Enterprise
(SMP)
I'm try
Also there is not LIKE at all at SELECT command on MySQL manual!
I found manual very-very amateur work.
I was trying about half hour to use
Also "binary" at field creation or WHERE should be ON by default. And WHERE
works erroneously with Greek chars (without the "binary" option). I think it
is
Has anyone noticed that the comments in the Mysql on-line docs
are almost entirely always off-topic?
Compare, for example, to the PHP docs www.php.net
What's strange is not the number of moronic posts (minimal), but
the number of useful and often insightful posts that appear
to have been entered
On Sat, Feb 23, 2002 at 01:32:11PM +1300, [EMAIL PROTECTED] wrote:
> Hi all,
>
> The latest rpms for mysql 3.23.49 produce a signal 4 error when
> attempting to run the installed mysql server.
> on all our servers running redhat 7 thru 7.2.
>
> Obviously this can't be a kernel 2.2.x issue, sinc
One way is to include it in your mysql start command:
mysql -u user -ppassword hi,
>I have written a script for database creation and table creation. Now I
>want to run this script from the MySQL prompt. How can I do this..?
>Please , anybody know about this , so that I can create my database by
Paul Eggert writes:
> >Description:
> The new POSIX standard is now official (IEEE Std 1003.1-2001),
> and it has removed support for some obsolete utility options
> that mysql uses in a few places. Basically, the new POSIX
> has removed digit-string options (e.g., "tail -
Hello every one...
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
back_log = 20 DEFAULT
back_log = 200 CHANGED
flush_time = 1800 sec DEFAULT
flush_time = 3600 sec CHANGED
key_buffe
George,
Saturday, February 23, 2002, 12:58:11 PM, you wrote:
GL> I created them according to the INSTALL-BINARY file included in the package
GL> downloadable from www.mysql.com
GL> I qoute this from the file:
GL>
//
Hi Egor,
I created them according to the INSTALL-BINARY file included in the package
downloadable from www.mysql.com
I qoute this from the file:
//
"1. Pick the directory under which you want to unpack the
George,
Saturday, February 23, 2002, 1:07:38 AM, you wrote:
GL> Yip somebody pointed me towards the address from the returned mail ;-p. Now
GL> for the answers to your questions:
GL> 1. I did create a user and a group for mysql by using:
GL> shell> chown -R root /usr/local/mysql
GL>
Konstantin,
Saturday, February 23, 2002, 11:49:35 AM, you wrote:
KY> Hello!
KY> Is there a way to find out bad query?
You can read info about EXPLAIN statement (give you info about each
table used in SELECT statement):
http://www.mysql.com/doc/E/X/EXPLAIN.html
Please, read about how MySQ
Chris,
Friday, February 22, 2002, 5:40:18 PM, you wrote:
CG> Thank you for your very detailed reply. This was my understanding of it too.
CG> I guess I was hoping that I had missed something!
CG> Do you know when will this happen? (I hate to ask but since I know I will be
CG> asked this, I feel
Marek,
Friday, February 22, 2002, 7:11:06 PM, you wrote:
MW> Hello all.
MW> I'm using Debian 2.4.x
MW> I was trying to upgrade mysql.3.22 to 23 by removing default packages and
MW> after debianizeing rpm's with alien I installed them with dpkg.
MW> After I did upgrade (as I assume ;-))) somewh
Marco,
Saturday, February 23, 2002, 3:59:20 AM, you wrote:
MB> Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a
MB> remote hosting server, and I have only limited access to the database at
MB> that server. I want to populate my database off-line at my home machine, a
Douglass,
Saturday, February 23, 2002, 9:02:05 AM, you wrote:
DP> I am brand new to MySQL, and trying to get up to speed as fast as possible.
DP> I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
DP> using VB6 and ADO in combination with MyODBC to connect to a databas
Hello!
Is there a way to find out bad query? Also a way for
verifing tables?
Tnank you
__
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
--
45 matches
Mail list logo
