At 11:33 PM + 3/13/07, [EMAIL PROTECTED] wrote:
Date: Tue, 13 Mar 2007 20:56:08 +0530
To: mysql@lists.mysql.com
From: "Yashesh Bhatia" <[EMAIL PROTECTED]>
Subject: using DISTINCT after the ORDER BY clause has been applied
Message-ID: <[EMAIL PROTECTED]>
Hello:
I had a quick question on
At 9:30 PM -0300 3/13/07, allysonalves wrote:
Hi everybody
Has some way to set up a function, like now(), as a default value of
an dateTime column.
Is some thing like this.
Create Table Persons (
PersonCode int(10) zerofill not null auto_increment,
PersonName varchar(150) not null,
CadastreDa
At 5:24 PM -0700 3/13/07, jerad sloan wrote:
thanks for the quick reply.
i want that to be unique so there is no way to insert the same URL
more than once.
there isn't a record with that URL...but it gives the error
anyway...it seems to be just checking a portion of the entry i'm
trying to in
thanks for the quick reply.
i want that to be unique so there is no way to insert the same URL
more than once.
there isn't a record with that URL...but it gives the error
anyway...it seems to be just checking a portion of the entry i'm
trying to insert.
i don't want uniqueness across a set
Hi everybody
Has some way to set up a function, like now(), as a default value of an
dateTime column.
Is some thing like this.
Create Table Persons (
PersonCode int(10) zerofill not null auto_increment,
PersonName varchar(150) not null,
CadastreDate DateTime not null default now(),
Primary Key (
At 4:36 PM -0700 3/13/07, jerad sloan wrote:
thanks.
i had an extra index setup for one of my fields...i deleted it and
it started working as expected...but now the same thing is happening
again.
i'm getting the error
"Duplicate entry
'http://vids.myspace.com/index.cfm?fuseaction=vids.indivi
thanks.
i had an extra index setup for one of my fields...i deleted it and it
started working as expected...but now the same thing is happening again.
i'm getting the error
"Duplicate entry 'http://vids.myspace.com/index.cfm?
fuseaction=vids.individual&vid' for key 2"
when doing the followi
Ahh... sweet... makes sense... thanks! :-)
On 3/12/07, Brent Baisley <[EMAIL PROTECTED]> wrote:
If you are looking for the latest created_at date, then you want to be grabbing
the max value of that field.
SELECT DISTINCT from_user_id, max(created_at) FROM messages WHERE to_user_id
= 1 GROUP BY
Hello
My name is Lara Thynne and I am a PhD candidate at Deakin University
Australia. I am currently researching the boundary between work and
leisure activities directly related to the open source community and
open source program development.
As part of this I am running a survey at the follo
Brown, Charles wrote:
Hello Dan. Try it and see if you can:
mysql> create index indx101 on tab101(min(c1),c2) ;
Answer: Its not supported.
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
S
Hi,
Try MRTG, there are a couple of very good scripts available for monitoring
mysql, it can monitor locally for you without requiring TCP access to the
DB. This allows you to monitor (not on a real time basis though) multiple
databases and provide some nice pictures to spot errors quickly. There
> On 3/13/07, Bing Du <[EMAIL PROTECTED]> wrote:
>>
>> Hi,
>>
>> Seems like there are quite many MySQL monitoring tools on the Internet.
>> The one I tried today was MONyog http://www.webyog.com/en/. I've also
>> tried a couple of others before, including phpmysqladmin as I was
>> suggested. The
It appears to me that the problem is not only in the TTW, since I can add a
prod in the TTW with a cat not found in the new database, but rather found in
the old dbase. Furthermore, both prods show up in MySQL and in the TTW
interface. I have cleared all caches, rebooted Zope (the TTW), even wai
It appears to me that the problem is not only in the TTW, since I can add a
prod in the TTW with a cat not found in the new database, but rather found in
the old dbase. Furthermore, both prods show up in MySQL and in the TTW
interface. I have cleared all caches, rebooted Zope (the TTW), even wai
Yes, I think that will work. I haven't tried it, though.
By the way, you'll get more and better feedback if you "reply all" so that
the entire group gets to see what you're doing.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX
The fact that youhavee problem when surfing, but the data looks fine
when viewed directly through the console (or whatever), these conspire
to suggest that your problem is not SQL-related at all but might be in
the caching directives associated with your web app. To test this
hypothesis, try clea
Hello Dan. Try it and see if you can:
mysql> create index indx101 on tab101(min(c1),c2) ;
Answer: Its not supported.
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: function base
Probably you cant access it from network (remote access), but if you do some
script do interconnect them.. maybe you can get this working :D
Or if you prefer you can enable the tcp/ip socket on a diferent port for
each instances of mysql running in your box..
:)
On 3/13/07, Bing Du <[EMAI
Hi there,
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root -p password testpw
Enter password
Hi Dan:
Thanks for your time. Actually you are right. I was migrating the
database from oracle to MySQL and had issues with migrating few tables in it.
I saw that the reason was that the size of the table. So, I changed the
settings in the migration kit with the Dynamic settings and mig
In the last episode (Mar 13), Tangirala, Srikalyan said:
> I'm a newbie and I'm trying to understand how can I increase or set
> the size of the table in Oracle database. I'm trying to migrate the
> database from oracle to MySQL and was successful in that. But, few of
> the tables are not created a
Hi,
Seems like there are quite many MySQL monitoring tools on the Internet.
The one I tried today was MONyog http://www.webyog.com/en/. I've also
tried a couple of others before, including phpmysqladmin as I was
suggested. They require you provide mysql server name and port number.
In our situ
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Googling for
ASP AES
I found several promising results.
- --
Skype: cannona
MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail
address.)
- - Original Message -
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: <[EMAIL
Hi All:
As the GUI tools archive doesn't help, I wanted to seek some help
from here. I was migrating the database from oracle to mysql. I was having
an issue migrating a table from oracle to mysql figured out that the table
size on the MySQL has to be set. I'm using the migration kit
Hi list,
I'm messing around with weighting my search results, and I've run
into a weird quirk that I'm hoping someone here could help me
understand. I have a query like such:
SELECT
xcart_products.product,
xcart_product_meta.synonyms_misspellings,
MATCH (xcart_produ
On Tue, March 13, 2007 1:45, Neil Tompkins said:
> I'm using ASP. Do you know any resources that I could use ?
>
Apart from mentioning that perl from active state does have an asp
variant, no. Sorry we turned off our last NT box when Garner group said
that MS made fine servers as long as you neve
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_idint unsigned"page id of the page viewed"
user_id int unsigned"user id of the page viewed"
ts timestam
Hello:
I had a quick question on using the DISTINCT clause in a SELECT query.
I have the following table which stores webpages viewed
table: page_viewed
page_id int unsigned "page id of the page viewed"
user_id int unsigned "user id of the page viewed"
ts timestamp "timestamp of the page view
In the last episode (Mar 13), Ananda Kumar said:
> Is it possible to create function based index in mysql as available
> in oracle. Please point me to any documentation on this.
Sorry; mysql doesn't have function-based indexes. The closest you can
get in mysql is if you add another column and an
Hi All:
I'm a newbie and I'm trying to understand how can I increase or set
the size of the table in Oracle database. I'm trying to migrate the database
from oracle to MySQL and was successful in that. But, few of the tables are
not created and when I checked back in the oracle database,
Marcus Bointon wrote:
> Hi,
>
> (repeat posting)
>
> I have a simple PHP function that initialises a process definition. To
> prevent it happening more than once, I'm wrapping it in a transaction,
> however, it doesn't seem to be working and I get multiple
> initialisations. In pseudocode:
>
> B
Hi there,
I am trying to enable two things:
1. Slow query log
2. Error log
Despite the fact that I have enabled slow query log in my.cnf and the
-var command says it is enabled the file is not existing.
So I was searching for the error log, but there is none? :-(
Can somebody please help me
Hi,
(repeat posting)
I have a simple PHP function that initialises a process definition.
To prevent it happening more than once, I'm wrapping it in a
transaction, however, it doesn't seem to be working and I get
multiple initialisations. In pseudocode:
BEGIN;
UPDATE process SET status =
Hi;
I mysqldump'd a dbase, created a new empty dbase by another name, then injected
the old dbase into the new. They both exist. I then dumped out all the prods
and categories from the new dbase and created new cats. However, when I surf to
my TTW interface to add new prods, the *old* cats show
I'm using ASP. Do you know any resources that I could use ?
From: "Wm Mussatto" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
Subject: Re: ENCODE() and DECODE()
Date: Mon, 12 Mar 2007 15:27:26 -0700 (PDT)
On Mon, March 12, 2007 15:05, Neil Tompkins said:
> Do you think these fu
35 matches
Mail list logo