[ADMIN] Mailing lists back in service.
Hello again, MySQL list subscriber! We have completed the first phase of maintenance on the mailing lists, and mail should now start flowing on the lists again. Along with upgrading the hardware serving the lists, we have put in place new systems to help combat spam. One part of this system requires that non-subscribers to the mailing list confirm that they are a real person before their message is let through to the list. (And depending on how your local systems are configured, even some subscribers may be required to go through this one-time confirmation.) We will be keeping a close eye on things to make sure no real emails get dropped by the new systems, but please bear with us in the event that a few pieces of spam email slip through in the meantime. The mailing list archives at http://lists.mysql.com/ have also received the first phase of a facelift, and we will be rolling out additional improvements there in the weeks to come. If you encounter any difficulties with the lists, please don't hesitate to drop us a line at [EMAIL PROTECTED] Again, we're sorry about the interruption and inconvenience, and thanks in advance for your patience as we work the kinks out of the new systems! - The MySQL Team -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: UPDATE syntax help
Hi I may be way off base here but - why do you reference IMPORT_USERS in your UPDATE statement? You aren't updating any columns in that table. Regards, Sal > -Original Message- > From: MySQL [mailto:[EMAIL PROTECTED] > Sent: 12 March 2003 22:33 > To: MySQL > Subject: UPDATE syntax help > > > Hi all, I am having a little UPDATE syntax issue. According > to the manual > > UPDATE EBA_USERS, IMPORT_USERS > SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID, > EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID, > EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME, > EBA_USERS.REP_LAST_NAME = IMPORT_USERS.REP_LAST_NAME, > EBA_USERS.REP_DISABLED = IMPORT_USERS.REP_DISABLED > WHERE EBA_USERS.REP_ID = IMPORT_USERS.REP_ID > > should work (as I understand it ;-) but I get the error > > ERROR 1064: You have an error in your SQL syntax near ' IMPORT_USERS > SET EBA_USERS.HUB_ID = IIMPORT_USERS.HUB_ID, > EBA_USERS.REP_LOCATION_ID = > IMPO' at line 1 > > I did note in the comments section at the bottom someone else with > same/similar problem, but have been unable to find a thread > in the mail > archive. My apologies if this has been dealt with already, > or a workaround > suggested... > > MySQL 3.23.51-nt on a Win2K box > MyODBC 3.51 > > Thanks > > Jeff Creed > Throbware > > (0417) 797 592 > http://www.throbware.com.au > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using ssh tunnel and mysql
At 14:01 -0600 3/10/03, Pete Harlan wrote: On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote: Whether it's a feature or not, it's not always so easy to figure out what to do. If you specify -h localhost, it can be argued that you really want the socket even if you specify the port. It can be argued conversely that if you specify the port, you should use TCP/IP even if you specify -h localhost. That is, if the user specifies both, it's ambiguous what the user really wants. But "localhost" is a DNS name that only happens to resolve to 127.0.0.1. MySQL breaks this DNS abstraction by treating "localhost" as a keyword, different from 127.0.0.1, which goes against the principle of least surprise. (It confused me, anyway.) I think it would have been less confusing to treat "localhost" the same as its resolved IP address, and decide whether to use a local socket vs. a port number on the basis of a different argument (-l for local, perhaps, which would be the default when connecting to 127.0.0.1 (or localhost, or any other name that resolved to this IP)). In 4.1, there will be a --protocol option that allows the connection type to be specified. This will have the effect of allowing the user to specify intent unambiguously. Wild speculation: The current design was chosen back when MySQL didn't have different sections in /etc/my.cnf, so the port specification for the server was also used for the client. In that case the client usually read a port specification (in /etc/my.cnf), but in the common case the client wouldn't obey it, which typically did the right thing. (Now that there are separate [client] and [server] sections in my.cnf things are less jumbled.) That is indeed speculation, and it's incorrect. Option files were introduced around 3.22.10, and they've always had sections. The client could be made to obey a command-line argument, while still silently ignoring the my.cnf argument. (That's what my patch did.) It's not just the mysql client, it's the client library, which is what bit us. You specify a port in the DBI->connect() routine as something like ';host=localhost;port=2000' and it's silently ignored there too. Well, sure. Options just map onto arguments to the mysql_real_connect() C library call, and the ambiguity of intent carries all the way down to that level. I'm very glad that ssh no longer (as of three years ago!) forwards externally-connected-to ports by default. --Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SET CHARACTER SET DEFAULT is not working in 4.0.12
>Description: If I change character set mapping with SET CHARACTER SET character_set_name, I can't change it to DEFAULT (ie. disable mapping) with SET CHARACTER SET DEFAULT. >How-To-Repeat: 1) Compile MySQL 4.0.12 with: a) uncommented #define DEFINE_ALL_CHARACTER_SETS in sql/convert.cc b) --with-charset=czech c) --with-extra-charsets=all 2) Start server 3) Insert data in BLOB (for example some image) 4) Execute SET CHARACTER SET cp1250_latin2; 5) Execute SET CHARACTER SET DEFAULT; 6) Get data from BLOB Now data from BLOB will be different from original inserted in 3). It looks like SET CHARACTER SET DEFAULT isn't working (but it works in lastest 3.23). I tested this on 2 different computers with FreeBSD. >Fix: Sorry, don't know. >Submitter-Id: >Originator:petr >Organization: CD-R server s.r.o. >MySQL support: none >Synopsis: SET CHARACTER SET DEFAULT is not working in 4.0.12 >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-4.0.12 (FreeBSD port: mysql-server-4.0.12) >C compiler:2.95.4 >C++ compiler: 2.95.4 >Environment: System: FreeBSD freebsd.k2.kreteni.cz 4.7-RELEASE FreeBSD 4.7-RELEASE #0: Wed Oct 9 15:08:34 GMT 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe -O3 -fno-omit-frame-pointer' CXX='cc' CXXFLAGS='-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1218496 Oct 9 14:43 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Mar 22 04:04 /usr/lib/libc.so -> libc.so.4 -r--r--r-- 1 root wheel 574916 Oct 9 14:43 /usr/lib/libc.so.4 Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug' '--without-readline' '--without-bench' '--without-extra-tools' '--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory' '--with-comment=FreeBSD port: mysql-server-4.0.12' '--with-server-suffix=' '--program-prefix=' '--enable-assembler' '--with-berkeley-db' '--with-charset=czech' '--with-extra-charsets=all' '--prefix=/usr/local' 'i386-portbld-freebsd4.7' 'CFLAGS=-O -pipe -O3 -fno-omit-frame-pointer' 'CXX=cc' 'host_alias=i386-portbld-freebsd4.7' 'build_alias=i386-portbld-freebsd4.7' 'target_alias=i386-portbld-freebsd4.7' 'CC=cc' 'CXXFLAGS=-O -pipe -O3 -fno-omit-frame-pointer -felide-constructors -fno-rtti -fno-exceptions' Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InterBase vs. Mysql
On Fri, 2003-03-21 at 21:26, John Griffin wrote: > Gerald, > > One hundred MySQL licenses still works out to $90.00 USD. Even if it > worked out to half that would still leave me with no margin and so no > compensation for my time. I am trying to find a way of using MySQL in > a very low cost market and still have still have pocket change after > each sale. The current pricing scheme does not support this market and > I am hoping that MySQL is open to suggestions to allow it to support > that market. No 100 licenses has a lower price per copy. And embedded in a application that sells at 1000, 1 or 100 the price gets much lower. Basically they more you can commit to sell the lower price you get. And as others have commented for our sales people it not the price per copy that the key thing for spending time on a deal. It the total deal size. So if you are planning to sell 100 $50 applications we do not have a way to price it for you since that negotiation takes expensive human time. But if if you are selling for example 2 it another matter. /David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Wrong mysql.sock
Hi there, I'm upgrading my old MySQL 3.2 to a new MySQL 4.0 and at the same time I decided to change the location of my data directory. Everything went fine until I begin to do things mentioned at http://www.mysql.com/doc/en/Upgrading-from-3.23.html. I tried to run mysql_fix_privilege_tables script, but I get following errors: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) This is my old data directory location. The new is /raid2/var/lib/mysql/ and there is mysql.sock active. How I should tell scripts that the mysql.sock file has moved to a new location? Thanks, Ville - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Two Tables Diplay Using PHP
So the two tables insert is now working so now the display is needed :) I have this: // This returns all the companies from items for the selected city and business type $result=mysql_query("SELECT items.ItemSKU, items.ItemName, items.ItemDescription, items.PostCode, items.Category, items.CityID, items.CTelephone, items.ItemID, items.Cfax, items.Cemail, items.Caddress, items.CTown, items.Cwww FROM items, city WHERE Category='$Category' and CityID='$CityID' ORDER BY CityID"); if (!$result) echo mysql_error(); else { } while ($row=mysql_fetch_row($result)) { $IS=$row['0']; $IN=$row['1']; $ID=$row['2']; $CpostC=$row['3']; $Ca=$row['4']; $City=$row['5']; $Ctele=$row['6']; $II=$row['7']; $Cf=$row['8']; $Ce=$row['9']; $Caddress=$row['10']; $Ctown=$row['11']; $Cw=$row['12']; however the CityID is no longer stored in the items table. It is in the city table :) So I presumably need to do a join? Any suggestions to get me on the right track? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ÃÀÒÁ¿ªÕ½ÒÔºó
http://since.vip.sina.com/";>http://since.vip.sina.com/pic/war_top_fire.gif"; width=750 border=0> 邮件内容与以下文字无关= 优联网络 http://www.chinamysql.com 专业提供各类虚拟主机,不满意可获退款。 强势套餐:100M主机送顶级域名,送10个10M企业油箱,加送20个二级域名,仅需318元/年! 三龙证券投资 http://3long.sayba.com 为您提供专业理财服务。现在购买只需588元,赠送价值超过1800元的礼品! 说吧网上商城 http://shop.sayba.com 全是厂商直销的新品或折上折的商品,是您网络购物的好去处! 使用极星邮件群发,无须通过邮件服务器,直达对方邮箱,速度绝对一流! 软件下载网址:http://www.lovexin.com,更多的超酷软件等你来下载哦!; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql Install on a AIX RS6000
change your my.ini or my.cnf - Original Message - From: "Bonnie Poole" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 22, 2003 8:53 AM Subject: MySql Install on a AIX RS6000 > > > > > I am trying to install on a AIX box. I do not want to install into > /usr/local. I have put everything in /sybase/mysql/mysql. I am running into > alot > of problems with things expected to be in /usr/local/mysql. What do I > need to run in order to tell mysql everthing is in /sybase/mysql/mysql > > Thanks for any help. > > Bonnie P. Poole > DiscoveryLink Solutions Development > IBM Life Sciences > 714-438-6361 Voice Mail > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: gotten pass one problem to land into another
Have you really compiled php with mysqlsupport? "undefined function" make an phpinfo.php containing just execute through a browser and look for mysql.. if you find nothing, you need to recompile php ./configure --with-mysql //lasse On Sat, 22 Mar 2003, Jon Miller wrote: > I've managed to fix one problem with the MySQL and phpMyAdmin to only get a > different error message> > Fatal error: Call to undefined function: mysql_connect() in > /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 > > Okay this line refers to the host, user and password, that should be (I'm guessing > here) in the config.inc.php3 file in the stduser area. > I've tried both with and without user info in this file and still I get the same > error. > So my question is do I have to have a username and password in config.inc.php3 in > order for phpMyAdmin to work? > Also do I have to restart MySQL and Apache? > Since this is an internal system I have Apache ServerName set to 127.0.0.1, is this > okay? > > Thanks > > > > Jon L. Miller, MCNE, CNS > Director/Sr Systems Consultant > MMT Networks Pty Ltd > http://www.mmtnetworks.com.au > > "I don't know the key to success, but the key to failure > is trying to please everybody." -Bill Cosby > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- -BEGIN GEEK CODE BLOCK- Version: 3.1 (2002 update) GCM/GCS/GMU/ d+ s++:++ a-- C++() UBLAIS+() P+ L+(-) E--- W+++ N+ o-- K w O- M- V- PS(+++) PE++ Y PGP- t 5+ X++ R- tv+ b+ DI+++ D- G e h++ r% y++ --END GEEK CODE BLOCK-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Two Tables - PHP Query Insert UPdate
Hi MySQL I am now working on the insert into two tables :) items and items_city In each table there is the ID which is unique. This is what I have so far and I am not getting very far with it. select from city and display ready for check box selection. [code] echo "Select Cities and Towns"; echo ""; $queryC="SELECT CountyID, City, CityID FROM city WHERE CountyID=".$CountyID." ORDER BY City"; $result=mysql_query($queryC,$con_id); $count=0; echo ""; while($row=mysql_fetch_array($result)){ $county_id=$row['CountyID']; $city_id=$row['CityID']; $city=$row['City']; if ($CityID == $city_id) $city="city_".$cityId; echo"$city"; $count++; if($count ==3){ echo ""; $count=0; } } [/code] once selected this is the form that should do the inserts -> [code] [/code] tables structure: # # Table structure for table `city` # CREATE TABLE city ( CountyID int(10) unsigned NOT NULL default '0', City varchar(100) NOT NULL default '', CityID bigint(20) NOT NULL auto_increment, MoPID int(10) unsigned NOT NULL default '0', PRIMARY KEY (CityID), KEY CountyID (CountyID), KEY MoPID (MoPID) ) TYPE=MyISAM; # # # Table structure for table `item_city` # CREATE TABLE item_city ( id int(11) NOT NULL auto_increment, item_id int(11) default NULL, city_id int(11) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # # Table structure for table `items` # CREATE TABLE items ( ItemSKU varchar(25) NOT NULL default '', ItemName varchar(100) NOT NULL default '', ItemDescription mediumtext NOT NULL, PostCode varchar(100) NOT NULL default '', Category bigint(20) NOT NULL default '0', CityID bigint(20) NOT NULL default '0', CTelephone varchar(100) NOT NULL default '', ItemID bigint(20) NOT NULL auto_increment, Cfax varchar(100) NOT NULL default '', Cemail varchar(200) NOT NULL default '', Caddress varchar(200) NOT NULL default '', CTown varchar(200) NOT NULL default '', Cwww varchar(200) NOT NULL default '', PRIMARY KEY (ItemID) ) TYPE=MyISAM; I have looked at this for too long and seem to be seeing the same thing :( so if someone can see something aloof that would be great :) Andrew ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gotten pass one problem to land into another
I've managed to fix one problem with the MySQL and phpMyAdmin to only get a different error message> Fatal error: Call to undefined function: mysql_connect() in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 Okay this line refers to the host, user and password, that should be (I'm guessing here) in the config.inc.php3 file in the stduser area. I've tried both with and without user info in this file and still I get the same error. So my question is do I have to have a username and password in config.inc.php3 in order for phpMyAdmin to work? Also do I have to restart MySQL and Apache? Since this is an internal system I have Apache ServerName set to 127.0.0.1, is this okay? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au "I don't know the key to success, but the key to failure is trying to please everybody." -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re; phpMyAdmin
I'm having problems getting phpMyadmin to work with MySQL. Using the following: RH7.3 completely patched MySQL-3.23.54a-3.73 php-4.1.2-7.3.6 phpMyAdmin-2.1.0-1 There is a setting in config.inc.php3 that you are supposed to set to the complete path to your phpMyAdmin. I've set mine as such, is this correct? $cfg['PmaAbsoluteUri'] http://192.168.1.11/var/www/html/phpMyAdmin/ No matter what I try I get "The connection was refused when attempting to contact 192.168.1.11". Can someone please help. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au "I don't know the key to success, but the key to failure is trying to please everybody." -Bill Cosby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A query problem...
try: SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 GROUP BY urun.`ID` HAVING `Mevcut Miktar`<>0 regds, -Original Message- From: Aziz DURMAZ [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 13:54 To: Uttam; [EMAIL PROTECTED] Subject: RE: A query problem... Its gives an error. SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 AND (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))<>0 GROUP BY urun.`ID` --- Th error says : Invalid use of group function. Can you help me?? -Original Message- From: Uttam [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 4:06 PM To: 'Aziz DURMAZ'; [EMAIL PROTECTED] Subject: RE: A query problem... >But i dont want to get a row which `Mevcut Miktar`=0 >How i can modify my query. - SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 AND (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))<>0 GROUP BY urun.`ID` regds, -Original Message- From: Aziz DURMAZ [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 14:06 To: [EMAIL PROTECTED] Subject: A query problem... this is my query: SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 GROUP BY urun.`ID` But i dont want to get a row which `Mevcut Miktar`=0 How i can modify my query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A query problem...
Its gives an error. SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 AND (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))<>0 GROUP BY urun.`ID` --- Th error says : Invalid use of group function. Can you help me?? -Original Message- From: Uttam [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 4:06 PM To: 'Aziz DURMAZ'; [EMAIL PROTECTED] Subject: RE: A query problem... >But i dont want to get a row which `Mevcut Miktar`=0 >How i can modify my query. - SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 AND (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar))<>0 GROUP BY urun.`ID` regds, -Original Message- From: Aziz DURMAZ [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 14:06 To: [EMAIL PROTECTED] Subject: A query problem... this is my query: SELECT urun.`StokKodu`, urun.`Isim`, (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) AS `Mevcut Miktar` FROM rootdata.urun AS urun, seconddata.depohareket AS depo WHERE urun.`ID` = depo.`UrunID` AND depo.`Iptal` = 0 AND urun.`HizmetUrunu` = 0 GROUP BY urun.`ID` But i dont want to get a row which `Mevcut Miktar`=0 How i can modify my query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php