Hmmm......
Izgleda da se nisam dobro izrazio, pa zarad boljeg objasnjenja dacu tacan izgled tabele.
Code:
+---------+---------------------------------+------+-----+-------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------------------+------+-----+-------------------------+-------+
| sifvp | smallint(3) unsigned zerofill | NO | MUL | 000 | |
| ppozbr | decimal(23,0) unsigned zerofill | NO | | 00000000000000000000000 | |
| kpozbr | decimal(23,0) unsigned zerofill | NO | | 00000000000000000000000 | |
| bikzr1 | smallint(3) unsigned zerofill | NO | | 000 | |
| bikzr2 | bigint(13) unsigned zerofill | NO | | 0000000000000 | |
| bikzr3 | smallint(2) unsigned zerofill | NO | | 00 | |
| konsif | varchar(8) | NO | MUL | 00000000 | |
+---------+---------------------------------+------+-----+-------------------------+-------+
+-------+-------------------------+-------------------------+--------+---------------+--------+----------+
| sifvp | ppozbr | kpozbr | bikzr1 | bikzr2 | bikzr3 | konsif |
+-------+-------------------------+-------------------------+--------+---------------+--------+----------+
| 221 | 00000000000000000012345 | 00000000000000000020000 | 245 | 0023002101024 | 04 | 10100001 |
| 221 | 00000000000000000002001 | 00000000000000000002200 | 245 | 0023002101024 | 04 | 10100001 |
| 221 | 00000000000000000000000 | 00000000000000000000000 | 310 | 0000000010039 | 69 | 10100001 |
| 000 | 00000000000000000000000 | 00000000000000000000000 | 000 | 0000000000000 | 00 | 10100001 |
| 221 | 00000000000000000000000 | 00000000000000000000000 | 245 | 0023002101024 | 04 | 10100001 |
| 221 | 00000000000000000000000 | 00000000000000000000000 | 000 | 0000000000000 | 00 | 20202 |
| 222 | 00000000000000000000001 | 00000000000000000001000 | 000 | 0000000000000 | 00 | 10100001 |
| 223 | 00000000000000000000001 | 00000000000000000000200 | 310 | 0000000010039 | 69 | 20202 |
| 221 | 00000000000000000000010 | 00000000000000000000200 | 000 | 0000000000000 | 00 | 0 |
+-------+-------------------------+-------------------------+--------+---------------+--------+----------+
Polja su setovana sa vodecim nulama.
Ovo je spisak "bitnih" polja koja su mi potrebna za kreiranje upita (sortiranja). U tabeli postoje i kljucna polja koja nisam naveo.
Nadam se da ce ovo bar malo razjasniti problem...