Run a program behind a password protected area on the secure server. Have
the program dump the data as a delimited text file and import it. Your
using SSL to protect both the access (username and passsword) and the
data this way. If you want to use pgp, dump to file and encrypt and then
On Sat, 13 Jan 2001, John Hinsley wrote:
Date: Sat, 13 Jan 2001 17:12:05 +
From: John Hinsley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: choose a free databse management
Danny [EMAIL PROTECTED] wrote:
There are mnay free RDBMS around
On Tue, 30 Jan 2001, Sam Wong wrote:
Date: Tue, 30 Jan 2001 19:32:05 +0800
From: Sam Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: MySQL Tables over Multiple Drives
Yes, you've to recreate the tables with RAID option (read the manual for
details)
and move and link the
this came up on the lists a while ago. Asked our sysadmin to answer it
so it took a while sorry.
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-- Forwarded message --
Date: Mon, 5 Feb 2001 11:26:57 -0800
From: Michael J.
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
Date: Mon, 5 Feb 2001 13:11:51 -0800
From: [EMAIL PROTECTED]
To: Gus Constan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Port 3306
Add --skip-networking to your my.cnf file or pass it on the command line to
safe_mysqld. This will
On Wed, 7 Feb 2001, CT Chang wrote:
Date: Wed, 7 Feb 2001 17:14:28 +0800
From: CT Chang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql in Win2K
Hi there,
I have just upgraded my Win98SE to Win2K and ever since, I could not =
start Mysqld or Mysqld-nt (with or without the
On Thu, 8 Feb 2001, Quickling wrote:
Date: Thu, 08 Feb 2001 17:02:59 -0500
From: Quickling [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL vs Access; you'd *think* the choice is obvious...
Hi,
Question 2:
---
Is there any way in MySQL to compute, inline SQL, the
drop table...
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
Date: Tue, 13 Feb 2001 14:01:48 -0800
From: Crystal D. Silver [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help please?
Hi,
My host gives me a MySQL database, and I've had no trouble getting purchased
cgi scripts to
On Wed, 14 Feb 2001, Sinisa Milivojevic wrote:
Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET)
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: auto_increment problem with mysql 3.23.32
snip..
Hi!
The above is actually documented
Ran into an interesting twist on "presence" in a state. One client went
to a trade show in Nevada. She was informed that for the next quarter
she would have to consider herself "in" Nevada, even though she did not
sell anyting at the show. I don't think she is going back.
On Thu, 15 Feb
Had similar problem, get the current version of the driver.
On Fri, 16 Feb 2001, Chen Ka Pong wrote:
Date: Fri, 16 Feb 2001 20:29:27 +0800
From: Chen Ka Pong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: JDBC question?
I cannot use the jdbc connection which the driver is download
db2 is limited to 255.
On Fri, 16 Feb 2001, Eric Frazier wrote:
Date: Fri, 16 Feb 2001 14:13:00 -0800
From: Eric Frazier [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: varchar and sql92
Hi,
I am writing a program to do queries on a lot of different databases. I have
run into
Floats are inexact. If you want exact try the numeric data type. Its
stored as a character.
On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote:
Date: Sat, 17 Feb 2001 21:05:25 -0700
From: Xi Jiang (ITSPORTSNET) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: float value is changed
Also, specifying fields won't break things when people add fields to a
table.
On Wed, 21 Feb 2001, Cal Evans wrote:
Date: Wed, 21 Feb 2001 11:07:36 -0600
From: Cal Evans [EMAIL PROTECTED]
To: Jason Landry [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Future suggestion
Hey HEY!
RE ReiserFS
What is the hardware (32 bit or 64) and what is the maximum files size
MySql will support on it? Thanks.
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-
What about varchar binary?
On Thu, 22 Feb 2001, Johnny Withers wrote:
Date: Thu, 22 Feb 2001 13:35:44 -0600
From: Johnny Withers [EMAIL PROTECTED]
To: Chris [EMAIL PROTECTED], mysql [EMAIL PROTECTED]
Subject: RE: Fields
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
base64 encode the
Your reply triggered a question?
If you are on a win32 box and using the binary builds, what is the
proceure for getting these patchs? Last time I checked the site is was
still showing 3.23.33 as the current release?
On Fri, 23 Feb 2001, Sasha Pachev wrote:
...
Just realized that a while
Check under ulimit to raise the number of file descriptors.
ulimit -n #
Linux has a global limit (4096 in debian' case) which may also be
raised. However, as someone else has recommended, look at shortening
the time you are actually connected. Connect, get data, disconnect,
process
: Thimble Smith [EMAIL PROTECTED]
To: "William R. Mussatto" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Patching w/o the compiler was Re: Replication time patch
On Fri, Feb 23, 2001 at 03:35:06PM -0800, William R. Mussatto wrote:
Your reply triggered
On Tue, 6 Mar 2001, Kevin Connolly wrote:
Date: Tue, 6 Mar 2001 18:15:17 - From: Kevin Connolly
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: file insertion?
Hi, Is it possible to insert a file into the MySQL database? I want a table
= with certain entries such as name, address
If you are using a current "activestate" release it should be included,
if not use their package manager.
On Wed, 7 Mar 2001 [EMAIL PROTECTED] wrote:
Date: Wed, 7 Mar 2001 15:59:36 GMT
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DBI for Windows
Dear Sirs:
Please can you
If you block user access during the recovery, would it be faster w/o the
indexes and then add the indexes through alter table and then let the
user's in. This is the recommended solution for recovery for DB2. If you
have to do a recovery, its normally assumed that the database is locked
for
Have you checked on the ulimit for the user that is mysql?
On Sat, 2 Feb 2002, Dan Nelson wrote:
Date: Sat, 2 Feb 2002 20:58:07 -0600
From: Dan Nelson [EMAIL PROTECTED]
To: Randy Arabie [EMAIL PROTECTED]
Cc: Manuel Bouyer [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
On Mon, 4 Feb 2002, Randy Arabie wrote:
Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST)
From: Randy Arabie [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: Dan Nelson [EMAIL PROTECTED],
Manuel Bouyer [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re
Had a similar problem a few years back. System worked fine for a number
of months then started crashing whenever I recompiled the kernel. Turned
out to be a defective secondary cache (yes it was a Pentium and yes it
was a number of years ago). Showed up only under heavy cpu load. Try
You, like me, are using 3.22 which does not have the myisam table type
(or others for that matter). ISAM I believe, has a lower limit. They do
support sizes less that 4GB (up to the OS file size limits). The three
file extentions total do constitute the total table size, but I believe
that
Fromt the mysql.com site: http://www.mysql.com/doc/I/S/ISAM.html
for all the limits.. Remember that your files sizes may be smaller
because of your OS.
On Fri, 22 Feb 2002, Brian Warn wrote:
Date: Fri, 22 Feb 2002 09:11:07 -0800
From: Brian Warn [EMAIL PROTECTED]
To: 'Gurhan Ozen' [EMAIL
Ok this works on myisam tables, but what about InnoDB
On Fri, 22 Mar 2002, Egor Egorov wrote:
Date: Fri, 22 Mar 2002 15:38:03 +0200
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Optimizing tables
Vijay,
Friday, March 22, 2002, 1:14:33 PM, you wrote:
V how do i
On Tue, 26 Mar 2002 [EMAIL PROTECTED] wrote:
Date: Tue, 26 Mar 2002 16:39:05 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Report to Recipient(s)
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 26 Mar 2002
I thought the 4.0 series was still Beta?
On Mon, 1 Apr 2002, Heikki Tuuri wrote:
Date: Mon, 1 Apr 2002 18:09:53 +0300
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: mysql innodb error
Kannan,
please upgrade to 3.23.49a or 4.0.1.
101 used to mean lock
On Sun, 29 Sep 2002, Insanely Great wrote:
Date: Sun, 29 Sep 2002 22:43:43 +0530
From: Insanely Great [EMAIL PROTECTED]
To: Ibrahim Al-Tawil [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Urgent!!
Greetings...
I believe that ASP works well with MySQL thru ODBC. As of learning other
On Mon, 30 Sep 2002, Drulli B wrote:
Date: Mon, 30 Sep 2002 18:13:51 -
From: Drulli B [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mixing Linux and Windows and paying for it
Hi,
I have a grand total of two very important but possibly humiliatingly daft
questions, that I hope
On Sun, 6 Oct 2002, David Gerler wrote:
Date: Sun, 6 Oct 2002 14:21:11 -0400
From: David Gerler [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Subject: protecting CC numbers
Hi,
I am working on an application that will need to store users CC
numbers so that they can be charge once
On Thu, 10 Oct 2002, Anil Garg wrote:
Date: Thu, 10 Oct 2002 13:38:52 -0400
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: users who can access a database
hi,
Please checkout the GRANT command. In earlier versions of mysql you had
to put information into the
On Tue, 5 Nov 2002, Alan McDonald wrote:
Date: Tue, 5 Nov 2002 18:49:22 +1100
From: Alan McDonald [EMAIL PROTECTED]
To: Eric Frazier [EMAIL PROTECTED], Paul DuBois [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Removal of Primary Key in Mysql
Because a primary key is a table
On Sun, 1 Dec 2002, David T-G wrote:
Date: Sun, 1 Dec 2002 18:42:03 -0500
From: David T-G [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Subject: protecting ccard numbers
One way would be to encode the credit card number field using data from
an external file for the key and then
Minor change, I think it should be a datetime field not a timestamp field
since timestamps are supposed to be updated by the database.
On Fri, 26 Apr 2002 [EMAIL PROTECTED] wrote:
Date: Fri, 26 Apr 2002 17:16:06 +0100
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
On Tue, 7 May 2002, George Pitcher wrote:
Date: Tue, 7 May 2002 06:15:28 +0100
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: JDBC connection to MySQL
Just a guess, but how about an ampersand?
Connection c =
On Fri, 14 Jun 2002, Francisco Reinaldo wrote:
Date: Fri, 14 Jun 2002 12:52:15 -0700 (PDT)
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Steve Edberg [EMAIL PROTECTED], Vandana [EMAIL PROTECTED]
Cc: Jay Blanchard [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: RE: Is the order same?
On Fri, 14 Jun 2002, Peak Digital Productions wrote:
Date: Fri, 14 Jun 2002 16:33:05 -0600
From: Peak Digital Productions [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: alter column without dropping
The data going into one of my mySQL columns has suddenly changed, so I need
to
change
Don't forget to include the intermediate software to cache connections
since it takes so long to make an oracle connection.
On Thu, 16 Aug 2001, Robinson, Mike wrote:
Date: Thu, 16 Aug 2001 11:03:21 -0400
From: Robinson, Mike [EMAIL PROTECTED]
To: 'Boget, Chris' [EMAIL PROTECTED],
On Sat, 18 Aug 2001, Ram wrote:
Date: Sat, 18 Aug 2001 06:16:39 -0700 (PDT)
From: Ram [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Problem with nested delete - help
Hi,
I have a problem with nested delete query. I want to
delete some record from one table based on the select
What about a number field w/zero fill?
On Thu, 30 Aug 2001, Adams, Bill TQO wrote:
Date: Thu, 30 Aug 2001 08:48:11 -0700
From: Adams, Bill TQO [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: order by number
If the column is an int then it will order it
On Fri, 7 Sep 2001, Cal Evans wrote:
Date: Fri, 7 Sep 2001 11:05:27 -0500
From: Cal Evans [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp [EMAIL PROTECTED]
Subject: Re: Let's approach stored procedures
Ed,
Stored procedures allow you to pre-compile and re-use code
Glad to hear this. I was already going that way with my site because I
didn't want to have to either drop and reload the database or take ther
mysql server down to run the cleanup utility. W/o blobs/text you can use
fixed length fields which means the database doesn't become fragmented.
On
Slight error here if you want the auto icrement field to work properly
On Wed, 3 Oct 2001, Chris Johnson wrote:
Date: Wed, 3 Oct 2001 20:07:49 -0500
From: Chris Johnson [EMAIL PROTECTED]
To: Russell Miller [EMAIL PROTECTED], sjs [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: very
I realize this is not the current version, but debian stable is stuck on:
3.22.32.
mysqld does not start when I enter
max_connections 200
although it reports max_connections 100
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
probably missing something
basic but...
On 30 Oct 2001, Tonu Samuel wrote:
Date: 30 Oct 2001 21:21:32 +0200
From: Tonu Samuel [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Can't set max_connections on debian version
On Tue, 2001-10-30 at 20:53
thanks, I finnally figured out how to set it on the command line and
modified safe_mysql script to do it. Thanks
On Wed, 31 Oct 2001, Wouter de Jong wrote:
Date: Wed, 31 Oct 2001 09:19:14 +0100
From: Wouter de Jong [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL
I have had to do this problem and i solved it by having 4 fields,
Normalprice (PrPrice),
Tempprice (PrTempPrice),
Start date (PrStart)
End Date (PrStop).
In the select
IF(((CURDATE() = PRStart) and (PRStop = CURDATE())),
PrTempPrice, PrPrice) as CurrentPrice
hope this helps
On Thu, 1 Nov
Thanks, got it.
On Wed, 31 Oct 2001, Wouter de Jong wrote:
Date: Wed, 31 Oct 2001 09:19:14 +0100
From: Wouter de Jong [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Can't set max_connections on debian version
On Tue, Oct 30, 2001 at 11:31
On Fri, 9 Nov 2001, Carl Troein wrote:
Date: Fri, 09 Nov 2001 15:41:21 GMT
From: Carl Troein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Beginner question - getting last inserted ID
Anna Ã…hnberg writes:
Thanks, I actually already found the chapters but now I also now how to
Apache supports running cgi scripts as a designated user on a virtual
host basis (only key is the files can be writable by ONLY the USER not
his GROUP (toe badly stubbed making this mistake). However, why doesn't
the isp create a separate mysql user for each client's database and
restrict
On Mon, 12 Nov 2001, Heikki Tuuri wrote:
Date: Mon, 12 Nov 2001 09:06:42 +0200
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Cannot add blob data to innodb table
Steve,
Date: Mon, 12 Nov 2001 08:52:54
To: [EMAIL PROTECTED]
From: Heikki Tuuri [EMAIL
each can create a
TEMPORARY table with the same name. Only the table created by a given
client is visible to that client.
I use MySQL 4.0.7 on Red Hat.
Thanks,
Mamatha
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
see why they have to be FIRST! Ugh.
Major performance hit would be a guess. Otherwise the database would have
to do a table scan. Think about how it would find the related record. I
think is a requirement of db2 as well
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX
, or blob type field then MySQL silently
converts all character fields longer than one character to varchar. This
may be why you see it sometimes converting the fields.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
and the image on the disk? Only case where
this would be a problem would be if the numbers of images were so large
that the file look up mechanism of the file system began to be a factor.
In cases like that I use a tree of subdirectories tied to something like
ISBM number.
William R. Mussatto, Senior
We run Tomcat4. Currently we are using the older mm- drivers. Is there
anyway to move to connector /J one context at a time rather than all at
once?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
users.username='sator')
Susan Ator
Online Services Engineer
National Public Radio
Distribution Division
[EMAIL PROTECTED]
Short answer is mysql does not do sub-selects (i.e., a select inside of a
select). The join part is not this issue.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154
- Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
I sit corrected, 4.1x but its alpha from the manual:
Subqueries are supported in MySQL version 4.1.
I run a production IPP so we run debian with is very far BACK from the
bleeding edge.
William R. Mussatto, Senior Systems
this in the past. For speed recommend user_id's in
all tables be indexed. Obviously replace 'WHATEVER' with the userID
value.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
there not that a new one had been substituted.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Somehow you are still using the older org.gjt.mm.mysql drivers not
connector/J. When I asked many moons ago I was told that they could not
both be used at the same time by Tomcat even in separate contexts, but
YMMV.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608
.
--
This is a x86 (32 bit) chip. It may or may not have 'hyperthreading'
where it can act as two processors.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm wrong). So, unless you
have a spare in the back you will end up replacing 3 drives (assuming Raid
5). That may be why the WD model has such low capacity compared with the
normal IDE drives.
Just my 2 cents worth.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909
=
DriverManager.getConnection(this.DBUrl,this.dbuser,this.dbpasswd);
}
catch (Exception e) {
e.printStackTrace();
}
Hope this helps..
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
?
Anyone done this?
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and Time
values.
c. something else entirely.
Also, are you running this in a procedureal language (e.g., perl, java)?
This will give us other options.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
solution to this I noticed that
you have a separate date and time field. Is there a reason for this. It
would be easier to get single row for each sessionID if they were one
field. Otherwise I think you will have to go with the method Peter
proposed above.
William R. Mussatto, Senior Systems
tea.. ok how about this:
select sessionID,max(concat(idate,' ',itime)) from test group by sessionID
Note I thought date and time were reserved so I substituted..
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
use the datetime field type since you will
simplify sorting and conditionals.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
/ noXtension
You mean they have solved the problem of having to used matched CPU's.
Used to be that you had to throw out the old CPU's and get all new.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
it with mysqladmin
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ON h.serverid = s.serverid
WHERE h.employeeid = 9
ORDER BY h.historyid DESC
Works fine once I remove the TOP 20 from the query. If this isn't
supported, is there an equivalent?
Thanks,
Jim
remove TOP 20 from front, add 'limit 20' to back.
William R. Mussatto, Senior Systems Engineer
Ph. 909
On Thu, 27 Jun 2002, jason wesley upton wrote:
Date: Thu, 27 Jun 2002 14:05:34 -0500
From: jason wesley upton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MySQL Question involving AUTO INCREMENT and PRIMARY IDs. - sql
EXPLANATION:
here's the pertinent piece of my sql create
Does your server support .jsp pages?
Does your version of dreamweaver support editing .jsp pages?
If yes to both questions, you can install a copy of MySql on your
development box and develop there and move the pages up when you are
ready to go live. Make sure both databases have the same
Just a quick question. Why are you not running DBD::Mysql directly? It
should eliminate the ODBC layer and help with speed.
On Thu, 18 Jul 2002, Christopher A. Libby wrote:
Date: Thu, 18 Jul 2002 08:22:33 -0400
From: Christopher A. Libby [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:
On Wed, 24 Jul 2002, Dermot Paikkos wrote:
Date: Wed, 24 Jul 2002 17:46:00 +0100
From: Dermot Paikkos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: how to update time field with current time?
Hi
Probably a silly question but how can I set a time field to the current
time with update
Pardon my ignorance, what Linux table corruption and what versions of
Linux and MySQL are we talking about? I googled, but came back only with
4.4.6.7 Using myisamchk for Crash Recovery ... --skip-external-locking.
Not much help. I'm sorry if this is old news, but I thougth I was
following
Is the MySQL serving a web site? If yes, wrap show processlist in perl
or php and have it generate an auto refreshing page.
On Thu, 15 Aug 2002, Tab Alleman wrote:
Date: Thu, 15 Aug 2002 11:01:44 -0400
From: Tab Alleman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: View current
Can connector/J coexist with mm.mysql on the same tomcat? I'd like to
upgrade one site at a time rather than then all the sites at once.
On Wed, 28 Aug 2002, Mark Matthews wrote:
Date: Wed, 28 Aug 2002 08:59:33 -0500
From: Mark Matthews [EMAIL PROTECTED]
To: neal [EMAIL PROTECTED]
Cc:
This might explain how I lost my secondary IDE controller. I just
unistalled SP3 to resolve my issue.
On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote:
Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST)
From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= [EMAIL PROTECTED]
To: Marc Hus [EMAIL
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
Date: Fri, 30 Aug 2002 12:36:28 -0500
From: Jeremy Tinley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Tape backups from live slave
Howdy,
Before I run off and try it, can anyone offer up any problems with doing
a LOCK TABLES, FLUSH TABLES
. I'd rather spend an hour restoring
from tape and let replication catch me up.
-J
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 1:57 PM
To: Jeremy Tinley
Cc: [EMAIL PROTECTED]
Subject: Re: Tape backups from live slave
I've used dbtools http://www.dbtools.com.br/ However I'm using 1.0.12
rather than 1.0.15 since the newer version appears to have a few bugs.
there is of cours mysqlgui from mysql (see their site).
On Wed, 11 Sep 2002, =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= wrote:
Date: Wed, 11 Sep 2002
On Fri, 16 Nov 2001 [EMAIL PROTECTED] wrote:
Date: Fri, 16 Nov 2001 11:40:06 + (GMT)
From: [EMAIL PROTECTED]
To: Rick Robinson [EMAIL PROTECTED]
Cc: Mysql \\(E-mail\\) [EMAIL PROTECTED]
Subject: Re: What maintenance is needed for MyISAM tables?
On Thu, 15 Nov 2001, Rick Robinson
On Tue, 20 Nov 2001, Ken Kinder wrote:
Date: Tue, 20 Nov 2001 08:41:20 -0700
From: Ken Kinder [EMAIL PROTECTED]
To: Thomas Kotze` [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL and encryption
I would like to know if anyone has some advice on encrypting credit cards
myself, as
If you want to be able to store information encrypted and then decrypt it
later and you use perl see Crypt::CBC and pick an algorythim. The only
trick is that, with blowfish at least, you need a larger field than the
original. Also you must figure out how to hide the key...
On Wed, 12 Dec
On Wed, 19 Dec 2001, Matt Wagner wrote:
Date: Wed, 19 Dec 2001 13:51:30 -0600 (CST)
From: Matt Wagner [EMAIL PROTECTED]
To: Zach Curtis [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Decrypting PASSWORD() from MySQL
Zach Curtis writes:
I have a form for a user to request their
On Fri, 25 Jan 2002, Rahadul Kabir wrote:
Date: Fri, 25 Jan 2002 12:40:35 -0500
From: Rahadul Kabir [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to install JDBC driver!
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
On Thu, 31 Jan 2002, DL Neil wrote:
...
What should be understood is that MySQL's implementation of AUTO_INCREMENT requires
a particular/different
philosophical view: that first the 'primary row' is to be stored, then the
AUTO_INCREMENT data captured, and
finally the dependent row is
On Wed, 30 Jan 2002, Marjolein Katsma wrote:
Date: Wed, 30 Jan 2002 12:33:29 +0100
From: Marjolein Katsma [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Subject: RE: Urgent Business Assistance.
At 03:52 2002-01-30, Todd Williamsen wrote:
If its so urgent and private then why are you
On Wed, 30 Jan 2002, Eurico de Sousa wrote:
Date: Wed, 30 Jan 2002 16:56:24 -0500
From: Eurico de Sousa [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Subject: Re: Batch load of data problems
Hi. Resubmitting a post...
Basically, my question is if you have defined an INT NOT NULL
On Thu, 31 Jan 2002, DL Neil wrote:
Date: Thu, 31 Jan 2002 21:28:04 -
From: DL Neil [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: next insert id (slightly OT)
William,
What should be understood is that MySQL's implementation
I'm glad you spelled it out. When it first started I thought you were
refering to IBM PS/2 computer, silly me.
http://ars.userfriendly.org/cartoons/?id=20010211
On Thu, 31 Jan 2002 [EMAIL PROTECTED] wrote:
Date: Thu, 31 Jan 2002 16:01:46 +0100
From: [EMAIL PROTECTED]
To: [EMAIL
You want to look at 'group by acctSrv.accountID' rather than a compound
select.
On Mon, 23 Dec 2002, Adam Nowalsky wrote:
Date: Mon, 23 Dec 2002 09:04:32 -0500
From: Adam Nowalsky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: sql help
hi, wonder if the sql gurus can help with this
On Mon, 6 Jan 2003, Octavian Rasnita wrote:
Date: Mon, 6 Jan 2003 08:33:48 +0200
From: Octavian Rasnita [EMAIL PROTECTED]
To: Larry Brown [EMAIL PROTECTED],
MySQL List [EMAIL PROTECTED]
Subject: Re: Hiding the password
No, we are not talking about the staff of the hosting company.
On Mon, 6 Jan 2003, Mark wrote:
Date: Mon, 6 Jan 2003 22:48:06 +0100
From: Mark [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED],
Octavian Rasnita [EMAIL PROTECTED]
Cc: Larry Brown [EMAIL PROTECTED],
MySQL List [EMAIL PROTECTED]
Subject: Re: Hiding the password
To: William R. Mussatto; Octavian Rasnita
Cc: Larry Brown; MySQL List
Subject: Re: Hiding the password
- Original Message -
From: William R. Mussatto [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]
Cc: Larry Brown [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent
1 - 100 of 197 matches
Mail list logo