Hi all I use a script to build a query and while testing this script by copy'ing it into the mysql console, it shows me a warning. However, the SHOW WARNINGS; is not available on versions < 4.
mysql> describe shop_products;
+------------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+------------------------+---------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| intid | varchar(100) | | MUL | |
|
| shopid | varchar(100) | | | |
|
| name | varchar(255) | | | |
|
| sdesc | varchar(250) | | MUL | |
|
| ldesc | text | | | |
|
| active | set('0','1') | | | 0 |
|
| visible | set('0','1') | | | 0 |
|
| stock | double | | | 0 |
|
| unit | varchar(100) | | | |
|
| units | varchar(100) | | | |
|
| unitprice | decimal(10,5) | | | 0.00000 |
|
| tax | double | | | 0 |
|
| min_units | double | | | 0 |
|
| max_units | double | | | 0 |
|
| delivery_inc_unitprice | decimal(10,5) | | | 0.00000 |
|
| delivery_tax | double | | | 0 |
|
| delivery_time | varchar(100) | | | |
|
+------------------------+---------------+------+-----+---------+----------------+
18 rows in set (0.00 sec)
mysql> UPDATE `shop_products` SET `name`='TestProd' , `shopid`='20-302' ,
`sdesc`='This is a test product' , `ldesc`='Long description for the test
product\r\n\r\nIt supports formatting but not objectss\r\n\r\n' ,
`unit`='piece' , `units`='pieces' , `stock`='10' , `unitprice`='20.00000' ,
`tax`='0' , `min_units`='1' , `max_units`='' ,
`delivery_inc_unitprice`='0.00000' , `delivery_tax`='0' , `delivery_time`='' ,
`visible`='1' , `active`='' WHERE `id`='1' LIMIT 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
To make you live a bit more easy, here is the same query but aligned
UPDATE `shop_products` SET
`name`='TestProd' ,
`shopid`='20-302' ,
`sdesc`='This is a test product' ,
`ldesc`='Long description for the test product\r\n\r\nIt supports
formatting but not objectss\r\n\r\n' ,
`unit`='piece' ,
`units`='pieces' ,
`stock`='10' ,
`unitprice`='20.00000' ,
`tax`='0' ,
`min_units`='1' ,
`max_units`='' ,
`delivery_inc_unitprice`='0.00000' ,
`delivery_tax`='0' ,
`delivery_time`='' ,
`visible`='1' ,
`active`=''
WHERE `id`='1' LIMIT 1;
I know active, and visible are sets, and that there is no value for active, but
I tried with active='0' and got the same warning.
Thanks in advance.
Kind regards
Andy
--
Registered Linux User Number 379093
-- ---BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT/O/CM d- s:+ a- C++++ UL++++ 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------
Check out these few php utilities that I released
under the GPL2 and that are meant for use with a
php cli binary:
http://www.vlaamse-kern.com/sas/
--
--
pgpqnJYBUP9Zo.pgp
Description: PGP signature
