We can use the RETURNING clause to return values from the rows that were deleted using a bulk-delete statement! yugabyte=# CREATE TABLE […]
Read More
Export Data to a File Using YSQL (the Safe Way)
When exporting data to a file in YSQL I avoid using printable characters (commas, new-lines, pipe symbols, etc.) as field/record separators because […]
Read MoreDisplay User Friendly Text for NULL Values
By default YSQL will display NULL as an empty string which makes it impossible to distinguish NULL from a true empty string […]
Read MoreClearing the Screen in YSQL
Lots of old school folks (like myself) use YSQL for administrative tasks. As you enter commands, eventually the command prompt will end […]
Read MoreGenerate a Random Date Between Two Dates
As we learned in several earlier tips, we can create a random integer and a random string in YugabyteDB quite easily. But […]
Read More