BiTel

[root@billing work]# mysql bgcrm -uroot -p --default-character-set=utf8 < address_data.sql
ERROR 1136 (21S01) at line 50: Column count doesn't match value count at row 1

CREATE TABLE  address_house (\
    id int(11) NOT NULL,\
    area_id int(11) NOT NULL,\
    quarter_id int(11) NOT NULL,\
    street_id int(11) NOT NULL,\
    house int(11) NOT NULL,\
    frac varchar(30) NOT NULL,\
    post_index varchar(10) NOT NULL,\
    comment varchar(100) NOT NULL,\
    last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);\

INSERT INTO $BASE_TEMP.address_house(id, area_id, quarter_id, street_id, house, frac, post_index, comment) SELECT id, areaid, quarterid, streetid, house, frac, box_index, comment FROM $BASE.address_house;\