Difference between revisions of "Select"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
(26 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{lowercase}}
 +
select
 +
[[select count]]
 +
[[select distinct]]
 +
 +
 +
[[PostgreSQL select]]:
 +
* <code> select * from your_table_name;</code>
 +
 +
* <code> select * from your_db.your_table_name;</code>
 +
 +
SELECT * FROM your_table_name;
 +
[[ERROR: permission denied for table]] your_table_name
 +
 +
[[SELECT version();]]
 +
[[SELECT current user;]]
 +
 +
* <code>[[select]] current_setting('[[block_size]]');</code>
 +
 +
 +
* [[MySQL]]: <code>[[select user]] FROM [[mysql.user]];</code>
  
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
*<code> select * from TABLE_NAME</code> ([[SQL]])
+
 
 +
 
 +
 
 +
== Related terms ==
 +
* [[MongoDB]]: <code>db.YOUR_COLLETION_NAME.[[find]] ()</code>
 +
* <code>[[select count]]</code>
 +
* <code>[[select distinct]]</code>
 +
* <code>[[GRANT SELECT]]</code>
 +
* <code>[[ERROR: permission denied for relation]] your_table</code>
 +
 
 +
== See also ==
 +
* {{SQL}}
 +
 
 +
[[Category:Computing]]

Revision as of 13:48, 8 November 2022

Advertising: