> This means anytime a user defined variable like "@num := @num + 1" and is
> used in a query that is sorted, it is going to have to be changed to a
> subquery. For example, if someone was using it to display detail line item
> numbers on an invoice, it now has to be turned into a subselect. This b
On Mon, 19 Jan 2009, Duane Hill wrote:
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMAR
Dear MySQL users,
MySQL 6.0.9-alpha, a new version of the MySQL database system has been
released. The main page for MySQL 6.0 release is at
http://www.mysql.com/mysql60/
A new algorithm that uses both index access to the joined table and a join
buffer has been implemented. It's called Batch
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMARY KEY USING BTREE (`body_id`),
mos wrote:
At 03:14 AM 1/19/2009, b wrote:
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem
to be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char
At 03:14 AM 1/19/2009, b wrote:
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to
be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10) DEFAULT
On Mon, Jan 19, 2009 at 4:14 AM, b wrote:
> mos wrote:
>>
>> I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be
>> working properly if the Select statement is sorted.
>>
>> Here is a simple example:
>>
>> CREATE TABLE `tmp` (
>> `Purch_Date` date DEFAULT NULL,
>>
MySQL University: Scalability by design - coding for systems with large
CPU counts
This Thursday, we're continuing our series of sessions on MySQL
performance measuring and improvements with Richard Smith's presentation
titled Scalability by Design - Coding for Systems With Large CPU Counts.
Richa
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to
be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10) DEFAULT NULL
) ENGINE=MyISAM D
