–û–ø–µ—Ä–∞—Ç–æ—Ä SQL –Ω–µ —Ä–∞–≤–Ω–æ –ø—Ä–µ–¥—Å—Ç–∞–≤–ª–µ–Ω –∫–∞–∫ "& gt ;. –≠—Ç–æ—Ç –æ–ø–µ—Ä–∞—Ç–æ—Ä –ø–æ–∑–≤–æ–ª—è–µ—Ç –≤–∞–º –≤—ã–±–∏—Ä–∞—Ç—å —Å—Ç—Ä–æ–∫–∏ –∏–∑ –±–∞–∑—ã –¥–∞–Ω–Ω—ã—Ö, –∫–æ—Ç–æ—Ä—ã–µ –Ω–µ —Å–æ–æ—Ç–≤–µ—Ç—Å—Ç–≤—É—é—Ç –æ–ø—Ä–µ–¥–µ–ª–µ–Ω–Ω–æ–º—É —É—Å–ª–æ–≤–∏—é. –û–ø–µ—Ä–∞—Ç–æ—Ä! = –ò—Å–ø–æ–ª—å–∑—É–µ—Ç—Å—è –≤ –æ–ø–µ—Ä–∞—Ç–æ—Ä–µ WHERE. –û–ø–µ—Ä–∞—Ç–æ—Ä! = –ú–æ–∂–Ω–æ –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å –≤–º–µ—Å—Ç–æ "& gt; –≤ –Ω–µ–∫–æ—Ç–æ—Ä—ã—Ö —ç–∫–∑–µ–º–ø–ª—è—Ä–∞—Ö SQL.
–í—ã –∫–æ–≥–¥–∞-–Ω–∏–±—É–¥—å —Ö–æ—Ç–µ–ª–∏ –≤—ã–±—Ä–∞—Ç—å —Å—Ç—Ä–æ–∫–∏, –≤ –∫–æ—Ç–æ—Ä—ã—Ö —Å–æ–¥–µ—Ä–∂–∏–º–æ–µ –ø–æ–ª—è –Ω–µ —Ä–∞–≤–Ω–æ –æ–ø—Ä–µ–¥–µ–ª–µ–Ω–Ω–æ–º—É –∑–Ω–∞—á–µ–Ω–∏—é? –í–∞–º –ø–æ–≤–µ–∑–ª–æ, –ø–æ—Ç–æ–º—É —á—Ç–æ –≤ SQL –µ—Å—Ç—å –æ–ø–µ—Ä–∞—Ç–æ—Ä, —Å–æ–∑–¥–∞–Ω–Ω—ã–π –¥–ª—è —ç—Ç–æ–π —Ü–µ–ª–∏.
–í—ã –º–æ–∂–µ—Ç–µ –≤—ã–±–∏—Ä–∞—Ç—å —Å—Ç—Ä–æ–∫–∏ –≤ –∑–∞–≤–∏—Å–∏–º–æ—Å—Ç–∏ –æ—Ç —Ç–æ–≥–æ, —è–≤–ª—è–µ—Ç—Å—è –ª–∏ –æ–¥–Ω–æ –∏–ª–∏ –Ω–µ—Å–∫–æ–ª—å–∫–æ –∏—Ö –ø–æ–ª–µ–π " values ‚Äã‚Äã–Ω–µ —Ä–∞–≤–Ω–æ –æ–ø—Ä–µ–¥–µ–ª–µ–Ω–Ω–æ–º—É –∑–Ω–∞—á–µ–Ω–∏—é.
–í —ç—Ç–æ–º —Ä—É–∫–æ–≤–æ–¥—Å—Ç–≤–µ –º—ã —Å–æ–±–∏—Ä–∞–µ–º—Å—è –ø–æ–≥–æ–≤–æ—Ä–∏—Ç—å –æ–± –∏—Å–ø–æ–ª—å–∑–æ–≤–∞–Ω–∏–∏ –æ–ø–µ—Ä–∞—Ç–æ—Ä–∞ SQL not equal. –ú—ã –æ–±—Ä–∞—Ç–∏–º—Å—è –∫ –ø—Ä–∏–º–µ—Ä—É, –∫–æ—Ç–æ—Ä—ã–π –ø–æ–º–æ–∂–µ—Ç –≤–∞–º –Ω–∞—á–∞—Ç—å —Ä–∞–±–æ—Ç—É.
SQL Not Equal
–û–ø–µ—Ä–∞—Ç–æ—Ä SQL Not Equal - "& gt ;. –í—ã –¥–æ–ª–∂–Ω—ã —É–∫–∞–∑–∞—Ç—å —ç—Ç–æ –≤ –∏–Ω—Å—Ç—Ä—É–∫—Ü–∏–∏ WHERE. –≠—Ç–æ –ø–æ–∑–≤–æ–ª—è–µ—Ç –≤–∞–º –≤—ã–±–∏—Ä–∞—Ç—å —Å—Ç—Ä–æ–∫–∏, –≤ –∫–æ—Ç–æ—Ä—ã—Ö —Å–æ–¥–µ—Ä–∂–∏–º–æ–µ –æ–ø—Ä–µ–¥–µ–ª–µ–Ω–Ω–æ–≥–æ —Å—Ç–æ–ª–±—Ü–∞ –Ω–µ —Å–æ–≤–ø–∞–¥–∞–µ—Ç —Å —É–∫–∞–∑–∞–Ω–Ω—ã–º –≤–∞–º–∏ –∑–Ω–∞—á–µ–Ω–∏–µ–º. –í—ã —Ç–∞–∫–∂–µ –º–æ–∂–µ—Ç–µ –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å! = –ö–∞–∫ –æ–ø–µ—Ä–∞—Ç–æ—Ä "–Ω–µ —Ä–∞–≤–Ω–æ" –≤ –Ω–µ–∫–æ—Ç–æ—Ä—ã—Ö –≤–µ—Ä—Å–∏—è—Ö SQL.
–î–∞–≤–∞–π—Ç–µ –≤–∑–≥–ª—è–Ω–µ–º –Ω–∞ —Ç–∏–ø–∏—á–Ω—ã–π –∑–∞–ø—Ä–æ—Å –≤ SQL:
–û–ø–µ—Ä–∞—Ç–æ—Ä SQL SELECT –ø—Ä–æ—Å–º–∞—Ç—Ä–∏–≤–∞–µ—Ç –∏–º–µ–Ω–∞ —Å—Ç–æ–ª–±—Ü–æ–≤ –∏–∑ —É–∫–∞–∑–∞–Ω–Ω–æ–π —Ç–∞–±–ª–∏—Ü—ã (–≤ –¥–∞–Ω–Ω–æ–º —Å–ª—É—á–∞–µ —ç—Ç–æ –∏–º–µ–Ω–∞). –ü—Ä–µ–¥–ª–æ–∂–µ–Ω–∏–µ SQL WHERE - —ç—Ç–æ —Ç–æ –º–µ—Å—Ç–æ, –≥–¥–µ –Ω–∞—à–µ —É—Å–ª–æ–≤–Ω–æ–µ –≤—ã—Ä–∞–∂–µ–Ω–∏–µ –±—É–¥–µ—Ç –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å—Å—è –¥–ª—è –æ–ø–µ—Ä–∞—Ç–æ—Ä–∞ not equal.
–í —Ç—Ä–∞–¥–∏—Ü–∏–æ–Ω–Ω–æ–º —Å—Ç–∞–Ω–¥–∞—Ä—Ç–Ω–æ–º SQL SQL - —Å–∏–º–≤–æ–ª, –∫–æ—Ç–æ—Ä—ã–π –ø—Ä–µ–¥—Å—Ç–∞–≤–ª—è–µ—Ç —Å–æ–±–æ–π –Ω–µ —Ä–∞–≤–Ω–æ "& gt ;. –í –¥—Ä—É–≥–∏—Ö –≤–µ—Ä—Å–∏—è—Ö –º–æ–∂–Ω–æ –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å! =. –ï—Å–ª–∏ –≤—ã –Ω–µ —É–≤–µ—Ä–µ–Ω—ã, —á—Ç–æ –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å, –ø—Ä–∏–¥–µ—Ä–∂–∏–≤–∞–π—Ç–µ—Å—å —Å—Ç–∞–Ω–¥–∞—Ä—Ç–∞, –ø–æ—Å–∫–æ–ª—å–∫—É –æ–Ω —Ç–æ—á–Ω–æ —Ä–∞–±–æ—Ç–∞–µ—Ç. –î—É–º–∞—é, —á—Ç–æ "–≤–∑—Ä—ã–≤–Ω–æ–µ —Ä–∞–≤–µ–Ω—Å—Ç–≤–æ" –±—ã–ª–æ —Å–æ–∑–¥–∞–Ω–æ, –ø–æ—Ç–æ–º—É —á—Ç–æ –æ–Ω–æ –ø–æ—Ö–æ–∂–µ –Ω–∞ —Ç–æ, –∫–∞–∫ –¥—Ä—É–≥–∏–µ —è–∑—ã–∫–∏ –ø—Ä–æ–≥—Ä–∞–º–º–∏—Ä–æ–≤–∞–Ω–∏—è –ø—Ä–µ–¥—Å—Ç–∞–≤–ª—è—é—Ç –ø—É–Ω–∫—Ç "–Ω–µ—Ä–∞–≤–µ–Ω—Å—Ç–≤–æ".
81% —É—á–∞—Å—Ç–Ω–∏–∫–æ–≤ –∑–∞—è–≤–∏–ª–∏, —á—Ç–æ –æ–Ω–∏ –ø–æ—á—É–≤—Å—Ç–≤–æ–≤–∞–ª–∏ —Å–µ–±—è –±–æ–ª–µ–µ —É–≤–µ—Ä–µ–Ω–Ω—ã–º–∏ –≤ —Å–≤–æ–∏—Ö –ø–µ—Ä—Å–ø–µ–∫—Ç–∏–≤–∞—Ö —Ä–∞–±–æ—Ç—ã –≤ —Å—Ñ–µ—Ä–µ —Ç–µ—Ö–Ω–æ–ª–æ–≥–∏–π –ø–æ—Å–ª–µ –ø–æ—Å–µ—â–µ–Ω–∏—è —É—á–µ–±–Ω–æ–≥–æ –ª–∞–≥–µ—Ä—è. –ü—Ä–æ–π–¥–∏—Ç–µ –∫—É—Ä—Å –æ–±—É—á–µ–Ω–∏—è —Å–µ–≥–æ–¥–Ω—è.
–°—Ä–µ–¥–Ω–∏–π –≤—ã–ø—É—Å–∫–Ω–∏–∫ —É—á–µ–±–Ω–æ–≥–æ –ª–∞–≥–µ—Ä—è –ø–æ—Ç—Ä–∞—Ç–∏–ª –º–µ–Ω–µ–µ —à–µ—Å—Ç–∏ –º–µ—Å—è—Ü–µ–≤ –Ω–∞ —Å–º–µ–Ω—É –∫–∞—Ä—å–µ—Ä—ã, –æ—Ç –Ω–∞—á–∞–ª–∞ —É—á–µ–±–Ω–æ–≥–æ –ª–∞–≥–µ—Ä—è –¥–æ –ø–æ–∏—Å–∫–∞ —Å–≤–æ–µ–π –ø–µ—Ä–≤–æ–π —Ä–∞–±–æ—Ç—ã.
–ú—ã —Å–æ–±–∏—Ä–∞–µ–º—Å—è —Å–æ–∑–¥–∞—Ç—å —Ç–∞–±–ª–∏—Ü–∞ —Å –Ω–∞–∑–≤–∞–Ω–∏–µ–º " names & rdquo ;. –ú—ã —Å–æ–±–∏—Ä–∞–µ–º—Å—è –¥–æ–±–∞–≤–∏—Ç—å –Ω–µ—Å–∫–æ–ª—å–∫–æ –∑–∞–ø–∏—Å–µ–π –≤ —ç—Ç—É —Ç–∞–±–ª–∏—Ü—É. –ó–∞—Ç–µ–º –º—ã –±—É–¥–µ–º –∏—Å–ø–æ–ª—å–∑–æ–≤–∞—Ç—å —Å–∏–º–≤–æ–ª "–Ω–µ —Ä–∞–≤–Ω–æ" –¥–ª—è –∑–∞–ø—Ä–æ—Å–∞ –¥–∞–Ω–Ω—ã—Ö –∏–∑ —Ç–∞–±–ª–∏—Ü—ã:
–Ø –∏—Å–ø–æ–ª—å–∑–æ–≤–∞–ª –æ–±–∞ —Ç–µ–≥–∞ "& gt; –∏! =, —á—Ç–æ–±—ã –ø–æ–∫–∞–∑–∞—Ç—å, —á—Ç–æ –æ–±–∞ —Ä–∞–±–æ—Ç–∞—é—Ç –≤ —ç—Ç–æ–º —Å–ª—É—á–∞–µ. –Ø –∏—Å–ø–æ–ª—å–∑—É—é sqlite3 –≤ –ø–µ—Å–æ—á–Ω–∏—Ü–µ Repl.it –¥–ª—è —Ä–∞–∑–º–µ—â–µ–Ω–∏—è —ç—Ç–æ–π –±–∞–∑—ã –¥–∞–Ω–Ω—ã—Ö. –í–∞—à –æ–ø—ã—Ç –º–æ–∂–µ—Ç –æ—Ç–ª–∏—á–∞—Ç—å—Å—è, –µ—Å–ª–∏ –≤—ã –∏—Å–ø–æ–ª—å–∑—É–µ—Ç–µ –¥—Ä—É–≥–æ–π —Ä–µ–¥–∞–∫—Ç–æ—Ä –∫–æ–¥–∞ –∏–ª–∏ —Å—Ä–µ–¥—É –ø–µ—Å–æ—á–Ω–∏—Ü—ã SQL.
–ù–∞–±–æ—Ä —Ä–µ–∑—É–ª—å—Ç–∞—Ç–æ–≤ –∏–∑ –Ω–∞—à–µ–≥–æ –æ–ø–µ—Ä–∞—Ç–æ—Ä–∞ SQL –ø–æ–∫–∞–∑—ã–≤–∞–µ—Ç:
–ù–∞—à –∑–∞–ø—Ä–æ—Å –≤–æ–∑–≤—Ä–∞—â–∞–µ—Ç –≤—Å–µ –∑–∞–ø–∏—Å–∏, –≥–¥–µ " name " –Ω–µ —Ä–∞–≤–Ω–æ " Christina & rdquo ;. & Ldquo; id " –Ω–µ –¥–æ–ª–∂–Ω–æ –±—ã—Ç—å —Ä–∞–≤–Ω–æ 7, —á—Ç–æ–±—ã –∑–∞–ø–∏—Å—å –±—ã–ª–∞ –≤–æ–∑–≤—Ä–∞—â–µ–Ω–∞. –¢—ã —Å–¥–µ–ª–∞–ª —ç—Ç–æ! –í–æ—Ç –∫–∞–∫ –≤—ã –∏—Å–ø–æ–ª—å–∑—É–µ—Ç–µ –æ–ø–µ—Ä–∞—Ç–æ—Ä —Å—Ä–∞–≤–Ω–µ–Ω–∏—è –Ω–µ —Ä–∞–≤–Ω–æ –≤ SQL.
–ó–∞–∫–ª—é—á–µ–Ω–∏–µ
–í—ã –º–æ–∂–µ—Ç–µ –≤—ã–±—Ä–∞—Ç—å —Å—Ç—Ä–æ–∫–∏ –∏–∑ –±–∞–∑—ã –¥–∞–Ω–Ω—ã—Ö, —Å–æ–¥–µ—Ä–∂–∏–º–æ–µ –∫–æ—Ç–æ—Ä—ã—Ö –Ω–µ —Å–æ–æ—Ç–≤–µ—Ç—Å—Ç–≤—É–µ—Ç –æ–ø—Ä–µ–¥–µ–ª–µ–Ω–Ω–æ–º—É –∑–Ω–∞—á–µ–Ω–∏—é, –∏—Å–ø–æ–ª—å–∑—É—è SQL not equal –æ–ø–µ—Ä–∞—Ç–æ—Ä. –í –±–æ–ª—å—à–∏–Ω—Å—Ç–≤–µ –≤–µ—Ä—Å–∏–π SQL –æ–ø–µ—Ä–∞—Ç–æ—Ä "–Ω–µ —Ä–∞–≤–Ω–æ" –ø—Ä–µ–¥—Å—Ç–∞–≤–ª—è–µ—Ç —Å–æ–±–æ–π –∑–Ω–∞–∫ "–º–µ–Ω—å—à–µ", –∑–∞ –∫–æ—Ç–æ—Ä—ã–º —Å–ª–µ–¥—É–µ—Ç –∑–Ω–∞–∫ "–±–æ–ª—å—à–µ" ("& gt;).
–í–æ—Å–∫–ª–∏—Ü–∞—Ç–µ–ª—å–Ω—ã–π –∑–Ω–∞–∫, –∑–∞ –∫–æ—Ç–æ—Ä—ã–º —Å–ª–µ–¥—É–µ—Ç –∑–Ω–∞–∫ —Ä–∞–≤–µ–Ω—Å—Ç–≤–∞ (! =), –î–æ—Å—Ç—É–ø–µ–Ω –∫–∞–∫ –æ–ø–µ—Ä–∞—Ç–æ—Ä –Ω–µ —Ä–∞–≤–Ω–æ –≤ –Ω–µ–∫–æ—Ç–æ—Ä—ã—Ö –≤–µ—Ä—Å–∏—è—Ö SQL. –≠—Ç–æ—Ç –æ–ø–µ—Ä–∞—Ç–æ—Ä –ø–æ–∑–≤–æ–ª—è–µ—Ç —Å—Ä–∞–≤–Ω–∏—Ç—å –¥–≤–∞ –≤—ã—Ä–∞–∂–µ–Ω–∏—è, —á—Ç–æ–±—ã —É–≤–∏–¥–µ—Ç—å, –Ω–µ —Ä–∞–≤–Ω—ã –ª–∏ –æ–Ω–∏ –¥—Ä—É–≥ –¥—Ä—É–≥—É.