About 1,125,348 results (1,592 milliseconds)

Gracefully handling null values with properties()

https://groups.google.com/g/gremlin-users/c/v_vW-9fOCdY
Apr 21, 2021 ... remove ones which are problematic and its associated edges or 2.) "fix" these values by replacing with a constant? Thanks for the help!

database/sql scan to int error (with mymysql and gomysql drivers)

https://groups.google.com/g/golang-nuts/c/fPlr3go-B50
NULL and 0 are not the same thing. If you want NULL to be interpreted as 0, modify your query by using the COALESCE function in SQL: COALESCE(x, 0) returns the ...

Possible to delete records using the connector?

https://groups.google.com/a/lists.datastax.com/g/spark-connector-user/c/G9ClJHY9WVA
Nov 11, 2015 ... ... way to delete records using the Spark Cassandra connector? Or do you need to use the Java driver and execute "DELETE" statements directly?

rows.Scan null values in database/sql error

https://groups.google.com/g/golang-nuts/c/nXB94-3ls-4
rows, err := db.Query( "SELECT 1 as id, null as name" ) if err != nil { fmt ... Delete. You do not have permission to delete messages in this group. Copy link.

[REQUEST FOR FEEDBACK] Handling of NULL in jOOQ's ...

https://groups.google.com/g/jooq-user/c/xmkOXh6VxdQ
... queries, as jOOQ is then "swallowing" these particular null bind values. My ... sql-incompatibilities-not-in-and-null-values/. Heh. Did I mention that ...

jooq condition to select empty and null values for column

https://groups.google.com/g/jooq-user/c/NxD98CsKpHs
Nov 4, 2014 ... then insert, '',NULL,'xyz' value. both empty and null conditions are not working for me via JOOQ API, however SQL formed by JOOQ does execute ...

Modifying table schemas | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-table-schemas
... values in the new columns are set to NULL for existing rows. To add a new ... The SQL query used in the query job would be SELECT column_two, column_three ...

debezium source mysql, delete record, only get 'null', and the jdbc ...

https://groups.google.com/g/debezium/c/LqtxrtkjFzQ
Sep 14, 2018 ... "database.server.name": "flattened", "database.history.kafka ... delete marked records with some kind of batch job...... Sanat ...

SQLiteDatabase | Android Developers

http://code.google.com/android/reference/android/database/sqlite/SQLiteDatabase.html
... row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all ...

Data definition language (DDL) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language
You can use DDL commands to create, alter, and delete resources, such as tables, table clones, table snapshots, views, user-defined functions (UDFs), and row- ...

Error truncating performance_schema tables

https://groups.google.com/g/google-cloud-sql-discuss/c/KmXOjqkSwzk/m/uh6Vkcu9BAAJ
Is there a way to delete rows from this table? Are folks able to use ... NULL row would be counted using more specific rows instead. To do this, set the ...

GoogleSQL data definition language | Cloud Spanner | Google Cloud

https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language
... remove a change stream from the database and delete its data change records. ... After you delete a model definition, all SQL queries referencing the deleted ...

Cache & SQL - Working with Empty/NULL Results

https://groups.google.com/g/intersystems-public-cache/c/gnHUa4SLTKM
What would be the best method for excluding NULL results when making the SQL query? ... rows: WHERE <column> is NULL... -- -- Caché, Ensemble, DeepSee ---

GoogleSQL data manipulation language | Cloud Spanner | Google ...

https://cloud.google.com/spanner/docs/reference/standard-sql/dml-syntax
... query result: FanId. 6af91072-f009-4c15-8c42-ebe38ae83751. DELETE statement. Use the DELETE statement to delete rows from a table. DELETE [FROM] table_name ...

Error: Call to a member function delete() on null in ...

https://groups.google.com/d/topic/ica-atom-users/CmU5DgZnL6k
Jul 14, 2017 ... ... rows in your database. In ... Constructing SQL queries for AtoM: https://www.slideshare.net/accesstomemory/constructing-sql-queries-for-atom ...

Need Help Removing Blank Lines in Sorted Query Results - Google ...

https://support.google.com/docs/thread/14946982/need-help-removing-blank-lines-in-sorted-query-results?hl=en
Sep 21, 2019 ... This can be found on the 'Copy of Sheet 6' tab. But now there is a HUGE gap of space (multiple blank rows) between the header row and the actual ...

scanning an sql NULL into an int or string

https://groups.google.com/g/golang-dev/c/O1SiEOfMMGo
Nov 15, 2011 ... ... SQL select statement from a table containing NULL values. rows, err := db.Query("SELECT name, age FROM people") ... for rows.Next {. var name ...

Delete all rows in BigQuery and other DML statements to add ...

https://cloud.google.com/blog/topics/developers-practitioners/bigquery-explained-data-manipulation-dml
Nov 13, 2020 ... BigQuery has supported Data Manipulation Language (DML) functionality since 2016 for standard SQL, which enables you to insert, update, ...

Spatial tables with null geometries

https://groups.google.com/d/topic/spatialite-users/iiZeD-u3cE4
Deleting rows with null geometries is one alternative and updating the null ... the above SQL will surely fail; the clean way to do such a thing is as shown ...

Data manipulation language (DML) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
Use the DELETE statement when you want to delete rows from a table. DELETE ... NULL = NULL evaluates to NULL instead of TRUE , and creates duplicate rows in the ...