Tag: sql-insert

59 votes
6 answers
1.3K views
Postgres error: null value in column "id" - during insert operation

I use postgresql and yii2 framework. Well I got a very interesting error message: SQLSTATE[23502]: Not null v

avatar
Charis
0 1 0 9
asked 07 September, 2021
57 votes
5 answers
469 views
Column count doesn't match value count at row 1

So I read the other posts but this question is unique. So this SQL dump file has this as the last entry. INSE

avatar
Keith
0 1 0 9
asked 07 September, 2021
54 votes
10 answers
1.7K views
How can I do 'insert if not exists' in MySQL?

I started by googling and found the article How to write INSERT if NOT EXISTS queries in standard SQL which ta

avatar
Bryan
0 1 0 9
asked 07 September, 2021