Description:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
D:\>cd \mysql\bin
D:\MySQL\bin>mysql -uroot -p1M22!K
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 5.0.4-beta-nt-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show local variables like 'date%';
+-----------------+-------------------+
| Variable_name | Value |
+-----------------+-------------------+
| date_format | %d.%m.%Y |
| datetime_format | %H.%i.%s %d.%m.%Y |
+-----------------+-------------------+
2 rows in set (0.00 sec)
mysql> show global variables like 'date%';
+-----------------+-------------------+
| Variable_name | Value |
+-----------------+-------------------+
| date_format | %d.%m.%Y |
| datetime_format | %H.%i.%s %d.%m.%Y |
+-----------------+-------------------+
2 rows in set (0.00 sec)
mysql> use eskom;
Database changed
mysql> desc su_tahakkuk;
+----------------------+--------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+------------+-------+
| TH_KEY | int(11) | NO | PRI | 0 | |
| SU_SI_KEY | int(11) | NO | MUL | 0 | |
| YIL | int(11) | NO | | 0 | |
| AY | int(11) | NO | | 0 | |
| ABONETIPI | int(11) | YES | | 0 | |
| DURUM | int(11) | YES | | 0 | |
| TUR | int(11) | YES | | 0 | |
| ILKENDEX | int(11) | YES | | 0 | |
| SONENDEX | int(11) | YES | | 0 | |
| KULLANILAN | int(11) | YES | | 0 | |
| ONCEKITAHAKKUKTARIHI | date | YES | | 0001-01-01 | |
| SONODEMETARIHI | date | YES | | NULL | |
| TAHAKKUKTARIHI | date | YES | | NULL | |
| ODEMETARIHI | date | YES | | NULL | |
| SOKMETARIHI | date | YES | | NULL | |
| TAKMATARIHI | date | YES | | NULL | |
| ENDEXKDV | double(15,2) | YES | | NULL | |
| ENDEXTUTAR | double(15,2) | YES | | NULL | |
| ARIZALI | int(11) | YES | | NULL | |
| SAYACSIZ | int(11) | YES | | NULL | |
| INSAATKALANM2 | varchar(10) | YES | | NULL | |
| INSAATTOPLAMM2 | double(15,2) | YES | | NULL | |
| INSAATODE | int(11) | YES | | NULL | |
| MUAFM3 | double(15,2) | YES | | NULL | |
| DIGERM3 | double(15,2) | YES | | NULL | |
| THKDURUM | int(11) | YES | | NULL | |
| FATURASERI | varchar(10) | YES | | NULL | |
| FATURASIRA | int(11) | YES | | NULL | |
| TOPLAMFARK | double(15,2) | YES | | NULL | |
| TOPLAMTUTAR | double(15,2) | YES | | NULL | |
| TOPLAMKDV | double(15,2) | YES | | NULL | |
| GENELTUTAR | double(15,2) | YES | | NULL | |
| USER_KEY | int(11) | YES | | NULL | |
| GECIKME | double(15,2) | YES | | NULL | |
| GECIKMEKDV | double(15,2) | YES | | NULL | |
| DONEMABONESI | varchar(30) | YES | | NULL | |
| ACIKLAMA1 | varchar(10) | YES | | NULL | |
| ACIKLAMA2 | varchar(100) | YES | | NULL | |
| ACIKLAMA3 | varchar(100) | YES | | NULL | |
| DEV1 | double(15,2) | YES | | NULL | |
| DEV2 | double(15,2) | YES | | NULL | |
+----------------------+--------------+------+-----+------------+-------+
41 rows in set (0.01 sec)
mysql> select th_key , sonodemetarihi from su_tahakkuk where th_key = 1;
+--------+----------------+
| th_key | sonodemetarihi |
+--------+----------------+
| 1 | 0000-00-00 |
+--------+----------------+
1 row in set (0.00 sec)
mysql> update su_tahakkuk set sonodemetarihi ='31.05.2005' where th_key =1 ;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
// mycomment : local and global date_format =%d.%m.%Y
mysql> select th_key , sonodemetarihi from su_tahakkuk where th_key = 1;
+--------+----------------+
| th_key | sonodemetarihi |
+--------+----------------+
| 1 | 0000-00-00 |
+--------+----------------+
1 row in set (0.00 sec)
mysql>
How to repeat:
always..
