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' at line 1
[SQL]SELECT * FROM subject ORDER BY s_level s_sort
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 's_name' cannot be null
[SQL]INSERT INTO subject (s_parent_id, s_name, s_level, s_sort) VALUES ('2', NULL, '2', '1')
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
[SQL]SELECT *,(SELECT 1 FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
[SQL]SELECT *,(SELECT 1 FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
[SQL]SELECT *,(SELECT 1 FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
[SQL]SELECT *,(SELECT 1 FROM `subject` WHERE s_parent_id=s.`s_id`) children FROM `subject` s WHERE s_parent_id=0 ORDER BY s_level,s_sort
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 's_level' at row 1
[SQL]UPDATE subject SET s_parent_id='3', s_level=9999999999 WHERE s_id='4'
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 's_level' at row 1
[SQL]UPDATE subject SET s_parent_id='3', s_level=9999999999 WHERE s_id='4'
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 's_sort' at row 1
[SQL]UPDATE subject SET s_parent_id='3', s_sort=9999999999 WHERE s_id='4'