14,953
edits
Elasticsearch: Difference between revisions
Jump to navigation
Jump to search
→Select all data from index or table
No edit summary |
|||
| Line 119: | Line 119: | ||
SELECT * | SELECT * | ||
FROM MY_TABLE | FROM MY_TABLE | ||
</pre> | |||
== Select particular data from index or table == | |||
Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API | Elasticsearch Guide [8.15] | Elastic]</ref> | |||
<pre> | |||
GET /MY_INDEX/_search/?q=_id:1 | |||
</pre> | |||
MySQL<ref>[https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html MySQL :: MySQL 8.4 Reference Manual :: 5.3.4.2 Selecting Particular Rows]</ref> | |||
<pre> | |||
SELECT * | |||
FROM MY_TABLE | |||
WHERE id = 1 | |||
</pre> | </pre> | ||