user lists.
There you go again, being needlessly rude to a comment that while off
topic, was politely phrased, and not at all rude.
> > Thanks to all.
> >
> You are welcome
>
> > Richard
> >
> > SQL
> >
> KayambooSuresh
>
>
Price.
MySQL == Free
Oracle ==
On Thu, 2002-08-15 at 20:25, Elizabeth Bogner wrote:
>
> A company I work with is in the process of upgrading its databases from
> some
> motheaten system to something current. My impression is that they
> want to go with Oracle, and I'm not sure if this
ues in
the columns that come /before/ the AutoIncrement column in the index.
Hope this helps someone. I know it's going to help me significantly.
Matthew Walker
-
Before posting, please check:
http://www.mysql.com/ma
/love/ that
behavior, and think it should be a feature, but before I go further, I
need to know if I can count on it to hang around. And if it is a
feature, why it doesn't work in three column indexes.
Please CC the reply-to address in your responses.
Thanks for your time,
Matt
I need help optimizing the query below. I've included the query, the
table declerations, and the output of explain. Any help would be greatly
appreciated.
What I'd really like is to find out how to get it to use a key on the
lineitems table. I've tried adding indexes on the OrderID and MerchantID
sql,query
I have a table with the following structure:
CREATE TABLE cartconfig_module (
UserID int(10) unsigned NOT NULL default '0',
GroupID int(10) unsigned NOT NULL default '0',
SiteID int(10) unsigned NOT NULL default '0',
Perms enum('Modify','View','Deny') NOT NULL default 'View',
Interesting idea, Andrew. I don't know how to do what you're asking for,
but I'd be interested to see it added too. I'd never heard of geometric
means, but I can already think of several areas where they might be
useful. Thanks for sharing the information on how they
I have to say that I disagree. It would be a very good idea to recompile
the kernel, to get rid of all the fancy sound and graphics options. The
smaller your kernel, the better. Also, you might want to look at the
Preemptive patch for the kernel, to help improve performance further.
Matthew
Wrong. Windows uses \ for their paths, so MySQL should use the same
thing.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Bob Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:59 PM
To: 'ali hafiz'; [EMAIL PROTECTED]; [EMAIL
sql,query
Regardless of what you might call it, Overhead is what phpMyAdmin calls
it.
Matthew Walker
Senior Software Engineer
ePliant Marketing
=20
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]=20
Sent: Wednesday, April 17, 2002 3:16 PM
To: Matthew Walker
Overhead is 'wasted' space in the table. It happens if a table has
variable length rows, and you delete one in the middle of the table. To
fix it, OPTIMIZE the table occasionally.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Soheil
*light goes on* You know, I think I've been confused about that. Thanks
for clearing things up. I for some reason didn't make the connection (no
pun intended) that each page would be getting it's own connection to the
DB, and so couldn't interfere with the last_insert_ID quer
MySQL is the 'standard' MySQL. MySQL-Max include high end features, for
big systems. Things like InnoDB, for one. Stuff that the average user
might not want.
So, essentially, it just tells you what features are in that release.
Matthew Walker
Senior Software Engineer
ePliant
Actually, with a pconnect, there would be a trade off. Since it uses a
shared connection, the last insert ID could change between the update
and calling the api function. But as I said, it doesn't matter for the
counter.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Ori
ead
doesn't have the value you just set in the update.)
As far as performance goes, my PHP app can do 40+ queries in less that
.05 seconds. So you shouldn't have problems there.
Good luck!
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From:
Did you FLUSH the permissions? (aka, reload the server, in phpMyAdmin)
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Mark Roberts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 5:31 PM
To: [EMAIL PROTECTED]
Subject: Question about grants
I just went in looked at mySQLMan, and I must say, I'm not very
impressed with it. If you like that package, you should really try out
phpMyAdmin. You can download it at http://phpmyadmin.sourceforge.net.
It's completely free, quite secure, and very easy to use.
Matthew Walker
Ecommer
As to your second question, I'd /highly/ recommend
http://phpwizard.net/projects/phpMyAdmin/. I use it to manage all the
databases where I work, and have had very few problems with it.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Kory Whe
?
Filter: mysql
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002
I've been poking around some more online, and I've found a very nice
session module, that can easily be expanded to handle user logins. Check
it out at http://www.php.lt/sqlsession/
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-----
From: Matt
I have, but I'd rather not reinvent the wheel if I don't have to, though
I'm almost to the point where I'm going to need to.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Frid
The problem with that is, it doesn't allow logout.
Siulun, if you /do/ find some good sample code, clue me in. I'm in the
market myself. I'm using apache's basic auth right now, but I need to
add logout support.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-
Hmmm. Wonder if this would be why MySQL-Max failed to install on my new
Penguin Computing server... It's running RH7.1
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002
Actually, upgrading the kernel is /not/ hard. Simply follow the
instructions in the INSTALL file inside the tarball. Many people have a
fear of doing this, but if you read the instructions, and know your
machine, it's a simple matter.
Matthew Walker
Ecommerce Project Manager
Mountain Top
You /can/, but it may not work. SuSE uses a slightly different directory
structure, and RedHat RPMs may get confused. If at all possible, use
SuSE provided packages.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Victoria Reznichenko [mailto
other
packages on it. Oh, and SETI@Home, to burn in the processors. ;)
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 9:32 AM
To: [EMAIL PROTECTED]
Subject: My
This would fail dramatically. The squareroot of a negative number is not
a real number.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith A. Calaman [mailto:[EMAIL PROTECTED]]=20
Sent: Monday, February 11, 2002 5:24 PM
To: David Mackay; '
ing the mysql
client what DB to send the data too.
Done. And all without adding any lines. Maybe this will help someone
else in the future who is in the same situation.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTEC
This would fail dramatically. The squareroot of a negative number is not
a real number.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith A. Calaman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 5:24 PM
To: David Mackay; '
SELECT * FROM Table WHERE Fruit LIKE "banana%"
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:56 PM
To: Mysql List (E-mail)
Subject: LIKE work around??
I am
I ended up using head and tail to split it into 2 files, so that I
didn't have to edit it. See, it was the output of a mysqldump from two
databases, and I needed to make sure each part went where it needed to
go.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Me
I need to find a text editor for Linux that doesnt load the whole file
into memory. I need to edit a 1.5 gig text flatfile to add two lines.
But I dont have enough ram to open it in most programs. Can anyone
recommend something?
Filter: sql,query
Matthew Walker
Ecommerce Project Manager
Personally, I just run it whenever I delete any large quantity of rows.
You could run it once a week, or day, or whatever. Up to you.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January
To get rid of overhead, run an OPTIMIZE TABLE on the table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Mark Stringham [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:02 AM
To: Scott Wang; [EMAIL PROTECTED]
Subject: Re: Lost Data
SELECT schdays FROM courses WHERE (schdays LIKE "M") OR (schdays LIKE
"W") OR (schdays LIKE "F")
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Douglas Brantz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 200
You can only do this while compiling it from source.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Chetan Lavti [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 9:11 PM
To: [EMAIL PROTECTED]
Subject: InnoDB help !!
hi,
I have downloaded
Use YaST to edit your configuration file. Scroll down to 'start_mysql',
and set it to 'yes'. Hit F10, and wait while it reconfigures things.
Enjoy.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Samy Elashmawy [mailto:[EMA
I'd recommend decimal(10,2), myself.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 5:57 PM
To: Shankar Unni
Cc: [EMAIL PROTECTED]
Subject: Re: most appropriate
ed on that table.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 2:02 PM
To: Matthew Walker; [EMAIL PROTECTED]
Subject: RE: MySQL Checkbox table field
At 14:04 -0700 1/25/02, Ma
This brings to mind a question I've had for a while. Is there any way to
automatically build and update an enum based on another very simple (1
column) table?
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: James E. Hicks III [mailto:[
y key conflicts if the servers should ever lose touch
with eachother for a while.
We're looking at InnoDB, and wondering if it would be able to resolve
those sorts of issues using transactions.
Input please?
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is
Use decimal(10,2) for fields that will contain monetary values. If you
use a float it will round the values, while decimal won't.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Keith W [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002
#x27;,
Type varchar(255) NOT NULL default 'Customer',
Memo varchar(255) NOT NULL default '',
PRIMARY KEY (ID),
FULLTEXT KEY Name (FirstName,LastName)
) TYPE=MyISAM;
Query:
SELECT * FROM Customers WHERE MATCH (FirstName,LastName) AGAINST
('walker')
Matt
That won't work. The connection is being made through the PEAR DB class,
so the standard PHP functions won't work. (And yes, I did just test it.)
-Original Message-
From: rc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 1:58 PM
To: Matthew Walker
Cc: [EMAIL
";
$dbhandle->query("LOCK TABLES Orders WRITE");
$dbhandle->query($query);
$res = $dbhandle->query("select last_insert_id()");
$dbhandle->query("UNLOCK TABLES");
$result = $res->fetchRow();
return $OrderID = $result[0];
} else {
Sounds to me like the database was possibly created on a different
architecture, so the DB files are incompatible. Only way /I/ know of
(Warning: I Am Not A MySQL Guru) to transfer the DBs reliably is to dump
the DB to a flat text file on one platform, and then import it back into
MySQL on the oth
How would I go about turning them off? Yes, I know. Another RTFM
question, but some of these things are a little hard to find in the
online manual.
-Original Message-
From: Matthew Simpson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 1:47 PM
To: Matthew Walker
Cc: [EMAIL
about?
--
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18
OTECTED]]
Sent: Wednesday, August 29, 2001 1:00 PM
To: Joshua J. Kugler
Cc: David Turner; Matthew Walker; MySQL Mailling List
Subject: Re: Hot Backups
Didn't read your last item before I fired my last message off. If
mysqldump locks the
table before it dumps then it is interupting servi
is setting up another server that I
> replicated to and backing that server up. I would like to hear how
other
> people are backing up servers without interupting service.
>
> Dave
>
> On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> > What's the bes
What's the best way of doing a hot backup on a database? Our server is
set up in such a way that it's not a simple matter to shut down
apache/mysql and do the backup then. So, is it safe to just copy the
mysql directories, or is there some recommended procedure for this?
Matthew Wal
51 matches
Mail list logo