Forum » Programiranje » MYSQL Field 'xxx' doesn't have a default value
MYSQL Field 'xxx' doesn't have a default value

BRBR ::
Insert dela kot treba, xxx se nafila v TRIGERJIH on before insert, on before update
Ko pa pride do duplicate key:
Insert into t (f1,...) values ('foo',...) --> duplicate key violation. OK expected.
če pa dodam še ignore al pa o duplicte key update
--> Field 'xxx' doesn't have a default value
?
Ko pa pride do duplicate key:
Insert into t (f1,...) values ('foo',...) --> duplicate key violation. OK expected.
če pa dodam še ignore al pa o duplicte key update
--> Field 'xxx' doesn't have a default value
?
- spremenil: BRBR ()
Vredno ogleda ...
| Tema | Ogledi | Zadnje sporočilo | |
|---|---|---|---|
| Tema | Ogledi | Zadnje sporočilo | |
| » | oracle 12 identity (the old way)Oddelek: Programiranje | 1191 (996) | detroit |
| » | Nova različica podatkovne baze PostgreSQL 9.5 prinaša obilico novosti (strani: 1 2 )Oddelek: Novice / Ostala programska oprema | 20397 (17263) | McAjvar |
| » | [Java] Evidenca delovnega časa - Java v navezi z AccessomOddelek: Programiranje | 3456 (2676) | c0dehunter |
| » | napaka na forumuOddelek: Slo-Tech | 1665 (1363) | Vuco |
