MySQL Prompts

• The following table shows each of the prompts.

  Prompt	Meaning
  mysql>	Ready for new command.
  ->	Waiting for next line of multiple-line command.
  '>	Waiting for next line, waiting for completion of a string that began with a single quote (‘'’).
  ">	Waiting for next line, waiting for completion of a string that began with a double quote (‘"’).
  `>	Waiting for next line, waiting for completion of an identifier that began with a backtick (‘`’).
  /*>	Waiting for next line, waiting for completion of a comment that began with /*.

• It is important to know what the '>, ">, and `> prompts signify.
  • If an unterminated string is entered, any further lines entered appear to be ignored by mysql
    • Including a line containing QUIT.

How do I access a database?

---

---

© 2007 John Michael Pierobon

Notes