SQL - Text Fields vs. Numeric Fields Knowledge Based Info. MySQL SQL requires single quotes around text values (most database systems will also allow double quotes). However, numeric fields should not be enclosed in quotes: Example SELECT * FROM CustomersWHERE CustomerID=1; Try it Yourself » Share this Share on FacebookTweet on TwitterPlus on Google+
EmoticonEmoticon