This is an ADO and VB question.
All tables are MS Access, and in the same .MDB file.
I a updating a table, adding many rows. I do this by scrolling through a recordset extracted from another...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_11351037.html
Zones:
Visual BasicDate Answered: 09/22/2000 Rating: 8.0 Views: 0
update query is needed for MySQL
http://www.experts-exchange.com/Database/MySQL/Q_24356594.html
Zones:
MySQL ServerDate Answered: 04/26/2009 Rating: 9.1 Views: 68
Starting from version 4.1.0, MySQL supports "INSERT ... ON DUPLICATE KEY UPDATE ... " statement
i can see tis very handy when you want to insert or update some record depending of its existance......
http://www.experts-exchange.com/Database/MySQL/Q_20920874.html
Zones:
MySQL ServerDate Answered: 03/16/2004 Rating: 8.8 Views: 0
Hi ,
I am trying to write a query in Postgres, for inserting values into a table , however if that INSERT were to insert a row with a duplicate key, it should update the original record in some...
http://www.experts-exchange.com/Database/PostgreSQL/Q_21975826.html
Zones:
PostgreSQLDate Answered: 09/30/2006 Rating: 9.4 Views: 230
Here is a sample MySQL query. This SHOULD work:
INSERT INTO my_friends (member_id, user_id, nickname) VALUES('3674827634826','10','Jason'),('238479238784','10','New');
ON DUPLICATE KEY UPDATE n...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/...
Hi Experts
I'm trying to insert data thats gleaned from a SOAP request into an array and then inserted into a table.
The problem i'm having is that the source of the data has numerous duplicate...
http://www.experts-exchange.com/Database/MySQL/Q_22698237.html
Looking for information on how to do something like mySQL "INSERT ... ON DUPLICATE KEY UPDATE" where
"If you specify ON DUPLICATE KEY UPDATE, and a row is inserted that would cause a duplicate ...
http://www.experts-exchange.com/Database/MySQL/Q_22717905.html
Howdy - I'm a MySQL Noob. I have a table of various business listings and I am trying to populate a second table called cities that contains unique city names along with a count of how many listing...
http://www.experts-exchange.com/Database/Miscellaneous/Q_24889331.html
