MySQL:Interactive Help Desk

From virtualMV2015wiki
Jump to: navigation, search
 Home   Help Desk, MySQL <


On this page you can post some MySQL code that you are having trouble with.

  • Please keep the code "simple" concentrating on the problem ... not a lot of code with a "small" problem.
  • Post a tweet including the #vmvwiki tag so that we know there is a problem waiting to be solved.
  • Paste the following wiki code when you edit, and put your code where shown.

{{vmv:Source|<source lang="javascript">
Code in here

Posting reward scheme

The rules here are:

  • if it is a complex problem, and you solve it you should be rewarded with a small choc from the person posting, however
  • if it is easy to solve a more substantial chocolate "gift" (like a large chocolate fish would be nice :)

Problem 1: UPDATE not working


  ('Michael's Hire and repair Shop','12 Tui St.', 'Napier',
   '(06) 123-4567','(021) 123-4567', '');

This causes a MySQL Error...

Icon References.png References

  1. 8.1.1 Strings (2010) In MySQL 5.0 Reference Manual :: 8 Language Structure :: 8.1 Literal Values, Oracle. Retrieved September 10, 2010 from

MySQL:Interactive Help Desk. (2017). In virtualMV's ( Michael Verhaart ) wiki. Retrieved December 17, 2017, from    (zotero)