Difference between revisions of "Select"

From wikieduonline
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 11: Line 11:
 
* <code>[[SELECT version();]]</code>
 
* <code>[[SELECT version();]]</code>
 
* <code>[[SELECT current user;]]</code>
 
* <code>[[SELECT current user;]]</code>
* <code>[[SELECT current database();</code>
+
* <code>[[SELECT current database();]]</code>
  
  
Line 24: Line 24:
 
* [[MySQL]]: <code>[[select user]] FROM [[mysql.user]];</code>
 
* [[MySQL]]: <code>[[select user]] FROM [[mysql.user]];</code>
  
 +
 +
[[jq]]:
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 +
* <code>cat file.txt | jq '.Quotas[] | select(.QuotaName | [[contains]]("G and VT")) | {QuotaName, Value, QuotaArn, QuotaCode, Unit}'</code>
  
  
Line 35: Line 38:
 
**<code>[[GRANT SELECT ON ALL TABLES]]</code>
 
**<code>[[GRANT SELECT ON ALL TABLES]]</code>
 
* <code>[[ERROR: permission denied for relation]] your_table</code>
 
* <code>[[ERROR: permission denied for relation]] your_table</code>
 +
* [[SELECT can cause synchronous writes on the disk]]
  
 
== See also ==
 
== See also ==

Latest revision as of 14:20, 22 May 2024

select 
select count
select distinct


PostgreSQL:


SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name




jq:

  • jq '.[] | select(.color=="blue")' your_json_file.json
  • cat file.txt | jq '.Quotas[] | select(.QuotaName | contains("G and VT")) | {QuotaName, Value, QuotaArn, QuotaCode, Unit}'


Related terms[edit]

See also[edit]

Advertising: