The records with Dept_number==1 start in block 0
The records with Dept_number==2 start in block 0
The records with Dept_number==3 start in block 1
The records with Dept_number==4 start in block 2
The records with Dept_number==5 start in block 3
The records with Dept_number==6 start in block 4
The records with Dept_number==8 start in block 5
but it returns nothing when the passed value is null and I do have null in the table!
here is my stored procedure:
JOIN assets$status ON `assets$status`.status_id = assets$audit.audit_status
LEFTJOIN assets$conditions ON `assets$conditions`.condition_id = assets$audit.audit_condition
WHERE item_id = param_item_id
AND location = param_loaction
AND floor = param_floor
AND room = param_room
AND department = param_department
AND employee = param_employee
ORDERBY audit_date DESC, created_date DESC;
Read and understand this visual explanation of sql joins[^] then you will have an idea of what is happening.
You may not have a null value in the table but you certainly have a left join which will return nulls if there is no corresponding row on the right side of the join.
“That which can be asserted without evidence, can be dismissed without evidence.”
In one table i am having 30 columns,in each column i mentioned data type as long text with character set as utf-8.When i am inserting the text from c# it only saving some limited number of characters,It is not saving full text.I want to insert long type text to almost to 30 columns I tried with changing different data types and character sets but not working.Please help me in getting this mysql problem.Example text from c# to insert in mysql column