I am searching large databases of telephone records. The databases combine domestic and UK calls. I want to create two databases. One database will contain all of the calls to the UK and One database will contain all of the calls to the US. My query for UK calls went perfectly. However, when I query for non-UK calls, I get error messages. What do I do about the syntax?

    Requires Free Membership to View

    Login

Like most computer languages, SQL is picky about the characters used for syntax. Sometimes, "smart quotes" are inserted by some word processors. Stick to straight quotes (') around strings and backticks (`) around identifiers (table and column names).

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top