The UPDATE statement modifies the values of specified columns in all rows that meet certain conditions. When no conditions are specified in […]
Read More
Move Data from One Table to Another Table in One Command
You can move data from one table to another in two SQL commands, an INSERT followed by a DELETE. But it’s possible […]
Read MoreAdd Columns to a View in YSQL
In YSQL, a view is the result set of a stored query, which can be queried in the same manner as a […]
Read MoreUpdate Current Rows When Adding a Column with a Default
A table column in YSQL can have a default value. If an INSERT statement does not specify a value for the column, […]
Read MoreAvoid Upsert in YCQL
By default, inserts into a YCQL table overwrite data on primary key collisions. So INSERTs do an UPSERT. This an intended CQL […]
Read More