title: VB.Net Sql Server and MariaDB
body: <p>I'm Joinnes. I want to ask about query to count attempt when insert multiple data into MariaDB. I'm now developing API with Vb.Net code. I want to count 'attempt' when i insert data into MariaDB. in Sql I have AWB,Date,Time,Status,Recipient,Station,ReasonCode,ReasonNote field and in MariaDB i have ID,AWB,Tracking Number,Status,TimeStamp,Comment,Station,Recipient,Relation,ReasonCode,ReasonNote,Attempt,Username,RequestID,Flag field. The scenario is when i insert data into MariaDB how i count attempt if i have multiple same AWB according the status. so if there's three same Status insert with same AWB how to count each status and insert it into attempt column?</p>
  
  <p>Note:
  Status explain : OD=OnDelivery ; AR=Arrival ; UN=Undelivered ; OK=Success ; RT=Retur</p>
  
  <p>If Status 'UN' greater then one with one AWB, how i count the 'attemmpt' using query and how to insert it into 'attemmpt' column in MariaDB?</p>
  
  <p>Thanks before guys.</p>