Re: MAX + SUM in one query

Hi That's fine. But for the query, I have created a simple table which simulates as that of yours. I have used simple domain names. I typed the StockID as RequestID. Nothing morethan that. But it gives solution for your query. SELECT R.Stock_StockID,MAX(R.RequestPrice), SUM(R.RequestTotal)

Re: when does auto_increment_increment and auto_increment_offset come into being?

Hi Obviously!. These variables were introduced in MySQL 5.0.2. These system variables accommodate multi-master replication with AUTO_INCREMENT. Thanks ViSolve DB Team. - Original Message - From: "Xueron Nee" <[EMAIL PROTECTED]> To: Sent: Monday, November 06, 2006 10:59 AM Subject:

Re: MAX + SUM in one query

Hi no R.RequestENDDate>=Date(now()) will work fine (I use it in other sql queries) also as you can see in my sql, I want to group using Stock_StockID , so your solution will not work with me On 11/5/06, Visolve DB Team <[EMAIL PROTECTED]> wrote: Hi, The query what you tried will return empty

Re: MAX + SUM in one query

Hi, The query what you tried will return empty set only, since you have compared the RequestENDDate with now(), which always returns false[due to seconds]. Try extracting the date part alone from RequestENDDate for the Where cond. otherwise the query do well: select RequestID, sum(RequestTota

Convert hex to decimal?

Hey, I have a table with a SMALLINT column that -- trough a mistake -- contains values like 57, 13 etc. which in fact are 0x57 and 0x13 (i.e. HEX numbers). How would I convert 13 ("false decimal") to 0x13 (Hex) and from there to 19 (decimal)? I tried my luck with UNHEX and CAST but I only got

when does auto_increment_increment and auto_increment_offset come into being?

Hi all, I am reading MySQL 5.1 Reference Manual and found about the two variables in Chapter 6. Replication. But I cannot find from when these two variables come into being. I am using 4.0.27 on my servers now, and can not find them by using "show variables". Should I upgrade my servers? Thanks!

Re: Transfering Databases

Rob Cochrane wrote: Hi All, I am a Web developer and have been using MySQL for a couple of years. I have just changed to a new development machine away from WinXP to Ubuntu Linux. My Dbase administration in the past has been via MySQL-Admin and SQLYog. I am now trying to bring all my database

MAX + SUM in one query

Hi everyone I have the following the table : CREATE TABLE `Request` ( `RequestID` int(10) unsigned NOT NULL auto_increment, `Stock_StockID` int(10) unsigned NOT NULL default '0', `RequestType` enum('Bid','Offer') NOT NULL default 'Bid', `RequestTotal` int(10) unsigned NOT NULL default '0',

Re: Default Column Value

Hi On 2006-11-05 Bill Guion wrote: > In one of my tables I have a start_date - timestamp (2007-07-04). A > separate column, start_yr_mo, has 200704 (first seven characters of > timestamp without the '-'). Both are entered manually. Can I define > start_yr_mo as a default of, for example, set st

Default Column Value

In one of my tables I have a start_date - timestamp (2007-07-04). A separate column, start_yr_mo, has 200704 (first seven characters of timestamp without the '-'). Both are entered manually. Can I define start_yr_mo as a default of, for example, set start_yr_mo = concat(substr(start_date, 1, 4)

Re: Transfering Databases

Rob, are you getting any error messages when trying to restore your MYSQL backups (I assume that you have backed up your databases on the XP system by using the MYSQL Administrator's backup function)? What are these messages? I also suppose that creating blank databases on the Linux system and di

Transfering Databases

Hi All, I am a Web developer and have been using MySQL for a couple of years. I have just changed to a new development machine away from WinXP to Ubuntu Linux. My Dbase administration in the past has been via MySQL-Admin and SQLYog. I am now trying to bring all my databases into localhost and