Помогите разобраться с ошибкой в Sql комманде
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND reserveID IS NOT NULL;
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND (reserveID IS NOT NULL or remark IS NOT NULL);
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
Подскажите хоть что править. Нужно срочно домашку здать, а тут такая байда.
Заранее спасибо.
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND (reserveID IS NOT NULL or remark IS NOT NULL);
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
Подскажите хоть что править. Нужно срочно домашку здать, а тут такая байда.
Заранее спасибо.
Цитата:
Originally posted by ChuOne
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND reserveID IS NOT NULL;
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND (reserveID IS NOT NULL or remark IS NOT NULL);
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
Подскажите хоть что править. Нужно срочно домашку здать, а тут такая байда.
Заранее спасибо.
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND reserveID IS NOT NULL;
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
SELECT * FROM Block WHERE ((qualityID="YBGD" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) OR (qualityID="YBGR" AND len BETWEEN 120 AND 140 OR len BETWEEN 260 AND 280) AND (reserveID IS NOT NULL or remark IS NOT NULL);
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 7
Подскажите хоть что править. Нужно срочно домашку здать, а тут такая байда.
Заранее спасибо.
Разобрался. Тупая ошибка ))
Скобки закрыть одни забыл. Спасибо. Тему можно Close