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
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
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
>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
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
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
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,
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
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
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
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
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
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
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`
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,
15 matches
Mail list logo