{"draftJsState":{"blocks":[{"data":{"image":{"id":"5ffb4c4af906b168727808cb"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"6tp8q"},{"data":{"embedData":{"type":"yandex-zen-video","uuid":"vLmyzDgXfND8","previewImageData":{"id":"62642985990a4a6a1129f2a1","groupId":4612968,"imageName":"pub_626429759940f20000b9515b_62642985990a4a6a1129f2a1","namespace":"zen_doc","meta":{"mainColor":"#F8F8F8","origFormat":"JPEG"}},"publisherId":"5f05cddf279db10362034d3a","publicationId":"626429759940f20000b9515b","publisherName":"ГАУС IT","publisherAvatar":{"id":"5ff58a02fe4e686f6a248da3","groupId":200214,"imageName":"pub_5f05cddf279db10362034d3a_5ff58a02fe4e686f6a248da3","namespace":"zen-logos","meta":{"mainColor":"#F8F8F8","origFormat":"PNG"}},"isPublisherVerified":false,"subscribersCount":12,"publishTime":1650731444385,"title":"Урок #10 - Экранирование. Приоритет","duration":0,"customParams":{"signed_url":"193I1FI-acUa9tjcnsnPPDZFBgeRn7keVXpVXnNu157_V3XFfUj3k2wvv9XbSXJ0POsB-p8Tx6Y"}}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:embed","key":"a58rg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"7rfco"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Экранирование","type":"header-two","key":"9q56q"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Первая часть этой статьи будет посвящена экранированию. ","type":"unstyled","key":"8mmmf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":20,"style":"BOLD"}],"text":"Возьмем для примера UPDATE xml в базе данных. ","type":"unstyled","key":"4otqp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":22,"style":"BOLD"},{"length":2,"offset":52,"style":"BOLD"},{"length":7,"offset":57,"style":"BOLD"}],"text":"У нас имеется таблица TABLE, в которой есть колонки ID и XMLTEXT и нам надо обновить текст xml. Выглядит она вот так:","type":"unstyled","key":"136qs"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":" <\\a>","type":"blockquote","key":"2vnnk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":88,"style":"BOLD"}],"text":"Суть xml нам не интересна, нам важны кавычки. Как вы знаете из предыдущих наших статей, UPDATE пишется следующим образом:","type":"unstyled","key":"dbhvu"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":0,"style":"BOLD"}],"text":"UPDATE TABLE","type":"blockquote","key":"frjd"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":0,"style":"BOLD"}],"text":"SET XMLTEXT = ‘ <\\a>’","type":"blockquote","key":"5vj3u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":0,"style":"BOLD"}],"text":"WHERE ID = 1","type":"blockquote","key":"7p68a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Но тут возникает проблема, ведь строка заканчивается здесь:","type":"unstyled","key":"d0lbn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"‘ <\\a>’","type":"blockquote","key":"923sg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":0,"style":"BOLD"}],"text":"WHERE ID = 1","type":"blockquote","key":"cje1t"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Порядок выполнения действий","type":"header-two","key":"2pott"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Во второй части я затрону момент с порядком выполнения действий.","type":"unstyled","key":"8p68s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Логические операторы при отсутствии скобок, как и арифметические операторы, выполняются в соответствии с их старшинством.","type":"unstyled","key":"4564h"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":21,"style":"BOLD"},{"length":3,"offset":87,"style":"BOLD"}],"text":"Одноместная операция NOT имеет наивысший приоритет. Следующий приоритет имеет оператор AND. ","type":"unstyled","key":"991q6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Вот вам пример для проверки понимания приоритета, можете писать свой вариант решения в комментарии, я лайкну правильный ответ или отвечу на него:","type":"unstyled","key":"dqcgv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":6,"offset":0,"style":"BOLD"}],"text":"DELETE TABLE","type":"blockquote","key":"9ur04"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":5,"offset":0,"style":"BOLD"},{"length":4,"offset":14,"style":"BOLD"}],"text":"WHERE COLUMN1 LIKE '472__'","type":"blockquote","key":"9ua54"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":0,"style":"BOLD"}],"text":"AND COLUMN2 >= 1000","type":"blockquote","key":"5gg13"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":0,"style":"BOLD"}],"text":"AND COLUMN2 <= 500","type":"blockquote","key":"d3gfn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":2,"offset":0,"style":"BOLD"},{"length":4,"offset":11,"style":"BOLD"}],"text":"OR COLUMN1 LIKE '471__'","type":"blockquote","key":"4tl36"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":0,"style":"BOLD"}],"text":"AND COLUMN2 >= 5000","type":"blockquote","key":"ci9r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":0,"style":"BOLD"}],"text":"AND COLUMN2 <= 1200","type":"blockquote","key":"6v2p1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"17dp4"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Если вы не уверены, что точно помните порядок выполнения логических операторов, ставьте скобки!","type":"blockquote","key":"bi3t3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Если у вас есть интересные примеры которые вы хотите разобрать пишите их в комментариях может ваши примеры попадут в следующие статьи.","type":"unstyled","key":"bj4q0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"3fc2u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":144,"offset":0,"style":"ITALIC"}],"text":"Если статья была Вам полезна, ставьте пальцы вверх и подписывайтесь. Оставляйте свои пожелания и вопросы в комментариях, с удовольствием отвечу.","type":"unstyled","key":"b3bet"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":1,"offset":0,"style":"ITALIC"}],"text":"#it #sql #обучение #курс #программирование ","type":"unstyled","key":"b1nd1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"338pj"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"DXjoRHOoj9yji3IEStIT"}],"entityMap":{}},"mentions":[]}