You can use a correlated subquery with a WHERE NOT EXISTS clause to ensure that your update will not generate duplicates, like : UPDATE mytable t SET (col1, col2) = (‘AAA’, ‘BBB’) WHERE t.col1 = ‘AAB’ and t.col2 = ‘BBA’ AND NOT EXISTS ( SELECT 1 FROM mytable WHERE col1 = ‘AAA’ AND col2 = … Read more
You can’t. However, you CAN use a transaction and have both of them be contained within one transaction. START TRANSACTION; INSERT INTO table1 VALUES (‘1′,’2′,’3’); INSERT INTO table2 VALUES (‘bob’,’smith’); COMMIT; http://dev.mysql.com/doc/refman/5.1/en/commit.html
You’re missing quotes around the first value, it should be INSERT INTO LOCATION VALUES(‘PQ95VM’, ‘HAPPY_STREET’, ‘FRANCE’); Incidentally, you’d be well-advised to specify the column names explicitly in the INSERT, for reasons of readability, maintainability and robustness, i.e. INSERT INTO LOCATION (POSTCODE, STREET_NAME, CITY) VALUES (‘PQ95VM’, ‘HAPPY_STREET’, ‘FRANCE’);
There are a number of factors at work here: Network latency and round-trip delays Per-statement overheads in PostgreSQL Context switches and scheduler delays COMMIT costs, if for people doing one commit per insert (you aren’t) COPY-specific optimisations for bulk loading Network latency If the server is remote, you might be “paying” a per-statement fixed time … Read more
Your column username seems to be an array type, so the literal ‘mahman’ is not valid input for it. It would have to be ‘{mahman}’: INSERT INTO user_data.user_data (username,randomint) VALUES (‘{mahman}’,1); (Or make it a plain varchar column or text column instead.) Update confirms it: character varying(50)[] is an array of character varying(50). About array … Read more
You may use -v : Verbose mode (show progress) in your command, or there’s another method using Pipe Viewer (pv) which shows the progress of the gzip, gunzip command as follows: $ pv database1.sql.gz | gunzip | mysql -u root -p database1 This will output progress similar to scp: $ pv database1.sql.gz | gunzip | … Read more
You’re looking for UPDATE not insert. UPDATE mytable SET table_column = ‘test’; UPDATE will change the values of existing rows (and can include a WHERE to make it only affect specific rows), whereas INSERT is adding a new row (which makes it look like it changed only the last row, but in effect is adding … Read more
Have you tried indicating to which fields of the table the parameters you are passing are supposed to be related? INSERT INTO table_name (column1, column2, column3,…) VALUES (value1, value2, value3,…) In your case maybe something like: INSERT INTO participants(col1, col2) VALUES (“bla”,”blub”);
Use executeUpdate instead of executeQuery if no data will be returned (i.e. a non-SELECT operation).
This might be a simple solution to achieve this: INSERT INTO funds (ID, date, price) SELECT 23, DATE(‘2013-02-12’), 22.5 FROM dual WHERE NOT EXISTS (SELECT 1 FROM funds WHERE ID = 23 AND date = DATE(‘2013-02-12’)); p.s. alternatively (if ID a primary key): INSERT INTO funds (ID, date, price) VALUES (23, DATE(‘2013-02-12’), 22.5) ON DUPLICATE … Read more