Hello, all:
It seems that the 4.0.11a Gamma release on Windows allows all users to
connect, even though they don't have connect permissions in the user table.
Could this be right?
I'm running on WinXP. I apologize - I'm new to MySQL, so please let me know
if I am reading the documentation
OK, attempt number two:
Let's see what you are after is the number of emails that a member
has received (say 25), and then you also want the number of members
that have received x-number (say 25) emails. Is this even close to
what you want?
I think the only way to answer the question(s) is to
On Mon, Mar 17, 2003 at 10:47:09PM -0800, Daren Cotter wrote:
This seems to be doing the same thing as the
previously mentioned query...simply listing all
mailing IDs, along with the # of members it was sent
to. I've included both queries with their results
below.
Hi Daren,
Heh. The
Check BLOB data type:
http://www.mysql.com/doc/en/BLOB.html
Regards,
Joseph Bueno
Lai wrote:
Hi.
I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program.
But now I do think about it, I
Description:
SELECT DISTINCT in combination with ORDER BY a non-selected field
will return multiple identical result rows
if the WHERE clause eliminates 'other' rows
How-To-Repeat:
drop table if exists test1;
create table test1 (
id1 int
Hi!
InnoDB is a MySQL table type which provides transactions, foreign key
constraints, and a non-free Hot Backup tool.
InnoDB is included in all versions of MySQL-4.0, which you can download from
http://www.mysql.com/downloads/mysql-4.0.html.
MySQL-4.0.12 is a bugfix release of the MySQL-4.0
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Shulman wrote:
Hello, all:
It seems that the 4.0.11a Gamma release on Windows allows all users to
connect, even though they don't have connect permissions in the user table.
Could this be right?
I'm running on WinXP. I apologize - I'm new to
Mark,
Thanks for your note. I did read this page in the manual, especially this
paragraph.
The default privileges on Windows give all local users full privileges to
all databases without specifying a password. To make MySQL more secure, you
should set a password for all users and remove the
Hi all!
Using mysql 2.23.54a as both master slave:
** On master:
mysql CREATE DATABASE repl_test;
Query OK, 1 row affected (0.03 sec)
mysql USE repl_test;
Database changed
mysql CREATE TABLE test (
- a INT UNSIGNED AUTO_INCREMENT NOT NULL ,
- b INT UNSIGNED NOT NULL,
- PRIMARY
Hello All,
We are not spammers at all. We just think that our announcements may be
interesting to the MySQL community as our products are directly related to
MySQL server. Thanks to everyone who understands that and supported us in
this discussion.
2Reiner: BTW, one of the Siemens AG branches is
Do you plan on attending the first MySQL Users Conference to be held
next month in San Jose, Calif?
Our company is one of the sponsors for this event and we very much
look forward to meeting many of you.
If you haven't already registered for this important event, we
strongly encourage you to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Shulman wrote:
Mark,
Thanks for your note. I did read this page in the manual, especially this
paragraph.
The default privileges on Windows give all local users full privileges to
all databases without specifying a password. To make
At 21:34 -0800 3/17/03, geeta varu wrote:
does subselect work in mySQL 3.23 ...i'm trying to
exceute the following query ...
No subselects until 4.1. Perhaps you can rewrite your query as a join.
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Select can_ID from TABLE1 where
Michael,
mysql DELETE FROM user WHERE Host='localhost' AND User='';
mysql QUIT
C:\ C:\mysql\bin\mysqladmin reload
In my example, you will see that I did DELETE FROM user to remove all rows
where username is blank. However, I did not reload the service. When I did,
it now looks like the
Hello,
I have been working for the past couple of days trying to get tables
larger than 2GB on my linux system.
Here is what it is installed:
Linux 2.4.20 i686
glibc-2.3.1
gcc-3.2.2
I am trying to install 3.23.55 from source. During configure, I get
the following:
checking for CFLAGS value
Hi,
Why does this not work?
SELECT * FROM News WHERE category='sport' AND MATCH
(subcategory,headline,summary) AGAINST ('madrid') LIMIT 1,25
If i remove the category='sport' AND from the WHERE clause it works - yet all
documents in the db currently have category='sport'. Is it not possible to
Pursuant to last week's discussion of why, if DATE and TIME each take
three bytes, does DATETIME take eight bytes, I found the following in
the internals.texi document:
@strong{DATE}
@itemize @bullet
@item
Storage: fixed-length series of binary integers, always three bytes
long.
@item
Example: a
Hi,
- Original Message -
From: Daniel Kasak [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 12:35 AM
Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released!
Rusch (ext) Reiner wrote:
Hi,
is anyone interested in commercial use/spam of this list?
If not, I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 17 Mar 2003, Dyego Souza do Carmo wrote:
I'm trying to compile MySQl 4.0.12 from BK three... and the error is:
Making all in libmysql
make[2]: Entering directory `/temp/mysql-development/mysql-4.0/libmysql'
source='libmysql.c'
Dear mysql:
Register a domain name(.com/.net/.org/.biz/.info/.us) ONLY $13.95 a year, Please
visit:
http://www.okdns.net
FREE SERVICES with domain registration:
- Free change registrant information.
- Free DNS services.
A/MX/CNAME/* your domain name to any IP address or
On Tuesday 18 March 2003 02:47, dreq jkj wrote:
I have trouble figuring out how the indices are used when making a query
that uses OR-operator.
If I have the following table:
create table testing(
id int unsigned not null primary key auto_increment,
idx1 int unsigned not null,
idx2 int
On Tuesday 18 March 2003 02:26, Custódio de Matos Lima wrote:
Im having some troubles when creating the foreign key
constraints in a InnoDB database. The problem is, i
can create the InnoDB table, but im having a little
difficult to make the connections with other tables.
The error that
Hi
I am a new user of Mysql and have received an error.
I enter my C drive using the MS-DOS prompt. I then access the mysql\bin
directory.
I then type mysql. which welcomes me to Mysql Monitor.
I then try to create a database called database01 by typing mysqladmin
create database01\g but i get
No, that should work. Do any items in the db have the text 'madrid' in them?
Does it fail with an error or does it simply not return any results? Are you
executing it on the command line? If not, are you checking for errors? What
version of MySQL do you have?
Brian McCain
- Original Message
At 3:16 + 3/14/03, Patrick Geary wrote:
Hi
I am a new user of Mysql and have received an error.
I enter my C drive using the MS-DOS prompt. I then access the mysql\bin
directory.
I then type mysql. which welcomes me to Mysql Monitor.
I then try to create a database called database01 by typing
Hi,
You should run mysqladmin from DOS prompt, not within mysql client.
If you want to create a database from mysql client, you should use:
create database database01;
Regards,
Joseph Bueno
Patrick Geary wrote:
Hi
I am a new user of Mysql and have received an error.
I enter my C drive
The correct syntax for creating a database is:
mysql create database databse_name;
mysqladmin is a command line program, not for use inside the mysql client
program.
David
-
Before posting, please check:
You don't want to use any calls to 'mysqladmin' inside of the MySQL Monitor,
as mysqladmin is for command line functions (outside the command line)...you
may want to reread some of the documentation on this, starting here:
http://www.mysql.com/doc/en/Connecting-disconnecting.html
Brian McCain
On 18 Mar 2003, at 10:49, Paul DuBois wrote:
Pursuant to last week's discussion of why, if DATE and TIME each take
three bytes, does DATETIME take eight bytes, I found the following in
the internals.texi document:
Thanks for tracking that down. I spent a little while looking in the
source
Dear Walt, dear List,
thank you for your reply. Finally a suggestions at all.
I checked both
/proc/sys/kernel/threads-max
/proc/sys/kernel/shmmax
I dont think threads-max will be a problem, because the value is 14336,
and i dont think my system will ever have to handle this number of threads.
Hi all,
I am in the process of planning for the construction of a very large
database and I wanted to do a reality check before hand. in this
database a typical table would be 100,000,000 rows and some tables could
be as large as 100 times that, 10,000,000,000. I am wondering:
1- is it
On Tue, 18 Feb 2003, Virdhagriswaran SHIBATA wrote:
Mysql, your immediate help is needed. We are a .com
corporation that is growing fast (over 1000% per year). We simply cannot
keep up with demand.
Remind me again why we bother with a spam filter?
--
John Klein
Database Applications
Hi Walt,
i am using PHP to generate the connections. The maximum
was around 750 Connections. I am sure it never was more
then 800. At the moment i have queries per second avg: 548.286
Regards,
Philipp
- Original Message -
From: walt [EMAIL PROTECTED]
To: Philipp [EMAIL PROTECTED]
Maybe the [EMAIL PROTECTED] address should be changed to
[EMAIL PROTECTED] so people can't pull the Username off the e-mail
address and bypass the filter.
-Original Message-
From: John Klein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: Re:
Mysql, your immediate help is needed. We are a .com corporation that is
growing fast (over 1000% per year). We simply cannot keep up with demand.
We are searching for motivated individuals who are looking to earn a substantial
income working at home.
mysql This
Description:
Hello Peter,
Have you explained to Heikki this problem?
Have you fixed it?
Please, tell me about it.
Regards,
Rafa
How-To-Repeat:
Select ... from giros ...
Fix:
-
Synopsis:optimizer bug in the index used by
I'm just getting used to SQL/MySQL, so there is likely a name for this or it
may be well known -- I just haven't either come across it, or haven't made
the associations between all the parts yet.
I have 2 tables, one a temp table, and they have the same columns. I'd like
to be able to select
Paul,
which MySQL version you are using?
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Corresponding ON UPDATE options are available starting from 4.0.8.
If you are using = 4.0.8, can you create a small repeatable test case?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical
Hal Vaughan wrote:
I'd like to be able to select from both tables and get one listing.
Table 1 is Cases, Table 2 is Temp. They have columns Name, Amount, Zip.
SELECT * FROM Cases AS C, Temp AS T WHERE (C.Amount 500 OR T.Amount 500);
produces a list of 38 rows w/ 6 columns (the first 3
UNION is new in MySQL 4. Be careful of that.
http://www.mysql.com/doc/en/UNION.html
If you don't have MySQL 4, your problem becomes a bit tricky, because MySQL
doesn't know that T.Amount and C.Amount are conceptually the same, so it
won't group the columns. Basically, you want to select T.* if
Actually, I just found a tutorial on how to mimic the UNION statement with
MySQL 3.x:
http://www.nstep.net/~mpbailey/programming/tutorials.union.php
- Original Message -
From: Brian McCain [EMAIL PROTECTED]
To: mysQL List [EMAIL PROTECTED]
UNION is new in MySQL 4. Be careful of that.
Description:
Attempts to start slave replication fail when MySQL attempts to write
the bin-log location to the master.info file.
Attempts to manually change master also fail when writing to
master.info file.
master.info file is created, but has zero length
Is it possible? Can it really be true? I check the website daily and watch
the lists eagerly. As I looked at the website just now, I saw it...
Database Server
Production: 4.0.12
Did I miss the announcement? Is the website jumping the gun? Or am I the
first to find out?
;-)
oh, please let
To replicate:
1. Start with a machine running Pentium 4, Windows XP Pro.
2. Map a New Network Place to:
\\somecomputer\C$
Where \\somecomputer contains an install, in the root directory, (i.e.
C:\mysql,) of mysql already. The remote install in this case was version
3.23.56.
3.
when MySQL will support fulltext search on InnoDB tables?
_
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/
-
Before
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.12, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
Thanks for the speedy reply. I will try it out on some test tables.
Liz
On Mon, 17 Mar 2003, Paul DuBois wrote:
At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote:
I have an table with a column
numberINT NOT NULL PRIMARY KEY
This table contains many records and there are
Hi Brian,
Sorry, I was mistaken. It does work! The documents in question, were not
category='sport'.
Regards
Martin
Brian McCain [EMAIL PROTECTED]
18/03/2003 17:23
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc:
Subject:Re: Fulltext Search Problem
Hi all,
Anyone know why mysqladmin processlist is not showing the host that is
connected, but instead is showing the following in v4.0.12:
truncated excerpt
+-+-+--+--+
| Id | User| Host | db | Command
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of
messages ago):
Functionality added or changed:
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to make it easier to know from which client the request
originated.
I guess whenever
It says in the change log that it added the port to make it easier to see
where the connection is coming from. 146.101.143.72:48753 gives you a lot
more information than host1
From the release announcement --
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to
Hi,
I do understand what you're saying and I did read the 4.0.12 changelog and
appreciate the addition of the TCP port in that display, but all the
hostnames in the processlist are displaying as the localhost of the mysql
server that they are connecting to instead of the hostnames of the server
[EMAIL PROTECTED] schrieb:
access-2000
w2k-prof/xp-prof via
myodbc 3.51
different mysql-servers (win-lin)
everywhere the same, including win9x
if i leave ms-access longer than 25 minutes alone with mysql via myodbc
3.51
i cannot close ms-access:
- free translation:
this procedure will put
[EMAIL PROTECTED] wrote:
hi,
access-2000
w2k-prof/xp-prof via
myodbc 3.51
different mysql-servers (win-lin)
if i leave ms-access longer than 25 minutes alone with mysql via
myodbc 3.51
i cannot close ms-access:
- free translation:
this procedure will put the current code back into the
I wouldn't say I was a newbie at all. I've been coding in PHP, mySQL for
like 6 years now. But I just never learned (or maybe had a reason to) why I
would use KEY (a_id, b_id) rather than KEY (a_id) and KEY (b_id).
Would someone be so kind as to point me at an online tutorial or just
explain what
In the last episode (Mar 18), Daevid Vincent said:
I wouldn't say I was a newbie at all. I've been coding in PHP, mySQL
for like 6 years now. But I just never learned (or maybe had a reason
to) why I would use KEY (a_id, b_id) rather than KEY (a_id) and
KEY (b_id). Would someone be so kind as
Ah ha!
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5) unsigned auto_increment,
`rep_login` varchar(15) NOT NULL default '',
`rep_password` varchar(15) NOT NULL default '',
`rep_fname` varchar(255) NOT NULL default '',
`rep_lname` varchar(255) NOT NULL default '',
Anyone know whether this is a bad idea or not (gcc-2.95.3)?
I previously (MySQL-4.0.5 or so) built a server with -march=k6 which
seemed to run OK apart from crashing when I did a very particular select
on one table, but I was never sure whether that was because of a damaged
table or because of
- Original Message -
From: Daevid Vincent [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 4:59 PM
Subject: RE: Please tell me why to use KEY (a_id, b_id) rather than KEY
(a_id), KEY (b_id)
Ah ha!
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5)
Hi,
I found a problem with your binary distribution of MyODBC 3.51 for Mac
OS X.
I downloaded the binary distribution of MyODBC 3.51 for Mac OS X (I am
currently using Mac OS X 10.2.4 Darwin 6.4). When I tried to use iODBC
I got a dynamic linking problem. More specifically, when running
Daevid Vincent wrote:
So if I had:
CREATE TABLE `rep_table` (
`rep_id` smallint(5) unsigned auto_increment,
`rep_login` varchar(15) NOT NULL default '',
`rep_password` varchar(15) NOT NULL default '',
`rep_fname` varchar(255) NOT NULL default '',
`rep_lname` varchar(255) NOT NULL default
Hi,
I am coding a cgi program to query the records from the mysql tables. When
I execute the sql query (which is a join operation on two tables) in the
mysql shell, the results are shown correctly. However, if I use cgi script
to execute the same query, the web browser just crashed after a
I am running this query that is awfully slow. It's a simple query
between two heap tables with two joins. I ran a explain statement to
see why it is running so slow and realized that mysql was using
indexing for one of the lesser inefficient joins! I fixed this problem
by adding a
Dear all,
I intend to write a large volume of records to a table tbl.
tbl:
fld1, int unsigned not null auto_increment primary key,
fld2, text
fld3, text
The combination of (fld2, fld3) should be be unique, so I need to check for duplicates
every time when a record is added.
--Question1: How
At 22:23 -0800 3/18/03, Steve Quezadas wrote:
I am running this query that is awfully slow. It's a simple query
between two heap tables with two joins. I ran a explain statement
to see why it is running so slow and realized that mysql was using
indexing for one of the lesser inefficient
Hu Qinan wrote:
Dear all,
I intend to write a large volume of records to a table tbl.
tbl:
fld1, int unsigned not null auto_increment primary key,
fld2, text
fld3, text
The combination of (fld2, fld3) should be be unique, so I need to check for
duplicates every time when a record is added.
I am running Mandrake Linux 8.2, with the RPMs upgraded to 9.0. It had MySQL
3.23 running on it.
I downloaded the current version of 4.0 from mysql.com tonight and isntalled
it. I changed the old files from /usr/share/mysql to /usr/share/mysql3.23
and /var/lib/mysql to /var/lib/mysql3.23
Hal Vaughan wrote:
I am running Mandrake Linux 8.2, with the RPMs upgraded to 9.0. It had MySQL
3.23 running on it.
I downloaded the current version of 4.0 from mysql.com tonight and isntalled
it. I changed the old files from /usr/share/mysql to /usr/share/mysql3.23
and /var/lib/mysql to
on RedHat 8 installed php-4.2.2-8.0.5.i386.rpm And
php-mysql4.2.2-8.0.5.i386.rpm
but php says undefined function mysql_connect()
Is it worth uninstalling 5 and installing
php-4.2.2-8.0.7.i386.rpm etc?
I gets weary of all dese Linux version suffices
?php
phpinfo();
?
shows Configure Command
obvious fix PHP does work with rpms,
just remember to restart mysql httpd (what was wrong
with the name Apache?)
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Hi.
Here is my table design, my query and the error:
mysql describe poor;
+++--+-+-++
| Field | Type | Null | Key | Default | Extra |
+++--+-+-++
| cc | char(2)
You cannot use update on two tables. Check the mysql manual on syntax of
update.
Haifeng
- Original Message -
From: Lai [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 1:43 PM
Subject: This query shouldn't be wrong, but mysql says it is???
Hi.
Here is my
We need to set up some primitives in php for mysql, then repeat for
postgresql, so that we bury most of the differences in the primitives.
I'm pretty sure I can do this myself, but would like to avoid
re-inventing the entire wheel, if possible.
I know I'm asking for a handout here, but my
At 22:43 -0700 3/18/03, Lai wrote:
Hi.
Here is my table design, my query and the error:
mysql describe poor;
+++--+-+-++
| Field | Type | Null | Key | Default | Extra |
Anyone else notice this, or is it just me?
Andrew
-Original Message-
From: Andrew Braithwaite
Sent: Tuesday 18 March 2003 23:05
To: 'R. Hannes Niedner'; MySQL Mailinglist
Subject: RE: mysqladmin processlist = weird in version 4.0.12
Hi,
I do understand what you're saying and I did
can anyone tell me why the mysql-max 4.0.12 is not statically linked
against Glibc 2.2 ? (the standard one is ok)...
Regards
Nat
--
Natalino Picone - [EMAIL PROTECTED]
--
It's a horrible thing to be
On Wed, 2003-03-19 at 03:27, Daniel Kasak wrote:
Anyone know whether this is a bad idea or not (gcc-2.95.3)?
I previously (MySQL-4.0.5 or so) built a server with -march=k6 which
seemed to run OK apart from crashing when I did a very particular select
on one table, but I was never sure
Dear all,
Have written a wrapper to Christian Novak's excellent biffwriter class
which writes out excel files based on query to a mysql database.
A for loop, $zz=1; $zz =61; $zz++:
generates the id needed for the WHERE condition:
$sql = SELECT $arv, DATE_FORMAT(date_rec,'%m-%d-%Y') as
78 matches
Mail list logo