On Sat, 06 Apr 2002 22:56:11 -0500, Chuck \"PUP\" Payne wrote:
>Hello again,
>
>I am trying to set up a SQL statement using NOW(), what I am wanting
>to do
>is to use NOW() then do a search on any date less than 7 days.
>Before I get
>several e-mails asking why. I am trying to a news base database
mysql> select date_created from forums;
+-+
| date_created|
+-+
| 2002-04-04 19:27:03 |
+-+
1 row in set (0.00 sec)
mysql> SELECT CONCAT(HOUR(now()-date_created), 'H',
MINUTE(now()-date_created), 'M', SECOND(now()-date_created),
On Sat, 6 Apr 2002 [EMAIL PROTECTED] wrote:
> I sense this could be a troll, but...
>
> /* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */
>
.
.
> Frankly, the agreement your client should look at cancelling is the one
> with your company. Your inability to install MySQL notwithstanding,
> jump
Hi!
MySQL AB and Innobase Oy entry-level support contract costs 3770 euros
annually (3250 USD).
For corporations with requirements for high availability we have
more expensive telephone support options. These are extremely low priced
compared
against your costs for proprietary database products,
Being the Sys Admin for the Boise Family YMCA in USA Idaho I say thanks for
sharing MySQL rocks! To bad the H. O'Loughlin CEO dud didnt hear it
Wish I knew who his client was so they could hear it to and dump him.
-Original Message-
From: João Paulo Vasconcellos [mailto:[EMAIL PROTECTED]]
On Sunday, 7. April 2002 05:56, Chuck \"PUP\" Payne wrote:
Hi,
>
> I am trying to set up a SQL statement using NOW(), what I am wanting to do
> is to use NOW() then do a search on any date less than 7 days. Before I get
> several e-mails asking why. I am trying to a news base database for the
> co
Very fun !
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 2:35 PM
Subject: My.S.Q.L
> Ok... it's Saturday and I've been meaning to share this with a wider
> audience for years Antti, you'll probably remember this from when
> I
Has anyone though about writing an internal function to have MySQL dump
database statistics into a flat file or database tables?
-RG
On 5 Apr 2002, Jason Yates wrote:
> Date: 05 Apr 2002 16:04:01 -0500
> From: Jason Yates <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: mysql monitoring
>
Try linux virtual server.
You can Load Balance any port on a multitude of servers.
Your MySQL Servers you would load balance would have to be read-only
slaves though.
We are currently running two linux virtual servers to load-balance
same-port services on multiple servers with multiple Unix OSes
Hello again,
I am trying to set up a SQL statement using NOW(), what I am wanting to do
is to use NOW() then do a search on any date less than 7 days. Before I get
several e-mails asking why. I am trying to a news base database for the
company intranet and I am wanting to only show newsitems that
Hi All,
After working happily for months, my MySQL (v. 3.23.48-1) database has begun displaying
the following problem:
Whenever I log in as mysql root and try to change privileges for my database as
follows:
grant insert, select
on MyDB_Name
to MyExistingUserName;
I get the error that the dat
I belive I have found a bug here, possibly.
The last known commands to be run on the DB that are "suspicious" were a join between
2 tables.
This is the info I got from the user who was workign on the DB:
He was "joining between keyword and billing"
select distinct(a.customerid) from cpcustom
I forgot to point out that this is InnoDB
I've searched Google and found the following disquiteing thing:
http://www.innodb.com/oldbugs.html:
"Closed or old bug reports: Almost all of these bugs have been fixed. There are some
old bug reports where the cause of the bug was never found, but beca
At 18:51 -0500 4/6/02, Carl Schmidt wrote:
>My understanding from the mysql docs is that indexing is to be used
>primarily for speeding queries on often used tables. This particular
>table is to be queried quite a bit , but almost entirely using the priamry
>key. So, I assumed that making the pr
020406 18:02:50 ***
I'm getting this error messge constantly in my error log:
InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (200 search iterations)! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possi
Subject: any better way?
From: "deco" <[EMAIL PROTECTED]>
===
I have a bunch of data stored on a file and organized in messages... I got a
message header and depending on the message type, i'll get a sequence of
values which can be double, float, long, int, char, etc...
Now i want to put this in
My understanding from the mysql docs is that indexing is to be used
primarily for speeding queries on often used tables. This particular
table is to be queried quite a bit , but almost entirely using the priamry
key. So, I assumed that making the primary key an index would speed
table searches.
At 18:28 -0500 4/6/02, Carl Schmidt wrote:
>On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
>
>> Your message cannot be posted because it appears to be either spam or
>> simply off topic to our filter. To bypass the filter you must include
>> one of the following words in your message:
>>
>> sql,q
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and includ
At 18:28 +0200 4/6/02, Roger Baklund wrote:
>* Paul DuBois
>> At 18:03 +0200 4/6/02, David yahoo wrote:
>> > Is there any way to put a sort order different than the
>> > alpahbetical order in string.
>> >
>> >A thing like that order "french","german"
>>
>>
>> ORDER BY ELT(language,'engl
Original Message:
From: "Hugh O'Loughlin" <[EMAIL PROTECTED]>
Date: Sat, 06 Apr 2002 12:31:40 GMT
Message-ID: <[EMAIL PROTECTED]>
Subject: Do any of your applications work?
To: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-print
Hello,
I am trying to restore some data from the binary log but I get the
following error:
"Duplicate entry '1' for key 1"
I understand restoring data is a two-stage process:
1. You do a "source myfile.sql" to restore the data saved with mysqldump
2. You restore the data logged in the binary l
At 14:31 2002-04-06, Hugh O'Loughlin wrote:
> Ommission errors of the magnitude
>we have found, are pure 'Microsoftish' in nature, and should have no
>place anywhere, integrity not withstanding.
"Microsoftish"? Gosh, us Microsoft users have been having problems because the
software doesn't fo
Hi,
On Sat, Apr 06, 2002 at 03:57:39PM -0500, Victor wrote:
> Suppose that a query begins with begin. Then a couple inserts happen but
> before the commit statement is executed, the client hits stop in the
> browser. What is going to do the rollback? If there is a persistent
> connection, is it g
Hi,
Generally, an apache setup will kill a PHP enabled page when it has run for
30 seconds. Also, when a php script exits, all connections to the database
are closed, so somwhere you need to keep the results of your script somwhere
(hidden HTML variables, URI string), otherwise, when you change p
Hi. I have a question about rollbacks and innodb.
Suppose that a query begins with begin. Then a couple inserts happen but
before the commit statement is executed, the client hits stop in the
browser. What is going to do the rollback? If there is a persistent
connection, is it going to wait for 8
Yesterday we discovered a strange problem with our database running on
MySQL version 3.23.45 on a Linux OS version 2.2.16
The MySQL database had been running perfectly with a PHP interface on
the web since january 30th and records were added normaly. Now suddenly
the MySQL server is brought back i
Hello [EMAIL PROTECTED],
It's pretty interesting!
Is tere MP3 file available for this song?
On Sat, 6 Apr 2002 09:35:12 -0800 (PST)
[EMAIL PROTECTED] wrote:
> Ok... it's Saturday and I've been meaning to share this with a wider
> audience for years Antti, you'll probably remember this from
/* Kevin Smith [[EMAIL PROTECTED]] writes: */
>That has got to be the best reply I have ever seen ;)
>
I wanted to reply with...
H. O'Loughlin, CEO -- you are the weakest link. Good Bye.
>- Original Message -
>From: "Richard Clarke" <[EMAIL PROTECTED]>
>Sent: Saturday, April 06,
I think of a little hack
I can add in where clause something like :
ELT(language,'english','german','french') != 0
to avoid language not in list even if there no normally :)
I try this as soon as i can.
thanks.
> * Paul DuBois
> > At 18:03 +0200 4/6/02, David yahoo wrote:
> > > Is there any w
Ok... it's Saturday and I've been meaning to share this with a wider
audience for years Antti, you'll probably remember this from when
I sent this to you shortly after I wrote it (1999)... If anyone would
like to record this, let me know! :-)
My.S.Q.L (sung to Y.M.C.A by the Village Peopl
I sense this could be a troll, but...
/* Hugh O'Loughlin [[EMAIL PROTECTED]] writes: */
>We have been asked by a client, to use your products in our intergration
>efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86,
>
Excellent choice.
>./scripts/mysql_install_db. The ./scripts
That has got to be the best reply I have ever seen ;)
Kevin
- Original Message -
From: "Richard Clarke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 2:36 PM
Subject: Re: Do any of your applications work?
> Hello Mr CEO,
>
> Hmmm... go away?
>
> Ric
* Paul DuBois
> At 18:03 +0200 4/6/02, David yahoo wrote:
> > Is there any way to put a sort order different than the
> > alpahbetical order in string.
> >
> >A thing like that order "french","german"
>
>
> ORDER BY ELT(language,'english','german','french'),Linkname ASC
Maybe you meant FIELD
At 18:03 +0200 4/6/02, David yahoo wrote:
>Hi all,
>
>I d like to order some links which are in 2 langauage (French/English).
>
>So i make this request in case a visitor select french in language so french
>links where on top in this case
>because "f"rench is after "e"nglish in alphabectical orde
Hi all,
I d like to order some links which are in 2 langauage (French/English).
So i make this request in case a visitor select french in language so french
links where on top in this case
because "f"rench is after "e"nglish in alphabectical order.
SELECT * FROM links WHERE Accepter LIKE 1 AND
I agree with everyone that has responded. A vague answer that does
nothing but moan about something that is more or less incompentence from
your developmental team. Not only that, but you have a support
contract, so why you asking a question here? Shouldn't you be calling
your support for this
Hi...Sir,
The answer on your question is Y E S.But further, perhaps,"a little more"
experiences for your technical team is needful.
- Original Message -
From: Hugh O'Loughlin <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 3:31 PM
Subject: Do any of your applica
Ditto here. If you have a support contract, then this is not the channel
for seeking support, since it's a free mailing list. And anybody would
need more information than you provided to solve the problem. Did you
try to install a binary version? Did you try to build from source? MySQL
is installe
Hello Mr CEO,
Hmmm... go away?
Ric
- Original Message -
From: "Hugh O'Loughlin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 1:31 PM
Subject: Do any of your applications work?
Responsible Person,
We have been asked by a client, to use your products
At 1:24 -0600 4/6/02, BD wrote:
>Paul,
> Do you know if there is any performance differences between
>a unique index and primary key (if there are no nulls)?
> Is the index file format the same as the primary key?
I cannot answer that with absolute certainty, but as far as I know
Responsible Person,
We have been asked by a client, to use your products in our intergration
efforts. Your MySQL 3.23.49a [Stable version?] for Sun Solaris x86,
version, 5.8, is offered without the installation file
./scripts/mysql_install_db. The ./scripts/mysql_install_db, that comes
with i
Hello,
I've been looking for a way to select and access all result rows
starting at a specific offset. The according select clause with "LIMIT
n,m" comes to mind, but unfortunately the current documentation is not
very explicit concerning the appropriate value for m under these
circumstances.
I have a standard installation of Mysql on a red hat 7.1 box. I am confused
as to where I can disable the SKIP_LOCKING feature.
There is no skip_locking-option in /etc/my.cnf. I removed the string
"--skip_locking" from /usr/bin/safe_mysqld. I can't find it anywhere, still
when I do mysqladmin
I am using MySQL Manager to manage a database created with the tool a week or so
ago. Worked on the database last night and all was fine. Opened up mySQL Manager today
and any change to the tables
h> (add or edit of columns) gives the error below:
h> Error on rename of:
h> '.\\.MYI' to '.\\#SQ
mkw,
Saturday, April 06, 2002, 12:59:15 PM, you wrote:
m>Description:
m> While I tried to open MySQL, it showed an error message, is 'can't connect
MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one
(User: root, Group: mysql,
m> Permission: 777), the error
>Description:
While I tried to open MySQL, it showed an error message, is 'can't connect
MySQL through /var/lib/mysql/mysql.sock' (Error Code=2), and I created a new one
(User: root, Group: mysql, Permission: 777), the error code changed into 111.
>How-To-Repeat:
Open MySQL.
>Fix
Hi Gurhan,
The tee command printed out the table perfectly to a
file,
Cheers,
Colin
>tee /dir/table.txt;
>select * from table;
--- Gurhan Ozen <[EMAIL PROTECTED]> wrote:
> Hi,
> Try to use tee command to log all the output into a
> file. It will have the
> column names and everything you see
Hi,
I would like to try to implement a MySQL server that is spanned over several
machines (a sort of database cluster) - as this is only a test, I am not too
woried about the end OS, but I will probably use a Mandrake 8.1 or 8.2 Linux
distribution.
I have found in the manual information about ru
Dear All
Could any one tell me what all the chages I have to make in order
to make my existing (english version) of MySQL database compatable
to the Japanese language.
Thanks and Regards
Aravind
-
Before posting, please check:
Patrick,
- Original Message -
From: "Patrick Hsieh" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, April 06, 2002 10:43 AM
Subject: Re: InnoDB is better than MyISAM ?
> Hello "Heikki Tuuri" <[EMAIL PROTECTED]>,
>
> Where can I find Inn
51 matches
Mail list logo
