I've been using the online database manual, and the current version is for
2.23.38 according to the title page. I've downloaded the different html
format, both all on one page, and one page per chapter, and they're for
version 2.23.33. Is there a current version of the manual for download
that'
MINDLEADERS.COM INC
You are subscribed as: [EMAIL PROTECTED]
Good Afternoon!
We are running a FREE software promotion for five (5) powerful products for our
subscribers: eXpressForms ($129.99 value), DataScan business card scanner ($149.99),
Fortune contact builder and relationship manager ($
Hello ..
I've been experiencing a few problems with MySQL 3.23.3[67] configured
for TCP on Linux ..
We have two websites which are very active, and are noticing similar
behaviour with the database.. One site has about a hundred thousand
users, and gets very active a few times a day.. The site
On Fri, Apr 27, 2001 at 07:15:59PM -0500, Alec Solway wrote:
>
> I'm a bit confused about whether I need to purchase a license in the
> following situation. Different sources (MySQL by Paul DuBois and the
> MySQL doc) differ in certain aspects, I assume the doc is more
> accurate, but even still,
Hi,
I'm a bit confused about whether I need to purchase a license in the
following situation. Different sources (MySQL by Paul DuBois and the MySQL
doc) differ in certain aspects, I assume the doc is more accurate, but even
still, I want to make sure.
I would like to install MySQL on my serve
How stable is InnoDB, BDB, MyISAM, etc?? I am developing a production system
using MySQL, and wanted to know that stability status on these table types.
I wanted to use transactions if I could - is the transaction-enabled table
types stable enough for production? Or should I stick with MyISAM and
When I run the safe_mysqld, I get the following error message:
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/safe_mysqld.
I don't have a folder calle
Ok, a few things I see...first off, slap some keys into those tables on the
join portions. Secondly, upon examining your query a second time, your
never joining subsnp and locuslink. I see your trying to use a full join,
but you didn't put the criteria for it in the where clause. That would
cau
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
johnd wrote:
>
> Hi,
> We have Win2000 server version installed.
> If we want to install Linux on the same computer, is it possible?
> How to do it?
> Need install Linux first then install Win2000?
> We would like to compare Linux and Win2000 work with MySQL for our application
>development.
>
Please do a "SHOW FIELDS FROM" and "SHOW KEYS FROM" on all tables involved
so we can see what's going on here. Also, a warning, if desacription is
indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use
index's.
Would also help if you did an EXPLAIN on that query and sent that.
hi.
by skimming that query, the first thing that will take a long time is the
'description like "%GABA%"' part...that's a pretty inefficient method of
searching due to the wildcard at the beginning of the string.
if there are no indexes on the tables, you should probably add some.
"show index fr
Hi evrerybody
I have recently joint this mailing list.I am a new user of Mysql, I am
having a problem with mysql 3.22.32 on sun sparc netra t1.we are running
an ISP and we have around 9000 to 1 users in our database.
The problem is this that if some one sends any large query to check
three fo
I am working on a mysql database with many large tables (1.5 million rows on
some) and came across a beeg problem.
I have need for a query like this:
mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as
Why do I get message "Can't connect Mysql server throuht mysql.sock "?
Davin Flatten wrote:
>
> Hello everyone,
>
> I have a quick question of performance. Which is
> faster with the Perl DBI:
>
> 1. One SQL query that retrieves a large amount of data
> and then lets Perl decide what to do with each row.
> i.e. this row is a "foo1" do this, this row is a
> "foo2"
Actually, there is a way to do this by taking advantage of variables. If
you read my previous post on the matter, you can use variables to get a
cumulative total.
- Original Message -
From: "Steve Ruby" <[EMAIL PROTECTED]>
To: "Roger Karnouk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Se
Roger Karnouk wrote:
>
> Is it possible in a Select query to get values from the previously read row
> in order to do things like cumulative sums or other formulas which require
> the previous value in order to calculate the current value.
>
> ex.
> day current sales cumu_total
> - --
Hello everyone,
I have a quick question of performance. Which is
faster with the Perl DBI:
1. One SQL query that retrieves a large amount of data
and then lets Perl decide what to do with each row.
i.e. this row is a "foo1" do this, this row is a
"foo2" do this.
2. Several SQL queries that se
Attempting to define an admin user that can connect from any host.
Host='%', user='admin', password=PASSWORD(xxx), all _priv values are 'Y'
when launching "./mysql -u admin -p mysql" and entering password, I get:
"./mysqladmin: connect to server at 'localhost' failed
"error: 'Access denied for
Hi
I have this very set up. I use System Commander from VCommunications. Also
I run Win2000 in a VMWare virtual machine under Linux. MySQL runs fine
using either method
At 09:57 27/04/1999 -0400, johnd wrote:
>Hi,
>We have Win2000 server version installed.
>If we want to install Linux on the sa
# mysql.server stop
# mysql.server start
gives me a permission denied. Is there another way to start the daemon?
Manatee
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
All seemed to be going well untill...
sr/local/include/mysql -c get_table.cc
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I.
-I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c admin.cc
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I.
-I../mysql++-1.7.8/sqlplusint -I/usr/local/include/m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks to all for their suggestions.
NuSphere is 'expensive' because they sell a commercial product, a one
stop MySQL shop.
I thought about burning a PDF file on CD, but decided against it.
I'll probably pick up the MySQL book by Paul Dubois.
---
Is it possible in a Select query to get values from the previously read row
in order to do things like cumulative sums or other formulas which require
the previous value in order to calculate the current value.
ex.
day current sales cumu_total
- ---
1
Why do I get the following results?
mysql> select (1008306000-988344000)/86400/7,
mod((1008306000-988344000)/86400,7.);
++--
+
| (1008306000-988344000)/86400/7 | mod((1008306000-988344000)/86400,7.)
|
+---
It sounds like you might have some stray ' characters in your text
You didn't give much information, but let me see if I can't figure out kinda
what your doing...
Your using perl, so I assume your going to be using DBI. In DBI you have
your statement handles, or do statements. That means y
\n\nDatabase Administrator";
$subject = "Your Subject here";
mail("$email","$subject","$message","FROM:[EMAIL PROTECTED]\nBCC:your
[EMAIL PROTECTED]");
}
} else {
$error = mysql_error();
echo"your sql statement : $sql generated the following error :
$error";
Hello Friends at MySQL :
Above all, I want to greet you and thanks for given us a great opportunity
to have a stable, reliable and free database. By the current time, I'm
working with MS-SQLSERVER. It works fine and the tables has the common
datatypes known ( datetime, char, numeric, etc ). My
This note is primarily meant to stuff something into the archives in case
other people have problems compiling mysql under AIX.
There are a number of changes that need to be made that aren't detailed in
the documentation, (some alteration to those docs could save someone a lot
of effort in the f
>Description:
When i want to find the next unused id from a table joining it whith another
table the result is allways 1, even though this is not correct
>How-To-Repeat:
create table a (id int not null primary key);
create table b (id int not null primary key);
insert into
How do i create a username and password in mySQL. Also please advise me
how can i create tables mySQL.
Sorry for very basic questions.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Yes it's possible and quite easy no matter which one you install first, but
this is a mysql mailing list. You can find everything you need at
http://www.linux.org
jason
- Original Message -
From: "johnd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 27, 1999 11:57 PM
S
Hi,
We have Win2000 server version installed.
If we want to install Linux on the same computer, is it possible?
How to do it?
Need install Linux first then install Win2000?
We would like to compare Linux and Win2000 work with MySQL for our application
development.
Greately appreciate for you
How do I fix this error: "MySQL Connection Failed: Access denied for user:
'mysql_user@server' (Using password: YES)"
Even I am unable to use database
Kindly help me...
_
Chat with your friends as soon as they come online. Get Rediff Bol
To Whom It May Concern:
I am following the install procedures from the current documentation manual
and trying to install mysql version 3.23.37-pc-linux-gnu-i686 in RedHat
version 7.0. When I try to run the mysql_install_db in the scripts
directory, it comes back stating that I should try to ru
I'm not sure how this happend but Mikel didn't write that. Could some one kindly
forward me the original for the snippet below, including the headers...?
Thanks,
Mikel
Ray Cote wrote:
> At 4:44 PM -0400 4/26/01, Mikel wrote:
> > > I'm trying to create a perl script that just produces a MySQL
[EMAIL PROTECTED] writes:
> >Description:
>Mysqldump does not work correcly. Some data from some tables are not
>dumped.
>ex) Tabledef.
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default | E
Dear Clay Bond,
I am really new to PHP,
Can you please kindly let me know a code snippet to do the same? i.e. while
loop etc.
Thanks
Love and regards
Prasad
- Original Message -
From: "clay bond" <[EMAIL PROTECTED]>
To: "*MySQL mail list" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 200
At 20:45 26/04/01 -0700, Brent and Maria wrote:
Hi,
I guess that your problem is the permission of the user that
you made the login. Take a look to permission properties
in the \mysql\data directory.
Regards,
Miguel
>Hello List,
> I have recently installed mysql 3.23.33 on my windows 200
There is a php mail tutorial at http://www.phpdeveloper.org/tutorial.php
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "Prasad Mhatr
On Fri, 27 Apr 2001, Prasad Mhatre wrote:
> Dear All,
>
> Can anyone suggest a link where I can find a script in PHP3 to mal all users
> in MySQL database?
That's pretty simple, isn't it? Pull the usernames
from the table, then put mailto:$email>link
?> or something like that in a while loop
Am running Redhat 7.0, and had installed. 3.23.22. with php4.0. Would
like to upgrade to 3.23.32. No existing tables or data. Any major
problems anyone having with .32 version on 7.0 redhat? Also, any special
steps to upgrade rpm and keep php4.0 intact? What add'l libraries are
needed? What about
Dear All,
Can anyone suggest a link where I can find a script in PHP3 to mal all users
in MySQL database?
Thanks
Love and regards
Prasad
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi There
There are two books that I know of that are about SQL.
www.amazon.com I use a book and web site to get the full pic...!
Simon
PS Book is $34.95...!
-Original Message-
From: Robert Vetter [mailto:[EMAIL PROTECTED]]
Sent: 27 April 2001 10:04
To: [EMAIL PROTECTED]
Subject: Re: MyS
>Description:
Mysqldump does not work correcly. Some data from some tables are not
dumped.
ex) Tabledef.
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--
Jeremy Zawodny wrote:
>
> On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote:
> >
> > Is there a place to purchase the MySQL manual?
>
> The folks at NuSphere will sell you one for $79 or so. You'll get a
> CD, printed manual, and support for the software.
What? I hope you don't
Hi...
i'd like to ask about
how to set MySQL start and stop automatically when machine reboot.
We are using Redhat 6.0 and MySQL 3.23.36
thankyou
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have 3 tables that I am joining together based on that fact that one (or
more) values appear in the 2nd table, but those values that need to appear
are garnered from the 3rd table (and i want the id that is associated by
the 1st table). Err well, an example would be better:
Table 1:
id ->
49 matches
Mail list logo
