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 database
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, and
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 ;-))) somewhere
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 I
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 MySQL
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
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, 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
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
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 -1) and
One way is to include it in your mysql start command:
mysql -u user -ppassword scriptfilename
You may have to include the path with the scriptfilename.
regards,
det
On Sat, 23 Feb 2002 13:21:27 +0530, Chetan Lavti wrote:
hi,
I have written a script for database creation and table creation.
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, since 7.2
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
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 WHERE FIELD1= mpla-mpla%
Also binary at field creation or WHERE should be ON by default. And WHERE
works erroneously with Greek chars (without the binary
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
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
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]
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
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.mdb);
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
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
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
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
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
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
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 binding
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 on where
[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
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. Perhaps
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
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
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
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
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
for example
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=xxxpassword=yyy );
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 take
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:
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.
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 not
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
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(
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
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
there.
Sir,
43 matches
Mail list logo