14,953
edits
Elasticsearch: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 23: | Line 23: | ||
<pre> | <pre> | ||
TRUNCATE MY_TABLE | TRUNCATE MY_TABLE | ||
</pre> | |||
== Create the index == | |||
Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-create-index.html#mappings Create index API | Elasticsearch Guide [8.15] | Elastic] | |||
<pre> | |||
PUT /MY_INXEX | |||
{ | |||
"mappings": { | |||
"properties": { | |||
"field1": { "type": "text" } | |||
} | |||
} | |||
} | |||
</pre> | |||
MySQL [https://dev.mysql.com/doc/refman/8.4/en/create-table.html MySQL :: MySQL 8.4 Reference Manual :: 15.1.20 CREATE TABLE Statement] | |||
<pre> | |||
CREATE TABLE MY_TABLE ( | |||
id INT AUTO_INCREMENT PRIMARY KEY, | |||
field1 TEXT | |||
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; | |||
</pre> | </pre> | ||