> >>> I wonder how I'll get a div-function in SQL? > >> > >> I dunno, maybe by looking in the manual? From [1]: > >> > >> Division: > >> > >> mysql> SELECT 3/5; > >> -> 0.60 > >> > >> [1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html > >> > > > > Gustav is looking for the DIV-function. > > > > But it is there > > > > |DIV| > > > > Integer division. Similar to |FLOOR()| but safe with |BIGINT| values. > > He never said he wanted integer division... he just said "I want to > divide t[w]o columns and make a new column based on the result."
Ehm, no. He specifically asked for a DIV function, not a "division". :-) See above. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
