sum with update

Hi Everyone I have a question regarding SUM and Update. is it possible to use SUM with Update ? for example I have 3 tables table_1: idT1 Price 120 230 350 420 table_2: idCust Total

Re: old-password issue with mysqldump

Hi Thanks, this is easy and simple if I just have few users :) I have more than 30,000 users :) I think there is no way to do this so I have to use old-passwords option in the new servers :) Thanks On 12/11/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 12/11/06, Ahmad Al-Twaijiry &

old-password issue with mysqldump

Hi everyone I'm using mysqld with option "old-passwords" in my server (let's call it serverA) and in my application I use "UPDATE . SET USERPWD=PASSWORD('ABCD')" to set the users password now I want to move my database to another server (serverB) and the mysqld in this new server doesn't ru

Re: Deadlock

YES :) after removing CustomerID and OrderID from Primary index to unique index, every thing is working fine and I don't get any deadlock anymore :) Thanks Everyone :) On 11/16/06, Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi Ahmad, On 11/13/06, Ahmad Al-Twaijiry <[EMAIL PRO

Re: float numbers

IMAL and DOUBLE in MySQL 5.0.* ? Thanks On 11/18/06, mos <[EMAIL PROTECTED]> wrote: At 03:29 PM 11/17/2006, Ahmad Al-Twaijiry wrote: >Ho everyone > >I have a column in a table defined as float > >mynumber float(20,2) > >if we say mynumber column in a row is 100 ,

float numbers

Ho everyone I have a column in a table defined as float mynumber float(20,2) if we say mynumber column in a row is 100 , when I run this SQL : UPDATE Table SET mynumber=mynumber-100.15 the mynumber column will be 00 not 999899.85 what is the problem ? -- echo "Hello World :)" --

Re: Deadlock

Commits a transaction, returning the database connection to autocommit mode until the next call to PDO::beginTransaction() starts a new transaction. That means that autocommit is disabled when you issue $dblink->beginTransaction(); - Original Message ----- From: Ahmad Al-Twaijiry <[EMA

Deadlock

Hi everyone, Everyday I got around 10 Deadlock errors in my database : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction SQL=UPDATE Shop SET Total=Total-125 WHERE CustomerID=1697 AND OrderID=105 I'm using Innodb engine type for my

Re: MAX + SUM in one query

#x27;offer' and id same for both the tables. Is it so? Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006

Re: MAX + SUM in one query

test where >> RequestType='offer' group by StockID; Pls have a look into the table and the output for the query. Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTE

Re: MAX + SUM in one query

rows in set (0.01 sec) Thanks, ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, November 06, 2006 8:58 AM Subject: MAX + SUM in one query > Hi everyone > > I have the following the t

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',

transaction in mysql 5

Hi everyone I have a PHP script that will run every minute and do a lot of SELECT and UPDATE statments All my tables are InnoDB and I'm using PHP 5 and POD class ( http://php.net/pod ) to connect to mysql, in my script I start the transaction (using method beginTransaction() ) in the beginning o

Mysql Timezone

Hi everyone is it possible in Mysql 5.0.1 to set the timezone for a user ? PS: I don't have root access to mysql, so I'm looking for away to do it as a normal user. --- Ahmad http://www.v-tadawul.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Reports

Hi everyone do you know any good (free) application that make it easy to generate (with charts) a very nice reports from mysql ? Thanks --- Ahmad http://www.v-tadawul.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

list of cols that I need to index

Hi is there anyway or command to run it against a production table to see if there is any column that I should think about indexing it remember this is a production database, so I can't run it in debug mode and I don't have a root access to the database (I'm just a developer). Thanks -- Ahm

Re: SUM in WHERE

WHERE total=100 ORDER BY id LIMIT 1,1 Douglas Sims [EMAIL PROTECTED] On Sep 24, 2006, at 3:27 PM, Ahmad Al-Twaijiry wrote: > Hi > > I need the result to be 100 not to more or less than 100 > > here is my query : > > mysql> select version() ; > +-

Re: SUM in WHERE

ould also do it in the perl/python/php/whatever layer which is sending this query to the database. Can you send a transcript of what you tried, including the "SHOW CREATE TABLE" statement? Douglas Sims [EMAIL PROTECTED] On Sep 24, 2006, at 10:09 AM, Ahmad Al-Twaijiry wrote: >

Re: SUM in WHERE

doesn't work :( , tested with 4.1.21 On 21 Sep 2006 13:20:37 -, Felix Geerinckx <[EMAIL PROTECTED]> wrote: On 18/09/2006, "Ahmad Al-Twaijiry" wrote: > I want to run SQL query that will return to me the first records that > the SUM of Total field = 100 USE tes

Re: SUM in WHERE

t; > Using only SQL, your best bet would be a stored procedure, > otherwise its really application logic to select the rows one at a > time and keep a running total. > > HTH > > Quentin > > -Original Message- > From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECT

Rapid application development

Hi Everyone, I know this isn't the right mail list, but I need your feedback as mysql users What is the best RAD (Rapid application development) do you use with MySQL to develop software or a web-based program ? and in which language is it ? (PHP, Perl, Java, ...etc). I like programming but one

Re: SUM in WHERE

Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:06 AM To: Edward Macnaghten Cc: mysql@lists.mysql.com Subject: Re: SUM

Re: SUM in WHERE

I tried it also with 4.1.21-log and still didn't work ! On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote: I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote

Re: SUM in WHERE

I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote: Ahmad Al-Twaijiry wrote: > Hi everyone > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID > > SELEC

Re: SUM in WHERE

--- > Von: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 18. September 2006 23:28 > An: mysql@lists.mysql.com > Betreff: SUM in WHERE > [...] > > I want to run SQL query that will return to me the first > records that the > SUM of Total field = 100 > &

SUM in WHERE

Hi everyone I didn't find any maillist regarding SQL question so I'm posting my question in here. I have a table like this [ ID ][ Total ] [ 1 ][ 20 ] [ 2 ][ 30 ] [ 3 ][ 40 ] [ 4 ][ 10 ] [ 5 ][ 20 ] [ 6 ][ 20 ] I want to run SQL query that will return to me