current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. It's 100% free, no registration required.
up vote 1 down vote favorite

Is there a way to list available SQL commands at MySQL CLI? I mean if I type help at MySQL CLI I see various MySQL CLI specific commands like clear(\c) or tee(\T), but it would be handy to see a list of available SQL commands like SELECT or UPDATE for beginner.

share|improve this question

1 Answer 1

up vote 2 down vote

You can use:

help contents

to retrieve a list of the top-level help categories.
If you type:

help 'Data Manipulation'

Possible result will be:

CALL
DELETE
DO
DUAL
HANDLER
INSERT
INSERT DELAYED
INSERT SELECT
JOIN
LOAD DATA
LOAD XML
REPLACE
SELECT
UNION
UPDATE

More info you can find:

  1. Server-Side Help
  2. HELP Syntax
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.