All pastes #442607 Raw Edit

backup

public text v1 · immutable
·published 2007-04-16 11:15 UTC
rendered paste body
mysql> describe pripojky;
+-----------------+------------------------------------------------------------------+------+-----+----------+----------------+
| Field           | Type                                                             | Null | Key | Default  | Extra          |
+-----------------+------------------------------------------------------------------+------+-----+----------+----------------+
| user            | int(10)                                                          | NO   | MUL | 0        |                | 
| pripojka        | int(5)                                                           | NO   | PRI | NULL     | auto_increment | 
| netobj_id       | int(11)                                                          | YES  |     | NULL     |                | 
| parent_id       | int(11)                                                          | YES  |     | NULL     |                | 
| ap_id           | int(11)                                                          | YES  | MUL | 126      |                | 

 
 
mysql> describe apcka;  
+-----------+----------------------------------+------+-----+---------+----------------+
| Field     | Type                             | Null | Key | Default | Extra          |
+-----------+----------------------------------+------+-----+---------+----------------+
| id        | int(11)                          | NO   | PRI | NULL    | auto_increment | 
| netobj_id | int(11)                          | YES  |     | NULL    |                | 
| name      | varchar(255)                     | YES  | UNI | NULL    |                | 

V tabulce pripojky je vyplneno ap, nyni do tech tabulek je pridan sloupec netobj_id a parent_id. 

V tabulce netobj_id je ulozene nejake cislo a ja chci ulozit tu polozku do prvku parent_id.

Navaznost: pripojky(ap_id) == apcka(id);