sql-insert – Page 3 – Tarik Billa

Conditional INSERT INTO statement in postgres

February 24, 2023 by Tarik

That specific command can be done like this: insert into LeadCustomer (Firstname, Surname, BillingAddress, email) select ‘John’, ‘Smith’, ‘6 Brewery close, Buxton, Norfolk’, ‘cmp.testing@example.com’ where not exists ( select 1 from leadcustomer where firstname=”John” and surname=”Smith” ); It will insert the result of the select statement, and the select will only return a row if … Read more

PHP MYSQL UPDATE if Exist or INSERT if not?

February 14, 2023 by Tarik

I believe you are looking for the following syntax: INSERT INTO <table> (field1, field2, field3, …) VALUES (‘value1’, ‘value2′,’value3′, …) ON DUPLICATE KEY UPDATE field1=’value1′, field2=’value2′, field3=’value3’, … Note: With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row … Read more

In SQL, is UPDATE always faster than DELETE+INSERT?

January 26, 2023 by Tarik

A bit too late with this answer, but since I faced a similar question, I made a test with JMeter and a MySQL server on same machine, where I have used: A transaction Controller (generating parent sample) that contained two JDBC Requests: a Delete and an Insert statement A sepparate JDBC Request containing the Update … Read more

SQL Error: ORA-01861: literal does not match format string 01861

January 14, 2023 by Tarik

Try replacing the string literal for date ‘1989-12-09’ with TO_DATE(‘1989-12-09′,’YYYY-MM-DD’)

Column count doesn’t match value count at row 1

January 6, 2023 by Tarik

The error means that you are providing not as much data as the table wp_posts does contain columns. And now the DB engine does not know in which columns to put your data. To overcome this you must provide the names of the columns you want to fill. Example: insert into wp_posts (column_name1, column_name2) values … Read more

MySQL and PHP – insert NULL rather than empty string

January 4, 2023 by Tarik

To pass a NULL to MySQL, you do just that. INSERT INTO table (field,field2) VALUES (NULL,3) So, in your code, check if $intLat, $intLng are empty, if they are, use NULL instead of ‘$intLat’ or ‘$intLng’. $intLat = !empty($intLat) ? “‘$intLat'” : “NULL”; $intLng = !empty($intLng) ? “‘$intLng'” : “NULL”; $query = “INSERT INTO data … Read more

Saving timestamp in mysql table using php

January 2, 2023 by Tarik

pass like this date(‘Y-m-d H:i:s’,’1299762201428′)

INSERT vs INSERT INTO

December 31, 2022 by Tarik

INSERT INTO is the standard. Even though INTO is optional in most implementations, it’s required in a few, so it’s a good idea to include it if you want your code to be portable. You can find links to several versions of the SQL standard here. I found an HTML version of an older standard … Read more

Insert data in 3 tables at a time using Postgres

December 30, 2022 by Tarik

Use data-modifying CTEs: WITH ins1 AS ( INSERT INTO sample(firstname, lastname) VALUES (‘fai55’, ‘shaggk’) — ON CONFLICT DO NOTHING — optional addition in Postgres 9.5+ RETURNING id AS sample_id ) , ins2 AS ( INSERT INTO sample1 (sample_id, adddetails) SELECT sample_id, ‘ss’ FROM ins1 RETURNING user_id ) INSERT INTO sample2 (user_id, value) SELECT user_id, ‘ss2’ … Read more

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

December 26, 2022 by Tarik

You need to use bindValue, not bindParam bindParam takes a variable by reference, and doesn’t pull in a value at the time of calling bindParam. I found this in a comment on the PHP docs: bindValue(‘:param’, null, PDO::PARAM_INT); P.S. You may be tempted to do this bindValue(‘:param’, null, PDO::PARAM_NULL); but it did not work for … Read more