The yb-admin utility, located in the bin directory of YugabyteDB home, provides a command line interface for administering clusters. Two of its many command options, list_all_masters […]
Read MoreDisable Foreign Key Constraint Checks with COPY
The COPY statement can be used to transfer data between tables and files. COPY TO copies from tables to files. COPY FROM […]
Read MoreUsing Session Variables
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 MoreList 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 More