Victoria Reznichenko wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses latin1 character set and you have compiled only
with
Victoria Reznichenko wrote:
Cyril,
Monday, September 30, 2002, 3:35:40 PM, you wrote:
Cyril,
Friday, September 27, 2002, 4:19:25 PM, you wrote:
CZ if I build mysql with
CZ ./configure --with-charset=koi8_ru
CZ then check (make; make check; make test) failed!
Because MySQL by default uses
Victoria Reznichenko wrote:
Cyril,
Thursday, September 26, 2002, 11:30:39 PM, you wrote:
CZ ---cut---
mysql DROP TABLE IF EXISTS COUNTRIES;
CZ Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
CZ - PRIMARY KEY (Name) );
CZ
Please read following text only with koi8-r codepage!
---cut---
mysql DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
- PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO
Today I'm discovered strange behavior of SQL query
UPDATE tablename SET value=value+const WHERE ...
UPDATE tablename SET value=value-const WHERE ...
UPDATE tablename SET value=value*const WHERE ...
UPDATE tablename SET value=value/const WHERE ...
I have incorrect results of this queries only in