Hans Zaunere schrieb am Dienstag, 21. August 2001, 17:27:47:
> Can someone explain to me when and when not to use
> single, double, or no quotes at all around values in a
> query. I noticed when I updating an enum field I
> needed a quote, but not when updating an int field.
> Or could someone point me to a good online reference
> on the subject.
Nobody there to give it a try: I guess this is because
programmers are lazy. So they omit quotes if they can. And they
can once it is agreed upon what it means. It is best done with
numbers, because you can check when it begins and ends easily,
but not good with strings and the like for the same reasons.
--
Herzlich
Werner
MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Dr. Werner Stürenburg <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant
/_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany
<___/ www.mysql.com +49-5224-997-407 Fax -409
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
