MYSQL COMMAND LINE HELP IS YOUR TEACHER IN MYSQL!! (YOUR COMPUTER IS YOUR TEACHER)

REMEMBER THIS WHILE READING THE COMMANDS OR SYNTAX DOS, LINUX IN MYSQL AND SOME PROGRAMMING LANGUAGES.

REMEMBER THESE: [ ], …, |, < >, { }, (), / letter(s)

*WHAT IS BRACKET [ ] meaning OPTIONAL

Ex. SELECT [table] so you have to provide table name
SELECT [column…,] so you have to provide columns..

ANOTHER EXAMPLE:

Ex. SELECT [shoes] so you have to put SELECT [ALL TYPES OF SHOES] ex..SELECT [adidas]. SELECT [nike]

SYNTAX: SELECT [vegetables]

ex. SELECT [carrots], SELECT [potatoes] OTHERS NOT VEGETABLES ARE SYNTAX ERROR!

SIMPLE SYNTAX: DIR [DRIVE:]  —SO OPTIONAL

DIR

DIR [A:]

DIR [B:]

DIR [A:] up to DIR [ Z:]

*WHAT IS ELLIPSIS (…) THE 3 DOTS…

…(ELLIPSIS) continuity of parameters or commands or arguments

Ex. SELECT [columns…,]
SELECT name, age, sex, etc….

ex. PATH [DRIVE:] [directory …;]

PATH C:\WINDOWS; C:\WINDOWS\SYSTEM32;…………….AND SO ON!!

type: PATH in your CMD in windows 🙂 and PATH /?

*WHAT IS SPLIT VERTICAL BAR (|)

| CHOOSE in-between CHOICES

Ex. ECHO YES | NO
ECHO ON | OFF

INVALID USE OF SPLIT VERTICAL BAR (|)

Ex. ECHO ONOFF, OR ECHO YESNO (WRONG!!!!)

ANOTHER EXAMPLE let say the syntax is like this: SELECT [ALL | DISTINCT | DISTINCTROW]

WHAT ARE THE COMMANDS WE CAN POPULATE?

1. SELECT

2. SELECT ALL

3. SELECT DISTINCT

4. SELECT DISTINCTROW

INVALID: SELECT ALL DISTINCT DISTINCTROW

*WHAT ARE MANDATORY SYNTAX ()<>{} parameter itself

YOU HAVE TO FILL-UP OR PUT SOMETHING INSIDE THOSE SYMBOL
Ex. FORMAT A: the FORMAT only is SYNTAX ERROR.

IN DOS..EXAMPLE run CMD and type DIR /?

*WHAT ARE SWITCHES? / followed by some letters.

EX. /p  /w /d /l

dos_dir

 

OKAY LET US PROCEED IN MYSQL COMMAND LINE HOW TO READ ALL SYNTAX!!!
mysql_help

mysql_help_data_manipulation

mysql_help_select

 SEE THE SYNTAX ABOVE IN RED COLOR? APPLY NOW THE RULES OF SYNTAX I DISCUSSED ON TOP OF THIS PAGE.

HELP IS ALSO ? mysql_help_select_using_question_mark

ENJOY READING ALL COMMANDS!! AND HOW TO APPLY IT 🙂

 IF YOU UNDERSTAND WHAT I DISCUSSED ABOVE YOU CAN LEARN ALL PROGRAMMING LANGUAGES AND COMMANDS.

NOW TEST YOUR IQ AND TRY TO UNDERSTAND HOW TORUN ALL THESE COMMANDS

 http://docs.oracle.com/javase/8/docs/technotes/tools/unix/keytool.html

 IN  LINUX RUN YOUR TERMINAL (CMD)

type “man” for manual….followed by the command

ex. #man ls, man cp, man passwd etc..etc..

Advertisements
This entry was posted in MYSQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s