[ADMIN] Mailing lists back in service.

2003-03-22 Thread MySQL List Administrator
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 requi

RE: UPDATE syntax help

2003-03-22 Thread [EMAIL PROTECTED]
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 hel

Re: Using ssh tunnel and mysql

2003-03-22 Thread Paul DuBois
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. I

SET CHARACTER SET DEFAULT is not working in 4.0.12

2003-03-22 Thread petr
>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

RE: InterBase vs. Mysql

2003-03-22 Thread David Axmark
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 mark

Wrong mysql.sock

2003-03-22 Thread Ville Mattila
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 scrip

Two Tables Diplay Using PHP

2003-03-22 Thread Andrew
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,

ÃÀÒÁ¿ªÕ½ÒÔºó

2003-03-22 Thread ÖйúÈË
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

Re: MySql Install on a AIX RS6000

2003-03-22 Thread Ares Liu
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 hav

Re: gotten pass one problem to land into another

2003-03-22 Thread lasse
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 fi

MySQL Two Tables - PHP Query Insert UPdate

2003-03-22 Thread Andrew
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"; e

gotten pass one problem to land into another

2003-03-22 Thread Jon Miller
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 h

re; phpMyAdmin

2003-03-22 Thread Jon Miller
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 th

RE: A query problem...

2003-03-22 Thread Uttam
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`

RE: A query problem...

2003-03-22 Thread Aziz DURMAZ
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,