On Wed, Oct 15, 2008 at 2:09 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
>> Rob Wultsch wrote:
>>>
>>> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]>
>>> wrote:
There's an awesome feature
D. Dante Lorenso wrote:
There's an awesome feature that was added to PostgreSQL a while back
called RETURNING that allows you to make an INSERT, UPDATE, and DELETE
statement behave like a SELECT statement.
...
Does RETURNING exist in any current release of MySQL or is it on the
TODO list even?
On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
> Rob Wultsch wrote:
>>
>> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]>
>> wrote:
>>>
>>> There's an awesome feature that was added to PostgreSQL a while back
>>> called
>>> RETURNING that allows
Rob Wultsch wrote:
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
There's an awesome feature that was added to PostgreSQL a while back called
RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement
behave like a SELECT statement. You can do somet
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
> There's an awesome feature that was added to PostgreSQL a while back called
> RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement
> behave like a SELECT statement. You can do something like this:
There's an awesome feature that was added to PostgreSQL a while back
called RETURNING that allows you to make an INSERT, UPDATE, and DELETE
statement behave like a SELECT statement. You can do something like this:
INSERT INTO mytable (id, value)
VALUES (1, 'something')
RETURNING any_colu
Hello Olaf,
1) OPTIMIZE TABLE is the same as mysqlcheck with "--optimize" flag.
2) Both take care of large chunks of deleted data.
3) As mysqlcheck is just a frontend for OPTIMIZE TABLE command, it should be
replicated in either case.
2008/10/15, Olaf Stein <[EMAIL PROTECTED]>:
>
> Hi All,
>
>
I would do a muli key PK with a after insert trigger to that would
change widget_number 1 to 1000. Just my HO...
> I would use this combo as the primary key, but I hate doing joins with
> multiple primary keys, so I'll also keep the widget_id for the purpose of
> making joins easier.
Why? Both of
All,
I am developing a service in MySQL that models a service I've already
built in PostgreSQL. I'm trying to port over some of my ideas from that
platform to MySQL. Here's the setup:
Let's say I have 2 tables: 'account' and 'widget'. Each of these tables
have a primary key but the widget
Hi All,
Just some simple questions I am somehow not able to find an answer to.
- Does "optimize table tablename" do the same thing as mysqlcheck [options]
db_name [tables] ?
- Do they take care of large chunks of deleted data?
- and I am assuming optimize table would replicate, mysqlcheck I wou
On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
> You can use the convert_tz function for this
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
> _convert-tz
>
> On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > Can we make adjus
You can use the convert_tz function for this
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
_convert-tz
On 10/15/08 12:03 PM, "Madan Thapa" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can we make adjustments in mysql or php code to display time in php sites
> in EST , alt
Hi,
Can we make adjustments in mysql or php code to display time in php sites
in EST , although server runs on CDT ?
Thanks
I tried to make a query that joins to subqueries:
SELECT discontinued.b
FROM
(SELECT mrc_titles.title AS a
FROM mrc_titles JOIN prod ON mrc_titles.title = prod.prod_title
JOIN pub ON prod.pub_id = pub.pub_id
WHERE pub.pub_code = "MRC"
Hi Alex, all!
Alex Katebi wrote:
> Any information on how to run the test scripts for the embedded client.
Call the test script, "mysql-test-run.pl", and pass it the option
--embedded-server
It does not support replication or cluster, so you should add
--skip-rpl --skip-ndbcluster
Regar
Hi,
1. Since requestid is a primary key then why you are using distinct in your
query. It's not required.
2. Index needs to be created on logtime.
3. Explain will best describe where indexing is required.
4. In your query use group by a.logtime (date_format is not required)
Your system must ha
Hi Krishna,
I have one more question for you. My table schema is as follows
create table RequestDO (
country VARCHAR(256),
device VARCHAR(256),
devicemanufacturer VARCHAR(256),
entryPage INTEGER,
exitPage INTEGER,
logicalPageName VARCHAR(3999),
logtime TIMEST
Hi,
It depends on your query using join and sort. Also, on how much ram you
have. You can refer to huge_my.cnf
You can find huge_my.cnf in the complied mysql-server binary.
join 12 MB
sort 8 MB
On Wed, Oct 15, 2008 at 3:29 PM, Karthik Pattabhiraman <
[EMAIL PROTECTED]> wrote:
> I have not speci
I have not specified any values for join_buffer_size and
sort_buffer_size. What should be the optimal values for this?
-Karthik
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2008 10:03 AM
To: Karthik Pattabhiraman
Cc: mysql@lists.mysql.com
Subject: Re
> Date: Tue, 14 Oct 2008 16:55:11 +0300
> From: Olexandr Melnyk <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], mysql@lists.mysql.com
> Subject: Re: Problem with GROUP BY
>
> http://jan.kneschke.de/projects/mysql/groupwise-max
>
> 2008/10/14 Peter Brawley <[EMAIL PROTECTED]>
>
> > Philip
> >
> > m
20 matches
Mail list logo
