Hi,
Using mysql 4.0.2 I get the following behaviour (phrase searching):
match (field) against ('"pack of"' in boolean mode)
gives me all results with 'pack of', not just 'pack'. So MySQL isn't
ignoring 'of' even though the word is too short to normally be considered.
However if I use: matc
Hello All,
I am using mysql on Linux - RedHat 7.1.
The basic stuff is simple, cool, too.
I am a newbie, so forgive me if this is too simple a question.
Is there a mechanism available somewhere in doing an "automated" update of a
field.
example.
team is a table.
wins, losses, pct are fields
Lamar,
Why store that information? You'll be constantly updating your table. I do
something similar keeping softball stats for my team. I just keep the raw
data and do all calculations, i.e. batting average, slg pct, winning pct,
obp pct, etc. in the queries that generate the web pages or repor
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Seifuddin, Lamar T.* (LSEIFUDD) wrote:
| Hello All,
|
| I am using mysql on Linux - RedHat 7.1.
| The basic stuff is simple, cool, too.
|
| I am a newbie, so forgive me if this is too simple a question.
|
| Is there a mechanism available somewhere in
It looks like the booksellers are starting to creating listings
for this book, so I've added links to them on the web site that I
maintain as the book's online presence. The site is available
here:
http://www.kitebird.com/mysql-cookbook/
-
Mike,Mark,
Thanks for responding to my post.
I understand now about "triggers".
I can see doing the calculations in the queries. That makes sense.
thanks,
-Original Message-
From: Michael Fanara [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 08, 2002 3:29 PM
To: Seifuddin, Lam
As regards the HP part of your question:
The 'hppa1' part of the package name is a reference to the processor
architecture. PA2 machines will run PA1 code unchanged (in theory); the
reverse is not true. HPUX 10.20 is a 32-bit release. Although you can
install a 32-bit version of HPUX 11, most
In the last episode (Aug 08), Christopher Book said:
> Using mysql 4.0.2 I get the following behaviour (phrase searching):
>
> match (field) against ('"pack of"' in boolean mode)
>
> gives me all results with 'pack of', not just 'pack'. So MySQL isn't
> ignoring 'of' even though the word is
Yesterday, I increased the memory in my mysql server from
2 GByte to 4 GByte.
Here the log file as it died:
Number of processes running now: 1
mysqld process hanging, pid 1015 - killed
020808 09:40:12 mysqld restarted
020808 9:40:12 Can't start server: Bind on TCP/IP port: Address alre
If it is saying that it cannot bind to port 3306, then maybe the port is
still locked by another process, mysqld or otherwise.
netstat -na | grep 3306 should show you that. Kill that process and try
again.
Regards,
Bhavin.
- Original Message -
From: "Johannes Ullrich" <[EMAIL PROTECTED]>
If you have 'root' privileges to the server itself, then shutdown mysql and
restart it with --skip-grant-tables. This should allow you to log in as root
without being prompted for a password.
Regards,
Bhavin.
- Original Message -
From: "Norris, Joseph" <[EMAIL PROTECTED]>
To: "'Kevin Be
Yes, LOCAL is when client and server are on different boxes and the file is
LOCAL to the client. You don't need that keyword otherwise.
Regards,
Bhavin.
- Original Message -
From: "David Sammons" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 08, 2002 10:20 AM
Subject:
>Description:
When creating a database with mysqladmin create -p
the system responds with "can't create database, error number 28"
>How-To-Repeat:
>Fix:
I've done mysql_install_db,
changed ownership and group of the /usr/local/mysql and /usr/local/mysql/var to
recommended value
Actually, in my redhat 7.1 distribution, it has only
mysql-VERSION.rpm, mysql-server-VERSION.rpm and
mysql-devel-VERSION.rpm only, it's missing it's client rpm.
I checked with my previous 7.0 cd set, it's missing the
client too. So is it possible to install without client.
Now i'm tring it wit
Yes, don't lock the table. MySQL will handle the lock for you on the
insert. this isn't access. its a multi-user system. with access you
have to lock the table.
Curtis
On Tue, 6 Aug 2002, Pradeep Dsouza wrote:
> Dear list
>
> I have written a large application which i call Edupro whi
> What the hell is error 28? Where can I find description?
> mysqlcheck --all-databases # says everything is ok
mysql does come with a little utiltiy, perror, which can be
used to translate error numbers into readable messages:
$ perror 28
Error code 28: No space left on device
Did you check
At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT.
The command returns the following error message:
Failed to open file [FileName] Error 2.
So what is this error 2. What does it mean?
Your help will be appreciated.
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> deep,
> Thursday, August 08, 2002, 4:08:22 PM, you wrote:
>
> dk> It looks like a simple bug but I have spent lots
> of
> dk> hours try to solved it but not success yet.
>
> dk> Application: Visual Basic 6.0
> dk> Database used: MySQL 4.0.1 & MySQL 4.
Hi,
What will happen on Error code 28: No space left on device? Will mysql
crash down?... Will there be posibility of reading data from tables?
Best Regards,
--
Jarek
-
Before posting, please check:
http://www.mysql.com
Hi,
I am using mysql 4.0.0-aplha on win 2000 professional.
I install mysql in c:\mysql.
I write a script ( customerscript.txt) and i save this script in
c:\mysql\bin.
The contents of customerscript.txt I will paste at the bottom of this mail.
Then,I run my script at the command prompt.
C:\mysql\b
20 matches
Mail list logo
