{"id":140,"date":"2006-09-17T11:43:21","date_gmt":"2006-09-17T16:43:21","guid":{"rendered":"http:\/\/softbeam.net\/hobby\/?p=140"},"modified":"2006-09-17T11:43:21","modified_gmt":"2006-09-17T16:43:21","slug":"mysql-select-syntax","status":"publish","type":"post","link":"http:\/\/softbeam.net\/hobby\/?p=140","title":{"rendered":"mysql select syntax"},"content":{"rendered":"<p><!--DATA[SELECT<-->SELECT<br \/>\n[ALL | DISTINCT | DISTINCTROW ]<\/p>\n<p>[HIGH_PRIORITY]<\/p>\n<p>[STRAIGHT_JOIN]<\/p>\n<p>[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]<\/p>\n<p>[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]<\/p>\n<p>select_expr, &#8230;<\/p>\n<p>[FROM table_references<\/p>\n<p>[WHERE where_condition]<\/p>\n<p>[GROUP BY {col_name | expr | position}<\/p>\n<p>[ASC | DESC], &#8230; [WITH ROLLUP]]<\/p>\n<p>[HAVING where_condition]<\/p>\n<p>[ORDER BY {col_name | expr | position}<\/p>\n<p>[ASC | DESC], &#8230;]<\/p>\n<p>[LIMIT {[offset,] row_count | row_count OFFSET offset}]<\/p>\n<p>[PROCEDURE procedure_name(argument_list)]<\/p>\n<p>[INTO OUTFILE &#8216;file_name&#8217; export_options<\/p>\n<p>| INTO DUMPFILE &#8216;file_name&#8217;<\/p>\n<p>| INTO @var_name [, @var_name]]<\/p>\n<p>[FOR UPDATE | LOCK IN SHARE MODE]]]]&gt;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr, &#8230; [FROM table_references [WHERE where_condition] [GROUP BY {col_name | expr | position} [ASC | DESC], &#8230; [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], &#8230;] [LIMIT {[offset,] row_count | row_count OFFSET offset}] &hellip; <a href=\"http:\/\/softbeam.net\/hobby\/?p=140\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;mysql select syntax&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts\/140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=140"}],"version-history":[{"count":0,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=\/wp\/v2\/posts\/140\/revisions"}],"wp:attachment":[{"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/softbeam.net\/hobby\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}