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
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.
On Mon, Jan 19, 2009 at 4:14 AM, b my...@logi.ca 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,
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)
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`
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`),
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
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,
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 breaks
