SQLSTATE[42000]: Syntax error or access violation: 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 ') rgt FROM s_rgt' at line 1
[SQL]SELECT max() rgt FROM s_rgt
SQLSTATE[42000]: Syntax error or access violation: 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 ''8' at line 1
[SQL]UPDATE subject SET s_lft=s_lft-6 WHERE s_rgt>'8
SQLSTATE[42000]: Syntax error or access violation: 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 ''8' at line 1
[SQL]UPDATE subject SET s_rgt=s_rgt-6 WHERE s_lft>'8
SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1
[SQL]SELECT *,(SELECT count(1) FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0  AND s_level<=1 ORDER BY s_level,
SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1
[SQL]SELECT *,(SELECT count(1) FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0  AND s_level<=1 ORDER BY s_level,
SQLSTATE[42000]: Syntax error or access violation: 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 's_sort s_name' at line 1
[SQL]SELECT * FROM subject WHERE s_parent_id=0 ORDER BY s_level s_sort s_name
SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1
[SQL]SELECT * FROM subject WHERE s_parent_id=0 ORDER BY s_level,
SQLSTATE[HY000]: General error: 1364 Field 'create_time' doesn't have a default value
[SQL]INSERT INTO subject (s_id, s_parent_id, s_name, s_lft, s_rgt, s_level) VALUES (NULL, '0', 'A', '1', '2', '0')