Title: Theory / Important / CS / Programming / Query / mysql
Tags: hasNotNewEffectReturnsMeaning computer_to_instruction some_instruction FromInstruction fromCommandLine
On every note of this deck, unless a note says otherwise:
Page: https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
Page: https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html

Page: https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
Location: The first row of tabulars
Chapter: 3
Name: Column description
Context: mysql output

Question: Are query case sensitive
Answer: No
Page: https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
Chapter: 3

Page: https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
Effect: cancel the current query
Language: mysql
Chapter: 3
Abbreviation: \c

Instruction: '>
Effect: Waiting for next line, waiting for completion of a string that began with a single quote (')
Language: mysql
Chapter: 3
Section: 2

Instruction: ">
Effect: Waiting for next line, waiting for completion of a string that began with a double quote (")
Language: mysql
Chapter: 3
Section: 2

Instruction: `>
Effect: Waiting for next line, waiting for completion of a string that began with a backtick (`)
Language: mysql
Chapter: 3
Section: 2

Instruction: />
Effect: Waiting for next line, waiting for completion of a comment that began with (/*)
Language: mysql
Chapter: 3
Section: 2

Question: What to do when your statement is not executed, and pressing enter gives ->
Answer: enter the missing semicolon
Page: https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
Chapter: 3
Section: 2

Instruction: service mysql status
Effect: Show the status of mysql
Language: mysql
Section: 2

Instruction: service mysql stop
Effect: Halting mysql
Language: mysql
Section: 2

Instruction: service mysql start
Effect: Starting mysql
Language: mysql
Section: 2

Instruction: mysql
Effect: An interactive program that enables you
to connect to a MySQL server, run queries, and view the results.
Chapter: 3
Section: 2

Fla: --help
Effect: See a list of options
Prefix: mysql
Chapter: 3
Section: 2

Fla: -h
Effect: host name to which the program must connect. By default the current machine
Prefix: mysql
Chapter: 3
Section: 2

Fla: -u
Effect: give the username for the database connection
Prefix: mysql
Chapter: 3
Section: 2

Fla: -p
Effect: database's password should be asked when the program starts
Prefix: mysql
Chapter: 3
Section: 2

Instruction: QUIT
Effect: Leaving the program
Language: mysql
Context: in program
Chapter: 3
Section: 2

Instruction: VERSION()
Effect: The version of mysql database
Language: mysql
Chapter: 3
Section: 2

Instruction: NOW()
Effect: The current time of mysql server, year-month-day hours:minutes:seconds
Language: mysql
Chapter: 3
Section: 2
Extra: select ?

Instruction: ;
Effect: End of a query
Language: mysql
Chapter: 3
Section: 2

Instruction: mysql>
Effect: Ask for a new query
Language: mysql
Chapter: 3
Section: 2

Fla: ->
Effect: Waiting for next line of multiple-line query
Prefix: mysql
Chapter: 3
Section: 2