RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram.
Downloaded 3.23.52-1 rpm client rpm to /usr/loca/tmp - i created the tmp
folder as root and chmod 777
Followed the install instructions - which only included:
To perform a standard minimal installation, run:
shell
William,
Tuesday, October 02, 2001, 11:18:48 AM, you wrote:
I am curious how to rename a database in MySQL 4.0 running on win2k
server.
If your database contains only ISAM/MyISAM tables you can do it like
- shutdown MySQL server
- rename database dir
- restart MySQL server
--
For technical
vinita,
Thursday, October 03, 2002, 5:56:49 AM, you wrote:
vvM mysql select userGroup from machineGroup_userGroups where hostname=mulga;
vvM +---+
vvM | userGroup |
vvM +---+
vvM | staff |
vvM | tech |
vvM +---+
vvM 2 rows in set (0.01 sec)
vvM mysql select
Hi,
I'm writing a c++ program using MySQL++.
I insert in a table a new line. This table has an autoincrement field call ID.
Immediatly after storing a new line in the table, I execute (in the program) a
SELECT * FROM table command to retrieve the new ID just affected to the new
line, but I
Khanh,
Thursday, October 03, 2002, 6:46:05 AM, you wrote:
KP Does new MYSQL v4.0.4 support Unicode ?
KP I know that version 4.0 can store Unicode, but it cannot order, unless
KP we have to write extra codes for it. Unless I am wrong !
Nope, MySQL 4.0.X doesn't support unicode. It will come
luoya,
Thursday, October 03, 2002, 9:01:22 AM, you wrote:
ll I just install mysql 3.23.52-max-nt on two computers. One is Win2K and
ll another is winXP. It seems all right. I use the following commands on
ll both.
ll C:\mysql\binmysql ¨Chlocalhost ¨Curoot ¨Cp
ll Mysql prompt:
ll Welcome to
Hello
I'm trying to connect a Lotus Server through DECS, to a MySQL db.
The Lotus and the MySQL servers are installed on the same linux machine.
I installed iodbc, myodbc, successfully tested them with odbctest from
Linux, and with ndctest (or smth like that) from a Windows system.
Anyway, I'm
Just wanted to drop a patch on subject if it hasnt been fixed yet.
Cheers
--- mysql-3.23.52/include/global.h-orig Wed Aug 14 00:08:16 2002
+++ mysql-3.23.52/include/global.h Thu Oct 3 09:22:49 2002
@@ -201,8 +201,11 @@
#include alloca.h
#endif
#ifdef HAVE_ATOMIC_ADD
+#include
Hi,
You should use LAST_INSERT_ID() function, check the manual for details:
http://www.mysql.com/doc/en/Getting_unique_ID.html
Regards
Joseph Bueno
Poizot Emmanuel wrote:
Hi,
I'm writing a c++ program using MySQL++.
I insert in a table a new line. This table has an autoincrement field call
Puiu,
- Original Message -
From: Puiu Hrenciuc [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Philip Molter
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:46 AM
Subject: Re: MySQL/InnoDB-4.0.4 is released
I hoped
to load files into mysql:
create a table:
create table newtable (column1 int(10),column2 varchar(250));
import the data:
load data infile '/path/to/file/file.csv' into table newtable
fields terminated by ',' lines terminated by '\n'
Alia Mikati wrote:
Hello everybody
I hope u can help me
Damien,
Thursday, October 03, 2002, 4:25:56 AM, you wrote:
DB Hi, I have just started out using MySQL and have had no end of trouble
DB getting it started. I am running Redhat 7.2 and MySQL 3.23. I found that I
DB had to modify my.cnf to point to the path /var/lib/mysql/mysql instead of
DB
Norman,
Wednesday, October 02, 2002, 5:25:36 PM, you wrote:
NWJ Downloaded Win32 static binary of MySQLGUI 1.7.5-2 , but it would not
NWJ unzip.
NWJ Error message Cannot open file: it does not appear to be a valid
NWJ archive. If you downloaded this file, try downloading the file again.
NWJ I
Hello Iago,
Tuesday, October 1, 2002, 11:54:44 AM, you wrote:
IS Any of MySQL AB team could explain the options used in the compilation of
IS rpm packages for Linux?
IS Thanks in advance.
You can download the corresponding src.rpm and see.
IS Iago.
--
For technical support contracts,
Joseph,
Thursday, October 03, 2002, 3:47:21 AM, you wrote:
JS Just built a fresh RedHat 8.0 Server and tried to install the latest
JS MySQL from source.
[skip]
JS Here is the error
JS /usr/local/mysq/usr/local/mysql/bin/safe_mysqld: line 273: 24640
JS Segmentation fault
* [EMAIL PROTECTED]
Hi, I woud like to ask for help with sql select.
I have table - visitor, arrival, departure. (Time is in timestamp
in sec. from 1970) I need select top of concurrently present
visitors, between 00.00 and 29.59. So my boss want know when was
shop most full and how many
Hi,
I have heard of some Linux based DNS services that use MySQL as the bases
for zone files. Is there anyone who could point me in the right direction
or has experience in using these tools. The is my understanding that
queries can be created that allow much easier maintanence of the DNS
David Durham wrote:
Hi,
I have heard of some Linux based DNS services that use MySQL as the
bases for zone files. Is there anyone who could point me in the right
direction or has experience in using these tools. The is my
understanding that queries can be created that allow much easier
Hi,
You have right, in the new version (4.0.4) on Windows 9x are the same
symptom.
I research a little in this morning and i found where is the problem when
the innodb is initialised.
The problems is in the function:
sync_array_create()
...when it must initialise a lot of cells(n_cells=aprox.
Andrey,
Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
AK Why is temporary tables replecated?
AK Is it true?
Yes, temporary table are replicated properly since 3.23.29:
http://www.mysql.com/doc/en/Replication_Features.html
--
For technical support contracts, goto
Keith C. Ivey wrote:
MySQL AB appears to be in the midst of changing the names for the
various versions, and the information on the various pages doesn't
seem to be consistent yet.
I had replied to the original as well (and it got spam filtered for not
containing SQL!), but I'll say it
FYI..I use MyDNS here, and i really like it. has a nice little contribed
PHP interface included in it too.
be aware, it's only an authoritative name server, if you want to do
recursive/cache, you need something like djbdns dnscache along side it.
-Tony
-
System
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
You keep bringing up ODBC like it is some magic charm.
Why do you think you need ODBC?
Does your client software require it?
You have not told us what the client is, or what it is written in.
The 'mysql' client on any platform talks natively to the 'mysqld'
server on any platform.
PHP does not
Hello,
I found an other table type for transaction :
The simplicity of ACID transactions is especially important in a
distributed database environment where the transactions are being made
simultaneously. Learn more about the Gemini table type that supports ACID
Transactions.
Find in nusphere
I use some mail-lists for mysql, php and security with Outlook Express.
When I reply, some lists set their list-adress automatically, some the
adress of the person originally posting. The second version may not so good
IMHO, because I think so many replies are not going to the lists.
mysql++ and
I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000
box that I am trying to connect to with with odbc. I am getting the
following error message
[MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1
(10061)
I'm not sure how to go about correcting this
Best to check out InstallShield's product forums at
http://community.installshield.com. Their users and support staff troll it
and assist persons in need.
Kelly
SQL,MySQL
At 11:52 AM 10/2/2002 +0800, Alice Tan wrote:
Hi, i am doing a project and it is almost nearing release version.
i planned
In the last episode (Oct 03), Franz Alt said:
I use some mail-lists for mysql, php and security with Outlook
Express.
When I reply, some lists set their list-adress automatically, some
the adress of the person originally posting. The second version may
not so good IMHO, because I think so
This is what I thought. Thanks. I think we are almost there!
Chris
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 8:51 AM
To: Chris Couture
Cc: [EMAIL PROTECTED]
Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL
Franz Alt wrote:
When I reply, some lists set their list-adress automatically, some the
adress of the person originally posting. The second version may not so good
IMHO, because I think so many replies are not going to the lists.
mysql++ and mysql do not automatically reply to the list
Dean,
Thanks for you reply.
You are almost correct in our system layout but the MySQL database
server is on a seperate machine (currently running Windows 2000 AS with
all the databases on a separate drive and soon to be updated to Linux).
The inserts would need to take place over the
Can the two machines ping each other?
-Original Message-
From: Jeff Bluemel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:11 AM
To: [EMAIL PROTECTED]
Subject: MySQL and ODBC prolbme
I have mysql on a linux box (IP 192.168.0.1), and I've got a windows
2000
box that I
if you have an ms. windows machine for a front end,
i recommend that you download corereader from
http://CoreReader.com/ . ( it's free. ) it does
pointclick queries, so you can quickly experiment
with them until you get what you want.
it installs at the novice level, so set it to the
Franz Alt wrote:
I use some mail-lists for mysql, php and security with Outlook Express.
When I reply, some lists set their list-adress automatically, some the
adress of the person originally posting. The second version may not so good
IMHO, because I think so many replies are not going to
I run the following query from a php script -
select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock,
d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price,
d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr, d1.usr, d1.cusname,
d1.colours, d1.stitchcount,
Hi all,
I wonder if anyone could help me speed up the following query (it works fine
and produces the result I want but it's very slow...)
Here is a typical query (will be executed quite often on a reasonably busy
system (about 50% idle doing other stuff that is not using the below
tables..)):
Gelu,
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Puiu Hrenciuc [EMAIL PROTECTED]; Heikki Tuuri
[EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 2:40 PM
Subject: Re:
äÏÂÒÙÊ ÄÅÎØ.
sql
Andrey,
Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
AK Why is temporary tables replecated?
AK Is it true?
Yes, temporary table are replicated properly since 3.23.29:
http://www.mysql.com/doc/en/Replication_Features.html
Hmm... What is the reason?
If I create
Hi All,
First thanks to all who worked on InnoDB, it is truely exciting to get its
features in an open-source DB. We've had an excellent experience thus far
with a few exceptions. Any help on solving the problem below is greatly
appreciated ...
We experienced a hard lockup a few days ago with
I seem to be having problems trying to get to http://www.corereader.com ...
Anyone else?
+--+
| ___ ___ |
| //_/_/_/_/_/ //_/_/_/ |
|//_/ //_/ _/ |
| //_/ //_/
On 3 Oct 2002, at 15:33, Mark Colvin wrote:
The problem I am having is with the DATE_FORMAT. Running the above query
returns the following for the width column.
94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended,
'%d-%m-%Y'): 03-10-2002
Show your PHP code. How
HI all
I'm trying to do the following
---
# want to select (just preparing) every thing from the table PERSON
where i don't know the deptID yet.
Hi!
I believe the following patch fixes the startup problems on Win 95/98/ME in
InnoDB versions which have been released after July 2, 2002.
Looks like Win XP can easily create 40 000 event semaphores, but for
95/98/ME it is too much.
This should be in upcoming MySQL-3.23.53 and MySQL-4.0.5.
hi,
i've downloaded and unpacked both the 3.2.3 and 4.0.4 binaries for solaris. neither
create a var directory, so i create the var directory myself and give mysql ownership
of it. yet when i run mysqld it still won't write the pid file. what gives?
tia,
j
I cannot find a fix for this (only a couple of mentions on upgrading glibc,
i think i have the latest). I get this during make
mkdir .libs
gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHA
REDIR=\/usr/local/share/mysql\ -DUNDEF_
THREADS_HACK -DDONT_USE_RAID -I./../include
On Thu, 03 Oct 2002, Andrew Braithwaite wrote:
Please can you post an explain of this query? As a first guess try:
alter table publicinfo add index location (x,y,class_code);
Nigel
-
Before posting, please check:
hi everyone,
i have just installed mysql.i was able to start the mysqld
process.howeveri am unable to set password for root using the following
command sequence :
./bin/mysqladmin -u root -password 'abcd'
I get the following output :
./bin/mysqladmin: connect to server at 'localhost'
Hi Heikki and all friends,
You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and svr_init()
works well.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Gelu,
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; Puiu Hrenciuc
[EMAIL PROTECTED]; Philip Molter [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 7:48 PM
Subject: Re:
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have
i just tried, and it came right up.
the server is located in the southern u.s., so
perhaps the hurricane is effecting it.
I seem to be having problems trying to get to http://www.corereader.com ...
Anyone else?
+--+
| ___
On Wed, 2002-10-02 at 20:51, mos wrote:
At 09:40 PM 10/2/2002, you wrote:
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
Wayne,
please send me the whole MySQL error log.
Looks like some thread, which had reserved the InnoDB 'kernel' mutex to
access the InnoDB lock table, got stuck.
This is interesting:
5 queries inside InnoDB, 0 queries in queue; main thread: doing background
drop tables
If you drop a table
Hello,
Been using mysql on w2k for a couple years now and never used the DSN ODBC
connection. See a lot of articles (google/archives/etc) on how to use it ..
but none on why. Any particular reason I would even want to use ODBC for a
mysql connection as opposed to just directly connecting to it
Sorry but I'm sure one of you guru's knows about the best software (ltl)
to migrate informix database to Oracle, I need to link then oracle to
MySQL, and then to report via crystal reports.
EJB
-
Before posting, please
Pass Filter: sql,query
- Original Message -
From: William Martell [EMAIL PROTECTED]
To: MySQL Main List [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:48 AM
Subject: Three Tables
Hello All,
I have three tables in my database
t1, t2, and t3. Each table has records that are
Is there a simple way to duplicate one or more rows in a table?
I tried:
INSERT INTO table SELECT * FROM table WHERE criteria
but apparently INSERT...SELECT cannot function on the same table.
- filter fodder, ignore -
sql query (I swear, I'm gonna put that in my .signature soon...
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
I wish there were more examples as well!
I use this for
sql,query
Hello.
Is there an option for the slave server to NOT stop when an error
inducing query is run on the master?
For instance, if someone tries in insert a duplicate entry, and the
master shows the error, but updates the binlog, how can I keep the slave
from seeing the same error, and
sql, query
I have a dilemma and maybe you can help. I'm wanting to improve my disk
performance and I'm wondering if I should go with Raid 10 or if I should
simply mirror the drives so that I have redundancy and then put some of my
tables on one drive and some on the other. Or the
Perl was installed from my RedHat 6.2 install media, I remember a problem
of installing MySQL using the binaries would cause conflicts with a rpm
installed Perl. That is what someone in this newsgroup told me about a year
ago. Is this true?
I couldn't get the MySQL to install with the RPM's.
Hi Arthur,
Thanks for your answer and your example. Your example is very good but I
can't map to what I'm trying to do. As you suggested I have to
understand how inner join is implemented in MySQL. The query that I'm
working on selects fields from three tables, in this way,
Table_1
corereader will help you do a pointclick join of up
to four tables.
you can operate corereader without it, but reading
the documentation is strongly recommended.
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
Once you understand the logic of joins the rest is pretty straightforward,
since in terms of execution the sequence in which you do the joins is
irrelevant. (Performance is another issue, quickly resolved by specifying
the smallest tables first.)
Supposing that you have tables Products,
Josh Trutwin wrote:
SELECT table1.bunch, table2.of, table3.stuff FROM table1
INNER JOIN table2 ON table2.some_id
INNER JOIN table3 ON table3.some_id
WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id;
Your where is sort of in the wrong place ...
SELECT
Yes there are. First do as you have written, although your syntax is a bit
wrong but the email compiler forgives such stuff :-)
SELECT table1.bunch, table2.of, table3.stuff FROM table1
INNER JOIN table2 ON table2.some_id
INNER JOIN table3 ON table3.some_id
WHERE table1.some_id =
Wayne,
the bug found and fixed.
If SHOW INNODB STATUS or innodb_monitor printed several hundred
transactions, and the output was truncated, it forgot to release the
'kernel' mutex, causing the hang.
Also the main thread was hung. That is why it claimed to be doing a
background table drop.
The
Josh Trutwin wrote:
SELECT table1.bunch, table2.of, table3.stuff FROM table1
INNER JOIN table2 ON table2.some_id
INNER JOIN table3 ON table3.some_id
WHERE table1.some_id = table2.some_id AND table1.some_id =
table3.some_id;
Your where is sort of in the wrong place ...
SELECT
James,
- Original Message -
From: James Kelty [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, October 04, 2002 12:13 AM
Subject: Slave server and InnoDB
sql,query
Hello.
Is there an option for the slave server to NOT stop when an error
inducing query is run on
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc,
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED] wrote:
corereader will help you do a pointclick join of up
to four tables.
you can operate corereader without it, but reading
Send me create-table scripts and population scripts and I'll do this for
you. But on rereading your message I'm guessing that your normalization is
wrong. You have more than one multi-valued dependency. Your example
description is either wrong or insufficient.
T1 (presumably the parent of all
Hi,
In my experience (assuming that you are using mysql for all of these
operations) the best way is to separate your tables into read-heavy and
write heavy and put each into separate databases. Put the write-heavy logs
database onto a separate disk/spindle and use delayed inserts (so that the
On Fri, Oct 04, 2002 at 12:51:16AM +0300, Heikki Tuuri wrote:
only successful queries are written to the binlog and replicated. It is a
bug in MySQL replication if a duplicate key error in the master is
propagated to the slave.
Or someone accidentallly muged data on the slave. We've had
We have a 4.0.4-beta master and slave.
The slaving process starts correctly, but randomly (and frequently) has
issues.
When the server starts, it will slave, but eventually will hit one of
two conditions:
- Duplicate key insert error (we re-sync'd the slave by hand during the
install,
Is there an archive of all posts to this mysql list that I can search
somewhere?
Chris Becker
MCDBA MCSE
http://www.PrismSoftware.com
[EMAIL PROTECTED] sql
-
Before posting, please check:
http://www.mysql.com/manual.php
Yep, It's here
http://www.mysql.com/documentation/searchlists.html
Cheers,
Andrew
Sql,query
-Original Message-
From: Chris Becker [mailto:[EMAIL PROTECTED]]
Sent: Friday, 04 October 2002 00:43
To: [EMAIL PROTECTED]
Subject: Archive of this mysql list
Is there an archive of
Ahem, have a look at the bottom of any post to the list:
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
:)
HTH,
William.
-Original Message-
From: Chris Becker [mailto:[EMAIL PROTECTED]]
Sent:
Hello All;
I am having a problem using the mysqldump application. I have an old server
that I am trying to move to a faster machine. No matter what I do, about 90
queries in the connection ceases and the old meachine gets a server has gone
away error. I have tries runnig mysql dump piped to the
Hi,
Some of the old mysqldump apps have a bug where they're missing quotes on
long rows. Try the dump the other way - i.e. use the mysqldump client on
the new machine and pipe it from the old machine back to the new machine
(make sure the new machine has permissions to grab from the old
Hi,
Where is the Mysql-server version. you have installed
only client and mysql-max, but no mysql-server. Use
rpm -Uvh for your installations, so that you can
easily know the progress of installation.
regards,
Praveen
--- Chris Becker [EMAIL PROTECTED] wrote:
RedHat6.2 install (everything)
well - I can't telnet to that port, but I have a web server up running,
and I cannot telnet to port 80 either, but my web browser does work. I am
also connecting to it on port 3306 locally.
- Original Message -
From: Jeremy Tinley [EMAIL PROTECTED]
To: 'Jeff Bluemel' [EMAIL PROTECTED]
Hi Mike,
I hope you are on linux machine, What are versions on
old and new machines, is there any difference?.
just tar the data dir /var/lib/mysql (in most of the
cases) and untar on the new machines by moving the
existing mysql directory by this old data.
I don't think this will fail, I have
Thanks Praveen,
So Max is not a server version, it sure is difficult to determine that on
the download page:
MySQL database server standard clients:
· MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52
· · 3.23 -- Default package (use this if you are
I have a table with millions of records, lots of fields, and lots of
indexes. It appears I break every rule for table efficiency...but there is a
reason! I needed to do summarized data on *lots* of the fields at once, and
the savings in time simplicity far outweigh any performance hits I may
I did it again!!!
-- Forwarded Message --
Subject: Re: OT: Reply-Adress in this list
Date: Fri, 4 Oct 2002 10:31:28 +0800
From: Niclas Hedhman [EMAIL PROTECTED]
To: Dan Nelson [EMAIL PROTECTED]
On Thursday 03 October 2002 22:23, Dan Nelson wrote:
In the last episode (Oct
On Thursday 03 October 2002 22:33, Michael T. Babcock wrote:
Franz Alt wrote:
From one site: Reply-To munging does not benefit the user with a
reasonable mailer. People want to munge Reply-To headers to make ``reply
back to the list'' easy. But it already is easy. Reasonable mail
programs
If I have a table,
Name VARCHAR(100)
L DOUBLE
a DOUBLE
b DOUBLE
and execute the incredible
SELECT * FROM Colors WHERE
SQRT(
SQ(
ABS( L - 45.5 )
) +
SQ(
ABS( a - 13.2 )
) +
SQ(
ABS( b + 23.4 )
)
) 2.5 ;
Could MySQL benefit in any way by indexing the
Max is a server.
your install directory out of an RPM should be /var/lib/mysql if you are
root su to root and see if it's there. It should tell you this in
/usr/share/doc/packages/Mysql
thwere's a manual there or it should be.
John Coder
On Thu, 2002-10-03 at 21:55, Chris Becker wrote:
At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
If I have a table,
Name VARCHAR(100)
L DOUBLE
a DOUBLE
b DOUBLE
and execute the incredible
SELECT * FROM Colors WHERE
SQRT(
SQ(
ABS( L - 45.5 )
) +
SQ(
ABS( a - 13.2 )
) +
SQ(
ABS( b + 23.4 )
)
) 2.5 ;
Could
Your right - Max is a server, thank you.
Directories you listed do not exist. That rpm is all honked up. Is there an
UN-install flag for rpm? I would like to cleanly reverse what was done w/
the rpm and install from the binary, is this possible? The workaround
provided below does not seem
I don't by the less functionality argument any more than if
you have a good
emailer. I think I have a good emailer, and on the munging
lists, I press
Reply-All, it will also send to the original author, but 95% of
the case I
want the list, and original author doesn't want two replies.
Hi, I am trying to use mysqldump to dump the structure of a single database
and want the output to make create table commands that include the IF NOT
EXISTS switch so that when the file is imported into an existing database it
does not write over tables with the same name. Does anyone know if
On Thu, 2002-10-03 at 23:26, Chris Becker wrote:
Your right - Max is a server, thank you.
Directories you listed do not exist. That rpm is all honked up. Is there an
UN-install flag for rpm? I would like to cleanly reverse what was done w/
the rpm and install from the binary, is this
hi all:
i am attempting to connect to a mysql database from php, using the following
syntax in the php:
$dsn = mysql://webuser@localhost/doug ;
$db = DB::connect( $dsn ) ;
if ( DB::isError($db) )
{
print $dsn.\n ;
die( $db-getMessage().\n ) ;
}
i get this message:
How would one go about changing the key block size for a
table/database/server? As I understand it, key blocks are 1024 bytes (1k)
by default. I am creating an ext2 partition with 16k blocks for a database
with tens of millions of records and would like to optimize the key block
size to the fs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 12:17 AM
To: Dragos Madalin Popa
Subject: Re: RE: how can I turn on query log on Windows? (mysql-3.23.38)
Your message cannot be posted because it appears to be either spam or
simply
On Friday 04 October 2002 11:04, Paul DuBois wrote:
At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
If I have a table,
Name VARCHAR(100)
L DOUBLE
a DOUBLE
b DOUBLE
and execute the incredible
SELECT * FROM Colors WHERE
SQRT(
SQ(
ABS( L - 45.5 )
) +
SQ(
ABS( a
People,
I'm running a postfix server with mysql on a FreeBSD machine. This mail
server holds about 500 virtual domains and 6000 virtual accounts.
Using the command mysql -e show processlist;|wc -l I get the current
amount of mysql conns. It floats at about 150-200 simultaneous
connections on
100 matches
Mail list logo