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...
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; 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
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
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 Townsbr;
echo /td/tr;
$queryC=SELECT CountyID, City, CityID FROM city WHERE CountyID=.$CountyID.
ORDER BY City;
$result=mysql_query($queryC,$con_id);
$count=0;
echo tr;
while($row=mysql_fetch_array($result)){
$county_id=$row['CountyID'];
$city_id=$row['CityID'];
$city=$row['City'];
if ($CityID == $city_id)
$city=city_.$cityId;
echotd width=\25%\input type=\checkbox\ name=\$city_id\$city/td;
$count++;
if($count ==3){
echo /trtr;
$count=0;
}
}
[/code]
once selected this is the form that should do the inserts -
[code]
?
require(connection.php);
DBInfo();
Root();
$con_id=mysql_connect($DBHost,$DBUser,$DBPass);
mysql_select_db($DBName);
mysql($DBName,INSERT INTO Items VALUES(
'$ItemSKU',
'$ItemName',
'$ItemDescription',
'$PostCode',
'$Category',
'$CityID',
'$CTelephone',
'$ItemID',
'$Cfax',
'$Cemail',
'$Caddress',
'$CTown',
'$Cwww'));
$nItemId=mysql_insert_id();
$queryC=select * from city;
$result=mysql_query($queryC,$con_id);
while($row=mysql_fetch_array($result)){
$cityId=$row['CityID'];
$city=city_.$cityId;
$c=$$city;
if($c == on){
$query1=insert into item_city (item_id,city_id)values('$nItemId','$cityId');
$result1=mysql_query($query1);
}
}
/
?
[/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
Re: gotten pass one problem to land into another
Have you really compiled php with mysqlsupport? undefined function make an phpinfo.php containing just ? phpionfo(); ? 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
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
ÃÀÒÁ¿ªÕ½ÒÔºó
A href=http://since.vip.sina.com/;IMG height=137 alt= src=http://since.vip.sina.com/pic/war_top_fire.gif; width=750 border=0/A = http://www.chinamysql.com 100M1010M20318/ http://3long.sayba.com 5881800 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
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
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
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
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: 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
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]
[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]
