Member Avatar for amrita111

Why do we have DIV in mysql when we have /.What is the use of div??

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Bachu
Member Avatar for Bachu

DIV in mysql returns Quotient of two numbers

Exg. If you want to get the Quotient of two fields of a database table
you can use

SELECT  (Field1 DIV Field2)  AS Result  FROM  your_table ;

This query will returns Quotient of Field1/Field2

Edited by Bachu
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.