Ok I have done this with two commnads where first check if record exist. I tried do this with one command because I want to speed up importing from csv. CSV has one table for example: name | surname | country. I want split repeated columns to dictionary tables like:
table customers - name - surname - id_country // FK to table countries I'm looking for one command which before inserting to "customers" will look to table countries and check if country exists, if not then insert and return id, else return existing id. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users