I have run this command without Stating IN BOOLEAN MODE and my search goes
fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE
OPTION IS ADDED , can anyone help ?
Table is MyISAM type running on Linux 8.0
SELECT isbn, title, suggestedretail FROM bookscatalogue WHERE MATCH
(isb
I am trying to develop a web based database application to manage a Scout
group. I need to control the level of access different visitors to the site
are allowed to different parts of the database. I need to provide public
information, including some contact details from the database, to
unauthen
Hi Nestor,
Sorry I didn't mean to be rude actually. Its saturday morning here in Tokyo
so I guess the Beer is a bit to early for me. But I come back to the idea
later during the day ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 13:22、Nestor Florez さんは書きました:
> Nils,
>
> Why don
Sorry Nils sent in hast.
(B
(B-Original Message-
(BFrom: Mike [mailto:[EMAIL PROTECTED]
(BSent: Friday, July 11, 2003 9:08 PM
(BTo: 'Nils Valentin'
(BSubject: RE: What's up with this GATOR crap? - HOWTO Clean it out
(B
(BI think the answers given are valid but I did not see anyone
I must have received via email somehow from someone. I get a lot of jokes from my
Colombian newsgroup.
I do not have any of those tools Kazaa or whatever.
I only use my machines for email and AMP and LAMP copding.
The last thing I installed on my laptop was mozilla the latest release.
I am
Nils,
Why don't you chill dude. Go have an Ice cream or a beer.
If you look at my email again, I said
"Could it be that one of these emails had it in it?"
I WAS JUST ASKING. That is permited, isn't it?
And on top of that Nils, let me tell you that I never said anything about downloading
M
Hi Bruce,
Thank you for the reply.
Just for the record the options order must be
SELECT schedule_id,count(schedule_id)
FROM attendance
GROUP BY schedule_id
HAVING count(schedule_id) <10;
(swapped GROUP BY and HAVING)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 10:20、Bruce Fe
Hi Bruce;
Thank you for the reply.
I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Thank you very much for the reply.
Best regards
Nils Valentin
2003年 7月 12日 土曜日 10:20、Bruce Feist さんは書きました:
> Nils Valentin wrote:
> >I would like to list all courses with have less t
2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました:
> Hi Bruce;
>
> Thank you for the reply.
>
> I passed the core exam but obviously its not enough ;-) Live and learn ;-)
Aeeh thats was supposed to be ... life and learn..
Perhaps somebody knows a good spellchecker for logical mistakes ?? ;-)
That woul
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:06、Nicholas Elliott さんは書きました:
> Hey all,
>
> I've been experimenting with the best way to store a large (~100GB) of data
> for retrieval. Essentially, I'
Hi Carmine,
Whats the physical size of the .MYI file and which OS version ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:23、Carmine Smedira さんは書きました:
> We have loaded a very large dataset and received an error message stating
> that the key file is full. How do you go about in
2003年 7月 12日 土曜日 01:30、Roy Walker さんは書きました:
> Eva,
>
> Thanx for your help. Still having an issue with this. I forgot to mention
> I am running MySQL 4.0.13. Tried both of these statements:
>
> INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count,
> (count - (SELECT count FROM
Hi Nestor,
excuse me for my words, but what you write is crap. MySQL does definitely NOT
include any software like Gator etc.
If Gator is on your PC than a person who is using your PC has knowingly or not
installed it. Gator comes very often with some "free software", but certainly
not with My
Aahhh Neil,
if you don't specify any table format than MySQL will automatically create the
table in MyISAM format.
Does that answer your question ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 06:41、Neil Zanella さんは書きました:
> Hello,
>
> Is there a way to specify MyISAM for all table
On Friday, July 11, 2003, at 05:26 PM, Nestor Florez wrote:
After reading about gator via this email I ran ad-aware on my laptop
and it found gator.
Could it be that one of these emails had it in it?
I got it when my son installed Kazaa. It seems Kazaa makes all their
money by selling piggy-b
Hi John,
Thank you for the reponse. I tried that (I didnt post it here), but that gives
me the error
mysql> SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct<10
GROUP BY schedule_id ;
ERROR 1054: Unknown column 'ct' in 'where clause'
Best regards
Nils Valentin
Tokyo/Japan
Nils Valentin wrote:
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
count(schedule_id)
Hi Brian,
thats fine. You can always convert between the different table formats. As
long as you know some rules there will be no data loss.
As mentioned at the present only innodb support foreign keys. That means that
converting a innodb table f.e to another table format should either give yo
On Fri, 2003-07-11 at 13:41, Nils Valentin wrote:
> Hi MySQL Fans ;-)
>
> I would like to list all courses with have less than lets say 10 participants.
> Does anybody know how I would have to modify the code below to get this to
> work ?
>
> schedule_id is the course itself
>
>
> SELECT sche
Hi MySQL Fans ;-)
I would like to list all courses with have less than lets say 10 participants.
Does anybody know how I would have to modify the code below to get this to
work ?
schedule_id is the course itself
SELECT schedule_id,count(schedule_id) FROM attendance WHERE
count(schedule_id)<1
At 14:17 11-07-2003 -0400, Charles Vos wrote:
After much trial and error I discovered that changing the line
"QueryInterval=10" in the my.cnf file to "QueryInterval=0" would fix this
problem, and kept the user from trying to log onto the server.
It is the WinMySQLAdmin tool.
--
Regards,
For tec
Hi,
I have a table PAYMENT which has 3 fields.. PaymentID,InvoiceID,Payment
PaymentID is th eprimary key. For each INvoiceID there can be more than one payment
but less than 6 payments.
PaymentIDInvoiceIDPayment
1123 23
2 123
Hello,
Is there a way to specify MyISAM for all tables in a given file rather
than having to specify it at the end of each table declaration. I think
this would make porting databases back and forth to MySQL somewhat easier
since including MyISAM as part of the table declaration is not compatibl
Interesting!
After reading about gator via this email I ran
ad-aware on my laptop and it found gator.
Could it be that one of these emails had it in it?
No more gator on my machine
C U later gator :-)
---Original Message---
From: _Chris McKeever_ <[EMAIL PROTECTED]>
Sent: 07/11/03 06:
On 11 Jul 2003 at 15:41, Ray wrote:
> and after a while someone wanted something that would always be first
> in the table when ordered, so i added the entry to it and edited the
> id to be -1. now whenever anything is added to the table it gets an
> id of 2147483647
>
> how do i fix it so that
have a table
CREATE TABLE `pics2003` (
`ID` int(11) NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`ShortDesc` text,
`LongDesc` text,
`Image` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
and after a while someone wanted something that would always be
I am using 4.0.13, not 4.0.1. Good to know what was wrong with the
previous statement. How bout this one?
DROP TABLE IF EXISTS table_tmp;
CREATE TABLE table_tmp (
`id` varchar(12) NOT NULL default '0',
`count` mediumint(15) NOT NULL default '0',
`period_count` mediumint(15) NOT NULL defa
Hello
I have a following question:
I have a table with thousands of rows which i need to show in a String Grid ( I use
Borland Delphi with MyDac component which implements MySQL interface).
If i make a query
SELECT * FROM tbl WHERE col1="something",
it can cause retreival of 10,000 records
mysql-max-3.23.57-pc-linux-i686
I notice that slaves which never went out of sync are now doing so
regularly with the same traffic pattern. Since upgrading to 3.23.57 I've
notice a large increase in CPU utilization with the same configuration
as the previous version in production 3.23.54. Anyone
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
>> configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
Sorry about my previous post. I meant that reply for a different message.
Emile State
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I disagree, even though I had my own share of problems in compiling 4.0.13.
The clue is in the error message
>> configure:error: no acceptable C compiler found in $PATH
It is very likely that if he typed
which cc or which gcc
the reply would come back
No cc (gcc) in ... (a list
The MySQL manual section that discusses how to run multiple MySQL servers
on a single machine now includes information for Windows.
I'd appreciate it if people who try these instructions would report to
me any problems or things that seem unclear.
The instructions are here:
http://www.mysql.com/do
I recently noticed that my MySQL server was getting about 3 connections every 2
seconds. Checking the error log I discovered that a user '[EMAIL PROTECTED]' was
trying to connect to the server over and over and over and failing each time. Curious
as to what this 'user' was trying to do, I allo
That did it -- show table status lists the upper limit as approx 1TB now =].
I'm still curious about the InnoDB issues, but now at least I can avoid it
and work with the original plan!
Thanks,
Nick Elliott
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Nicholas Elliott
"Roy Walker" <[EMAIL PROTECTED]> wrote:
>
> Thanx for your help. Still having an issue with this. I forgot to mention I am
> running MySQL 4.0.13. Tried both of these statements:
>
> INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
> (SELECT count FROM table2
I opened mysql.sql in BBEdit and ran the Zap Gremlins command, and
there were 3+ Gremlins in front of every field name on that line. Upon
removal of the gremlins, it reads the file fine. Weird, no?
On Friday, July 11, 2003, at 09:32 AM, Chris McCue wrote:
I am trying to automate importing fres
"Phil Evans" <[EMAIL PROTECTED]> wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
>
> I have a resultset with this structure:
>
> nodatadate
> 1uytd1
> 1klhd2
> 1oiud3
> 2kjhd1
> 2kljhd2
> 2
Eva,
Thanx for your help. Still having an issue with this. I forgot to mention I am
running MySQL 4.0.13. Tried both of these statements:
INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
(SELECT count FROM table2 WHERE id=id1 order by timestamp desc
limit 1))
My money is on that the person who is getting "this gator crap" has a a
peice of spyware installed on their machine (gator and/or savenow.exe). This
is an app that launches addware based on your surfing habits. I believe they
are the same people who were serving up the infamous X10 Camera adds.
My
Yes and think before you type, "I may have to consider using another database."
That shows real maturity. First of all if you are really that important of a customer
and have the ability to influence your organizations database useage decisions, and if
this really angered you off that bad, then
Im having troubles getting the results I want... can someone suggest which way to go..
mysql 4.0
A
| 1 | |
| 1 | BAD |
| 2 | |
| 3 | BAD |
| 3 | |
| 4 | BAD |
| 5 | |
| 5 | BAD |
| 5 | BAD |
what I want is 5 results. If there is a NULL, then ret
In the last episode (Jul 11), Nicholas Elliott said:
> I've been experimenting with the best way to store a large (~100GB)
> of data for retrieval. Essentially, I'm storing 9 variables for
> approximately 1,000,000 locations a day for the last ten years. This
> can work out at around 4MB a variable
The whole point of gator is that the web site owner has no control of
this. There is nothing mysql.com webmaster can do about this. I think
they could sue GatorWare, but to what end. In the future, it's
important to take a innocent until proven guilty approach on this list.
> -Original M
Certainly datetime is the way to go. It takes up 8 bytes per row, as
opposed to 4 bytes for int. But, even if there are 10 million rows
(over 27 years of data), thats only a 4 MB difference.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July
We have loaded a very large dataset and received an error message stating that the key
file is full. How do you go about increasing the allowable size of the key file?
I assume by the key file the error message is referring to the .MYI file. Is this
correct?
Thank you for the help.
Carmine Smed
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data for
retrieval. Essentially, I'm storing 9 variables for approximately 1,000,000 locations
a day for the last ten years. This can work out at around 4MB a variable a day - but
not all variables are always presen
I am trying to automate importing fresh data every morning. i execute
mysql -h my-domain.com -P port -u user -ppassword database_to_use <
mysql.sql
at a given time, and that appears to be working. The contents of
mysql.sql are
flush tables;
delete from a where id > 0;
delete from b where id >
I checked the archives, so I think this is the proper list to post this
on. I'm not altogether sure, though, so if I'm mistaken feel free to, I
don't know, beat me up and throw me into a dark alley.
I recently purchased a virtually hosted account and set up a PHP4 and
MySQL(3.23) site. I had no
Hi Brian,
You understand that (at present) you will need to use Innodb tables if you
want or already use Foreign key support ?
O.K , just making sure you didn't miss that.
I can give you only advice how to do it in the mysql command line client.
Please login to the mysql command line client t
On Sat, Jul 12, 2003 at 01:11:41AM +1000, Phil Evans wrote:
> Hi there. I am a rank amateur at this trying to make sense out of a heap (and
> growing) of data.
>
> I have a resultset with this structure:
>
> nodatadate
> 1uytd1
> 1klhd2
> 1oiud3
> 2kjhd1
>
Hi there. I am a rank amateur at this trying to make sense out of a heap (and growing)
of data.
I have a resultset with this structure:
nodatadate
1uytd1
1klhd2
1oiud3
2kjhd1
2kljhd2
2asdd3
that I wish to convert to this structure.
no
Hi Everyone,
I'm using PHPMyAdmin to set up the database for a website, and I am
trying to set up foreign keys between tables. I know that MySQL doesn't
enforce them, but I want them there as part of the schema anyway. I
tried executing the command to add the foreign key, it ran without any
error
If you cannot get file system access on the webserver, then you will
need to dump the contents of the tables into a text file with the
appropriate dump commands.
If the webserver has something like phpMyAdmin, you can use that to
easily create a text file that you can then import into your mysql o
probably one of the many replys you'll get on this, but
ORDER BY month(start_date)
assuming the column that has the date is start_date
On Thursday 10 July 2003 14:51, Mike At Spy wrote:
> I am trying to create an order by in a select statement that takes a
> standard 'date' column in a table an
Hi,
I am a new admin and I was recently ran into a problem -
When I execute the show processlist command I see locked( in state locked ) processes
and if I kill one all the other get locked and the db freezes.
When I kill all of them the problem is solved. This problem has been re-occurr
I have the following problem :
I have been asked to redevelop a clients website which is written in PHP and
uses MySQL as the backend. This site is on a remote server so there is only
so much I can do with it.
They want me to move it to a Windows box in our office and convert the pages
to asp but
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 10, 2003 10:59 PM
> To: C. Reeve; [EMAIL PROTECTED]
> Subject: Re: What's up with this GATOR crap?
>
>
> At 23:43 -0400 7/10/03, C. Reeve wrote:
> >Hi,
> >
> >I have noticed recently that every tim
Compiling MySQL from the source tarball is not for linux newbies.
Get the RPMs.
root wrote:
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shell>groupadd m
Hi Anton;
Thank you for the english reply. With your permission (I hope) I post it to
the mailing list. I know that there are some marvelous minds arround ;-)
Unfortunately I will not be a big help on this topic.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 11日 金曜日 20:56、あなたは書きました:
> Hi
I'm looking for an easy way to use mysql from user (no root, no mysql
system account) space. I don't want the user of my application to have
to use a password to connect to the database. I want to have multiple
databases to differentiate between programs.
Is libmysqld the way to go?
Is a separate
Type the command
echo $PATH
You will see a set of semicolon delimited directory path names. Perhaps
something like
/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/X11R6/bin
The configure script is looking in each of these locations for an
acceptable C compiler. Either you do no
"GREEN, Darren" <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 48 lines --]
>
> I am running Discus Message Board on MYSQL server version 3.23.55 all on
> Windows 2K platform. Discus appears to be encrypting the user password
> with, I think, Encrypt("password", "s
Encrypt() using a system call to encrypt the string. So if your system
does not support crypt(), you are out of luck. Windows does not support
crypt().
How to get around this? Well, the best way to solve it is to install
linux on your PC. The easier one is to use another encrypting methods,
such a
http://www.mysql.com/products/myodbc/index.html
-Original Message-
From: Azrin Aris [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 12:15
To: [EMAIL PROTECTED]
Subject: How to connect o remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server
fr
Hi Rich,
How did the exam go ?
I did the core exam today (passed;-).
I found that the exam is hard (but fair) for beginners.
I can only suggest for anybody thinking about taking the exam to have a look
at some of the below topics:
LEFT and RIGHT JOIN
Converting nested queries /subselects
Case
I am running Discus Message Board on MYSQL server version 3.23.55 all on
Windows 2K platform. Discus appears to be encrypting the user password
with, I think, Encrypt("password", "saltcode") (calling the function in
MYSQL). When I run it just returns NULL. Any
ideas why and what I can do to mak
I have a MySQL Server in a Windows Box. How can I connect to the server
from another windows box using ODBC?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We've recently enabled slow query logging on a server and it's proving
interesting seeing which queries are bogging things down. This one is
puzzling me a little:
SELECT articleid, type, authorid, authorname, text, posted FROM
comments WHERE status = 'normal' ORDER BY posted DESC LIMIT 5;
The p
FROM table1
LEFT JOIN table2 ON table1.column = table2.column
LEFT JOIN table3 ON table1.column = table3.column
-Original Message-
From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: 2 or more LEFT JOIN?
Hello mysql,
If I
I am not sure if I fully understand your problem, but I think you have
to move the IS NULL to the LEFT JOIN condition.
Cheers
/rudy
SELECT distinct
useronline.uname,
penpals_fav.fav_user_id,
penpals_fav.ID,
penpals_privmsgs_block.blocked_id
FROM useronline,
You could add a column 'is_updated' and set it to 'Y' when it is
updated. But depends very much on what you want to achieve by it
/rudy
-Original Message-
From: Keith Hamilton [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 18:39
To: MySQL
Subject: Pull updated Records without a d
hi there,
I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've
created directory /home/users/mysql and add group for mysql. Those are the
command that I've used previously:
shell>groupadd mtsqlid
shell>mkdir /home/users
shell>useradd -d /home/users/mysql -s /bin/false -g mysqlid m
"renniw one" <[EMAIL PROTECTED]> wrote:
> Hi,
>In the mysql documentation, a mysql name is said to consist of 'three
> numbers and a suffix'. However, I have come across mysql versions such
> 3.23.56a, 4.0.12-nt and have read of versions like 3.23.33-log. The
> documentation lists -alpha, -b
"Nick Keeling" <[EMAIL PROTECTED]> wrote:
>
> I am a MySQL newbie with a post installation problem. I have Linux Red
> Hat 9 with MySQL 4.0. After installing MySQL, I can not for the life of
> me get the mysql daemon to run. My installation directory is
> /usr/local/mysql but it wants to open a da
The a, b, ... is applied to older versions which got a bugfix. E.g. if
the current version would be 3.23.44 and a bug is found in 3.23.33 which
is fixed, then 3.23.33 becomes 3.23.33a and so on.
Please note that normally bugs are only fixed in the latest version, so
you have to upgrade. However so
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not
> permitted or is this due to a setting somewhere? Can i do only one SQL
> statement per call to mysq
"Edison Cneeden" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> When i try to do the following in PHP I get errors. Is this not permitted or
> is this due to a setting somewhere? Can i do only one SQL statement per call
> to mysql_query?
Yes.
>
> $sql = "CREATE TEMPORARY TABLE tmp
> SELECT field1
Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
$sql = "CREATE TEMPORARY TABLE tmp
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
INSE
79 matches
Mail list logo
