YugabyteDB lets you declare session variables and use them in a YSQL statement or stored procedure. Example: yugabyte=# SELECT * FROM test_schema.test_table; […]
Read More
List Table Column Names and Data Types
In YSQL you can query the system table INFORMATION_SCHEMA.COLUMNS to list details about each of the columns in table. Example: yugabyte=# CREATE […]
Read MoreSimulate the DUAL table in YCQL
In YugabyteDB YCQL, the SELECT statement must have a FROM clause. However, some queries don’t require any table. Example: ycqlsh> SELECT currenttimestamp(); […]
Read MoreDisplay the Number of Tablets (Shards) for a Table
By default, YugabyteDB presplits a table in ysql_num_shards_per_tserver * num_of_tserver shards. We can display the number of tablets for a table using the […]
Read More