GridDB- How to display actual records in ubunto gridDB shell
I have created a table and I want to return the inserted rows in gridDB shell.
When I try to get records using this query:
select email from users where id = 1
The above query returns 1 results. (5 ms) but I want to return the record in the results like in this case it should display an email in the results. Is it possible in the GridDB.
Solution
To view the query result on GridDB shell, make use of the command;
get
The get command can also be used with a number like get 20 to get only 20 from query results.
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- SQL Management Studio can't drag table / object from Explorer to Query Editor
- How can I put a where condition on a SqLite view statement?
- Get 2 Digit Number For The Month
- Set a column unique without being the primary key
- How to simulate a deadlock in SQL Server in a single process?
- "The big SQL RegEx": How do I RegEx split a SQL query?
- Determine column to insert into based on content
- Can a 4 column address be merged into a 2 columns address with a SELECT statement?
- How to write a "recursive update"?
- hierarchical query in Oracle
- How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
- Find patients admitted multiple times for the same primary diagnosis in SQL
- Updating SQL Server records with replace
- Export data from dynamic XML hierarchy in SQL Server
- How to resolve this error Ora-25137 "Data Value Out of range" in oracle
- Writing a SQL Query with multiple Where statements
- VBA - Convert a few numeric cells as text
- MySql: unknown column id in 'field list'
- SQL Server TDS protocol response problem when calling a stored procedure
- Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
- Count matching value in two columns in SQL
- Why UNION and UNION ALL don't work in my code?
- Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
- PostgreSQL: Give all permissions to a user on a PostgreSQL database
- How does group by works in sequelize?
- Cursor bug when editing sql file
- Add a given value from a column based on the value from another column
- How can I make SQL case sensitive string comparison on MySQL?
- How to fix "java.sql.SQLException: Can't call commit when autocommit=true"