57
votes
12
answers
674
views
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise caus
63
votes
3
answers
2.3K
views
insert into database from Joomla form fields
I am beginner to Joomla! development and have created a very simple module. How do I create a form with 3 tex
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
57
votes
5
answers
465
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
54
votes
11
answers
1.1K
views
Insert into a MySQL table or update if exists
I want to add a row to a database table, but if a row exists with the same unique key I want to update the row
52
votes
13
answers
2.1K
views
How to insert multiple rows from array using CodeIgniter framework?
I'm passing a large dataset into a MySQL table via PHP using insert commands and I'm wondering if it
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
