About 1,149,285 results (3,577 milliseconds)

Developing a WeeWX-Driver for custom weather station hardware ...

https://groups.google.com/g/weewx-development/c/4zh4SRgcvOk
It queries an external MySQL database and selects all datasets (rows, and ... You get a "duplicate key" error from the database, which is logged, but ignored.

MySQL issues with long multiple keyword queries

https://groups.google.com/g/resourcespace/c/qgF2vVt4FUw
Every so often I'm getting a query that just hammers my MySQL database, and basically stops ResourceSpace in its tracks. I wasn't really sure what was ...

DELETE from table1, table2 WHERE id=12345

https://groups.google.com/g/comp.databases.mysql/c/ZSDvWOAdemE
Feb 2, 2012 ... deleting from multiple tables, I an not quite certain why you didn't ... mysql> insert into child values (1,1),(2,2),(3,3); Query OK, 3 ...

Transferring from HandBase

https://groups.google.com/g/mementodatabase/c/0ULbL4EJK4o
Which means that every time you set up a new Library you must recreated all the "links" between records/tables. In a traditional database, key fields are ...

Diagnose issues | Datastream | Google Cloud

https://cloud.google.com/datastream/docs/diagnose-issues
Confirm that the binary log format of the MySQL database is set to ROW . ... This might cause duplicate rows to be written to BigQuery when you perform ...

Optimizing out unused annotations from count queries

https://groups.google.com/g/django-developers/c/dJg-FFowT1s
Aug 19, 2017 ... If `related` is a nullable foreign key, then a join would do an implicit filter, removing the row from the result set if it had no relation, and ...

Duplicate exported resources

https://groups.google.com/g/puppet-users/c/uAxbiIYH6Q4
> duplicate errors). > > Looking at the puppet DB resources table I see this: > mysql> select * from resources where title = 'proxy1back';.

Read data from a database and show it in Google Charts

https://groups.google.com/g/google-visualization-api/c/UdOFybnvFo0
... mySQL database for allocation tables array('label' => 'nav', 'type' => 'number'), );. $rows = array(); while($r = mysqli_fetch_assoc($result)) { $temp ...

Can't connect to Squert

https://groups.google.com/g/security-onion/c/qpQRgXFYkDo
On the master server, edit /etc/elsa_web.conf, remove the sensor from the peers section, then restart Apache (sudo service apache2 restart). In MySQL database ...

Events and streams | Datastream | Google Cloud

https://cloud.google.com/datastream/docs/events-and-streams
... remove duplicate data in the destination and order events by the downstream consumer. ... DELETE , on a single row in a SAMPLE table for a source database.

How to test a query's syntax using MySQL without ... - Google Answers

http://answers.google.com/answers/threadview/id/730396.html
May 19, 2006 ... In the case of tables such as zip codes containing 40,000+ rows or ... Otherwise, get your code and tables stable, then remove the ...

How to simply remove duplicate data from sqlite table

https://groups.google.com/g/web2py/c/_oUz6cy5PBs
Dec 7, 2009 ... (that I have obtained by importing in web2py an excel-generated CSV file). Now I see that in fact the original CSV data included many duplicate ...

Batch Insert / Updates with Upset

https://groups.google.com/g/jooq-user/c/nIdQNLAj6wk
Prior to 3.9, ON CONFLICT is already emulated via MySQL's ON DUPLICATE KEY UPDATE syntax, in case of which the primary key (from your generated table) will be ...

Slow loading for large (~70k articles) site

https://groups.google.com/g/joomla-dev-general/c/sVFw9reqGGw
... MySQL will optimise data access. Of course getting rid of the contact ... Query OK, 0 rows affected (0.50 sec) Records: 0 Duplicates: 0 Warnings: 0

Switch to database-level autocommit

https://groups.google.com/g/django-developers/c/U4-XcmvWLJ4
> and will break with the change. http://stackoverflow.com/questions/8965391/delete-duplicate-rows-in-django-db. In fact this code is already unsafe under MySQL ...

FAQ | Datastream | Google Cloud

https://cloud.google.com/datastream/docs/faq
The additional metadata that Datastream writes to each event can be used to remove duplicate data. ... data from a MySQL database: SELECT; REPLICATION SLAVE ...

Adding a primary key in a huge CloudSQL table

https://groups.google.com/g/google-cloud-sql-discuss/c/N9kWoOS67VY/m/fmZwLfpcBQAJ
Apr 25, 2016 ... It is composed of 52 million rows of 20 columns each. I would like to add one, since I will remove duplicates and doing so without primary key ...

Duplicate entry '0' for key 'PRIMARY'

https://groups.google.com/g/comp.databases.mysql/c/X03A7rronBU
Therefore, the *proper* (MySQL) statement to delete all records in table ... I'm using rails schema:load to create mysql databases. After they're created I ...

Kafka Connect JDBC produces duplicate messages in timestamp+ ...

https://groups.google.com/g/confluent-platform/c/QVhuLqoTLvE
The way I "resolved" it was more by making sure the entries were idempotent. For example, since I was using reading rows from a database, reading the same row ...

Schemifier and indexes in a migrated mysql db

https://groups.google.com/g/liftweb/c/i3XDAPBGIfs
java.sql.SQLSyntaxErrorException: Duplicate key name 'offer_location' ... distinct to remove the duplicates. I have not investigated the ResultSet in ...